Certificate In Access 2013 Essentials Online Course

Courses For Success

Price on request

Important information

  • Course
  • Online
  • When:

Learn the Basic Features of Access 2013 Access is the world’s premier database software. You can use Access to create and edit databases, just download a ready-made database template and start typing.  It’s that easy.  You can create a database of contacts, expenses, household and/or business inventory.  In other words, if you have data, you can create a database of that data using Access. This course is designed to teach you a deeper understanding of Access 2013 in a practical way. You will learn how to use the basic features of Access to help better manage a database. Access 2013 features a new framework that is designed for one purpos, to enable users to create data-centric web applications. Taking the time to learn the basic features of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier. By the end of this Certificate In Access 2013 Essentials Online Course, you will be able to: Use the Access interface and understand security warnings Understand database terms, tables, relationships, and other Access terms Share data using apps Work in an App Understand desktop database basics Perform basic table tasks Work with fields and records Perform basic tasks for queries, forms, and reports Protect database data Course Fast Facts: Easy to follow and understand Only 6 to 8 hours of study is required 12 months access to course Delivered 100% on-line and accessible 24/7 from any computer or smartphone You can study from home or at work, at your own pace, in your own time Download printer friendly course content Certificate (IAOTS Accredited) Course Delivery Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone. Recognition & Accreditation This course is internationally recognized and accredited by the International Association of...

Important information

Requirements: Entry requirements Students must have basic literacy and numeracy skills. Minimum education Open entry. Previous schooling and academic achievements are not required for entry into this course. Computer requirements Students will need access to a computer and the internet. For students who do not have access to either a computer or the internet. Minimum specifications for the computer are: Windows: ...


Where and when

Starts Location

What you'll learn on the course

Basic IT training
Database training
Basic IT

Course programme


Module One: Getting Started

  • Course Objectives

Module Two: Opening and Closing Access

  • Lesson One: Opening Access
  • Lesson Two: Using the Recent List and Opening Files
  • Lesson Three: About Your Account
  • Lesson Four: Closing Files vs. Closing Access

Module Three: An Introduction to Databases

  • Lesson One: About Common Database Terms
  • Lesson Two: Using the Navigation Pane
  • Lesson Three: Understanding Tables and Table Relationships
  • Lesson Four: Understanding Queries
  • Lesson Five: Closing Database Objects

Module Four: Sharing Data Using Apps

  • Lesson One: Creating a New App Using a Template
  • Lesson Two: Select a Table Template
  • Lesson Three: Creating a Table By Importing Data
  • Lesson Four: Launching the App

Module Five: Working in Your App

  • Lesson One: Using the Search Box
  • Lesson Two: Using the Action Bar for Predefined Actions
  • Lesson Three: Working with Related Items and AutoComplete
  • Lesson Four: Grouping Data

Module Six: An Introduction to Desktop Databases

  • Lesson One: Working with a Table in Datasheet View
  • Lesson Two: About Keys, Data Types and Fields
  • Lesson Three: Searching for Records
  • Lesson Four: Deleting Records

Module Seven: Performing Basic Table Tasks

  • Lesson One: Entering and Editing Data
  • Lesson Two: Using the Clipboard
  • Lesson Three: Formatting Text
  • Lesson Four: Finding and Replacing Text

Module Eight: Working with Fields

  • Lesson One: Adding a Field by Entering Data
  • Lesson Two: Adding a Specific Type of Field
  • Lesson Three: Changing Field Name, Caption, or Description
  • Lesson Four: Changing the Data Type
  • Lesson Five: Changing Field Format
  • Lesson Six: Deleting a Field

Module Nine: Working with Table Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Ediiting Relationships
  • Lesson Four: Establising Referential Integrity

Module Ten: An Introduction to Queries, Forms, and Reports

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Understanding Forms
  • Lesson Five: Understanding Reports

Module Eleven: Protecting Your Data

  • Lesson One: Planning Backups
  • Lesson Two: Backing Up a Database
  • Lesson Three: Restoring a Database
  • Lesson Four: Restoring Objects in a Database

Module Twelve: