Access Proficient 2003

This very popular Access course will equip you with all the skills you need to build databases in Microsoft Access.
In only 20 study hours at our comfortable training centre, you'll grow from novice to intermediate in database design.
Not only will you receive a quality workbook to keep for future reference, at the end of the course, provided you pass our exam, you'll receive a handsome Pitman Training certificate - proof of your skill level! >What Is Covered.
Lesson 1: Understand the following terms - table, record, field, query, form, report, common field, one-to-one relationship, one-to-many relationship, primary key and foreign key. Understand the planning and design of an Access database containing related tables and recognise relationships between tables. Use the Office Assistant.

Lesson 2: Define fields, data types and properties for three tables using design view. Enter data into tables using datasheet view. Set primary keys and establish relationships. Navigate records in a table. Use the Lookup Wizard to create a field that looks up data from another table and to establish a relationship. Use Find to locate specific entries. Sort records. Use the Table Wizard to create a table, modify the table design and enter data into the table. Use the Input Mask Wizard.

Lesson 3: Edit data in form and datasheet views. Add new records. Change page orientation. Enforce referential integrity in a relationship. Work with controls in form design.

Lesson 4: Import a table from an external database. Use a junction table to resolve a many to many relationship. Add a new field to a form. Use a calculated control on a form. Create a query. Use criteria to retrieve selected data. Create and name a calculated field in a query.

Lesson 5: Add a field with data validation in a table. Enter data using a Form/Sub form combination. Perform summary calculations on a group of records in a Query. Create and modify the design of a Report. Save a table as a Web page. Add a hyperlink in an existing Web page