Certificate In Access 2010 Essentials Online Course

Courses For Success

Price on request

Important information

  • Course
  • Online
  • When:

Learn the Basic Features of Access 2010 Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. You will learn how to use the basic features of Access 2010.  Access is the world’s premier database software. You can use Access 2010 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. By the end of this Certificate In Access 2010 Essentials Online Course, you will be able to: Understand common database terms Open and close Access Create a blank database or a database from a template Understand the interface and the Ribbon tools Understand the Backstage View Use the Navigation Pane Work with database objects Sort and filter the view Create a blank table from a template, in Datasheet view, and Design View Use Lookup columns in a table Add information to a table Edit, delete and search records Save a table Create a Navigation Form Create a form with the Wizard and in Layout View Modify a form in Design View Perform common formatting tasks on forms Use Themes Add or move controls on a form Create reports using the Report Wizard Understand the Report Design View Add a Logo to a report Create Queries using the Wizard Execute a Query Understand the Query Design View Understand Access file formats and save a database as another file format Print an Object Back up the database Email the database 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...

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. Minimum specifications for the computer are: Windows: Microsoft Windows XP, or later ...


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: Getting Started With Access

  • Lesson One: Common Database Terms
  • Lesson Two: Opening Access
  • Lesson Three: Understanding the Access New File Screen
  • Lesson Four: Creating a Blank Access Database
  • Lesson Five: Creating a Blank Database from a Template

Module Three:  Using the Access Interface

  • Lesson One: Understanding Security Warnings
  • Lesson Two: Interface Overview
  • Lesson Three: Overview of the Ribbon Interface
  • Lesson Four: Working With the Backstage View
  • Lesson Five: Using the Navigation Pane

Module Four:  Working with Database Objects

  • Lesson One: Viewing Database Objects
  • Lesson Two: Exporting an Object
  • Lesson Three: Renaming an Object
  • Lesson Four: Sorting and Filtering Your View
  • Lesson Five: Understanding Application Parts

Module Five: Creating Tables

  • Lesson One: Understanding Data Types
  • Lesson Two: Creating a Blank Table in Datasheet View
  • Lesson Three: Understanding Lookup Columns
  • Lesson Four: Creating a Blank Table Using Design View
  • Lesson Five: Saving Your Table
  • Lesson Six: Key Table Tools

Module Six: Working with Tables

  • Lesson One: Adding Information to a Table
  • Lesson Two: Editing Records
  • Lesson Three: Deleting Records
  • Lesson Four: Searching for Records

Module Seven: Creating Forms

  • Lesson One: Types of Controls
  • Lesson Two: Creating a Form with the Wizard
  • Lesson Three: Creating a Form in Layout View
  • Lesson Four: Modifying Your Form in Design View
  • Lesson Five: Key Features on the Form Tools Tab
  • Lesson Six: Creating a Navigation Form

Module Eight: Working with Forms

  • Lesson One: Common Formatting Tasks
  • Lesson Two: Using Themes
  • Lesson Three: Adding Controls
  • Lesson Four: Moving Controls
  • Lesson Five: Deleting Records

Module Nine: Creating Reports

  • Lesson One: Using The Report Wizard
  • Lesson Two: Using Design View
  • Lesson Three: Adding a Logo
  • Lesson Four: Working with Controls
  • Lesson Five: Key Features on the Report Tools

Module Ten: Creating Queries

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Viewing the Query
  • Lesson Five: Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

  • Lesson One: Using Alternate File Formats
  • Lesson Two: Printing an Object
  • Lesson Three: Backing Up Your Database 
  • Lesson Four: Emailing Database Objects

Module Twelve: Wrapping Up
Words from the Wise

  • Store your data using Access tables.
  • Use forms to easily manage data collection tasks of adding, changing or deleting data one record at a time.
  • Create queries to see subsets of your data or to perform actions to your data.
  • Use reports to view table or query data in a polished format.