(3) Working with Tables
• Formatting a Table
• Modifying Field Properties
• Sorting Records in a Table
• Finding Records in a Table
• Using Filters with a Table
• Establishing Relationships Between Tables
• Creating Subdatasheets
• Importing Records From an External Source

(4) Creating and Using Queries
• Creating and Running a Query
• Specifying Criteria in a Query
• Using Comparison Operators
• Creating a Calculated Field
• Creating a Multiple-Table Query
• Printing a Query

(5) Designing a Form

• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Adding Controls to a Form
• Modifying Control Properties
• Resizing and Moving Controls
• Entering Records into a Form
• Creating Calculated Controls

Who
should attend

This course is aimed at participants who wish to gain an industry qualification in the Access database environment.

Pre-requisites

Candidates should have an understanding of the Windows environment and be relatively comfortable Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, and Viewing System Information.

What
you need to bring

N/A

Key
Takeaways

After completing this course, individuals will have the expertise to work competently with Microsoft Access program. Individuals report increased competence and productivity as well as increased credibility with their employers, co-workers and clients.