• Identify advantages of a relational database.
• Identify the basics of a relational database.
• Sequence the steps for planning a relational database.
• Create a table in Datasheet view.
• Identify features of the Table Wizard
• Create a table in Design view.
• Identify features of relationships between tables.
• Create a one-to-many relationship between tables.
• Sequence the steps to define a many-to-many relationship between two tables.

The intended audiences for this course are Project or Office Managers, Secretarial, Web Designer-Developers, System Administrators, Database Administrators. Access 2002 Fundamentals doesn't require any previous database knowledge. Its audience could include a range of other job types such as Junior Secretarial, Customer Service etc. Typically learners will work in an office environment (possibly networked) producing documents/spreadsheets and/or databases/Web pages. Learners will need a basic knowledge of either Microsoft Office 97 or 2000 programs and be familiar with Windows 9X or later operating system(s).

• Identify advantages of a relational database.
• Identify the basics of a relational database.
• Sequence the steps for planning a relational database.
• Open a database by using Microsoft Access.
• Match database objects with their features.
• Identify the functions of each database object view.
• Create a blank database.
• Identify the options available when creating a database by using a database template.
• Get help by using the Office Assistant.
• Identify features of the Help Window.

• Create a table in Datasheet view.
• Identify features of the Table Wizard.
• Create a table in Design view.
• Create a field for a table in Design view.
• Move a field in a table in Datasheet view.
• Modify a field property in a table in Design view.
• Create an input mask in a table field.
• Delete a field from a table in Design view.
• Set a field as a primary key in Design view.

• Identify features of relationships between tables.
• Create a one-to-many relationship between tables.
• Sequence the steps to define a many-to-many relationship between two tables.
• Print a relationship report of a database.
• Identify features of a subdatasheet.
• Validate data integrity in a table.
• Identify features of the Required property used to ensure data integrity.