Chapter 1: Database fundamentalsModule A: Understanding general database terms
Module B: Relational databases
Module C: Access interface and objects
Chapter 2: TablesModule A: Creating tables
Module B: Creating fields
Module C: Data Validation
Module D: Relationships and keys
Chapter 3: QueriesModule A: Creating basic queries
Module B: Modifying queries
Module C: Using calculated fields
Chapter 4: FormsModule A: Creating simple forms
Module B: Form design
Module C: Form controls
Chapter 5: ReportsModule A: Creating Reports
Module B: Report controls
Module C: Formatting reports
Access 2016/2013 Level 1 provides the basic concepts and skills needed to start working with Microsoft Access databases. Students will learn how to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.
The course assumes you know how to use a computer, and that you're familiar with Microsoft Windows. It does not assume that you've used a different version of Access or another database system before.
Which Access series is right for me?
Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.
Level 1 and Level 2, on the other hand, are intended for students
who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.
Level 3 would be useful to students who have taken either track. It covers more advanced Access skills including VBA programming and application design.