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.
12 hours conducted in 3-hour sessions
Employees of all experience levels and job classifications who are interested in creating a database to keep track of customer purchases, inventory or production