Course Description

This 1-day Access 2010 Introduction training course is intended for students who have no prior knowledge of Access 2010.

After completing this course, students will know how to:

  • Organize data efficiently by using a database management system; start Access, open Access databases and identify components of the Access window; and use the Help feature.
  • Plan and create a database; use Datasheet view and Design view; create, modify, and work in tables; and set the primary key for a table.
  • Modify a table’s design; use the Attachment data type; find and replace values; and sort, filter, and delete records.
  • Set field properties; create input masks; and set validation rules.
  • Create queries, and sort and filter the results; modify queries; and perform operations in queries.
  • Create, modify, and work with forms; and use them to sort and filter records.
  • Create, modify, and print reports; and add summary fields to a report.

Pre-requisites

Windows XP Introduction, Windows Vista Introduction, Windows 7 Introduction or equivalent experience.

Who is this course for?

For students who have little or no knowledge of Access 2010.

Further Training

The next training course in our Access 2010 series is Access 2010 Intermediate.

Course content

Getting started
Database concepts
Exploring the Access environment
Getting help
Databases and tables
Planning and designing databases
Exploring tables
Creating tables
Fields and records
Changing the design of a table
Finding and editing records
Organizing records
Data entry rules
Setting field properties
Working with input masks
Setting validation rules
Basic queries
Creating and using queries
Modifying query results and queries
Performing operations in queries
Using forms
Creating forms
Using Design view
Sorting and filtering records
Working with reports
Creating reports
Modifying and printing reports