Access

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 a 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.

Delivery:	Other
Regions:	North West England London
Category:	Microsoft Access