Access 2010 - Using Forms and Data Input

ACC-10-02

Duration

2 hours

Who should attend?

Anyone who is responsible for inputting data into an existing Access database.

Pre-requisites

No previous experience of database programs is required.

Objectives

To understand how to negotiate Access forms. Delegates will learn to search, sort and filter information to locate specific records.

Course Content

Database Basics

Understand tables, records and fields. Access objects.

Data Entry

Add, edit and delete data. Save a record.

Forms

Form and datasheet views. Use the navigation bar to move between records. Keystrokes for moving between fields on a form/subform. Find a specific record. Filter displayed data, sort records in ascending/descending order. Save a record.

Reports

Print and preview existing reports.