This course focuses on the design and construction of an Access database – viewing, navigating, searching and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms and reports. Take Access 2019 – Level 1 to 3 to prepare for the MOS Certification exam for Microsoft Access 2019.
Course Outline
Lesson 1: Getting Started with Access 2019
- Launch Access and Open Database
- Use Tables to Store Data
- Use Queries to Combine, Find, Filter and Sort Data
- Use Forms to View, Add and Update Data
- Use Reports to Present Data
- Get Help and Configure Options in Microsoft Access
Lesson 2: Creating Tables
- Plan an Access Database
- Start a New Access Database
- Create a New Table
- Establish Table Relationships
Lesson 3: Creating Queries
- Create Basic Queries
- Perform Calculations in a Query
- Sort and Filter Data in a Query
Lesson 4: Creating Forms
- Start a New Form
- Enhance a Form
Lesson 5: Creating Reports
- Start a New Report
- Enhance Report Layout
Lesson 6: Promoting Quality Data Input
- Restrict Data Input Through Field Validation
- Restrict Data Input Through Forms and Record Validation
Lesson 7: Improving Efficiency and Data Integrity
- Data Normalization
- Associate Unrelated Tables
- Enforce Referential Integrity
