Microsoft Access – Level 1

This indispensable course will equip participants with the proper tools needed to work in a database environment.  The participants will have a clear understanding of the parts that make up a database. They will learn to create lookup tables and data tables.  They will get a solid understanding on creating relationships between tables.  They will learn the importance of a primary key versus a foreign key to connect tables.  The participant will be able to assign the correct data type to the fields (column names).  They will learn to design and create data entry forms. The participants will create queries to filter data.  They will learn to design and create reports.

Benefits

• Design and create tables to store data
• Create relationships between tables
• Design and create queries to show selected data
• Design and create user data entry forms
• Display and create reports to email or print
• Maintain a history of transactions

Course Content

• Learn to create tables
• Choose the right data type for each field
• Learn about field properties
• Learn to create table relationships
• Design and create forms
• Learn to use controls on forms
• Create simple queries
• Design and create reports

 
Recommended Duration

12 hours conducted in 3-hour sessions

Target Audience

Employees of all experience levels and job classifications who are interested in creating a database to keep track of customer purchases, inventory or production