Overview
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.
Prerequisites
Access 2019 – Level 1
To ensure success, students should have end-user skills with any current version of Windows, including being able to start programs, switch between program, locate saved files, close programs, and access websites using a web browser. To meet this prerequisite, you can take any one or more of the following Logical
Operations courses:
- Using Microsoft Windows 10
- Microsoft Windows 10: Transition from Windows 7
Next Step(s)
Access 2019 – Level 2
Access 2019 – Level 2
Access 2019 – Level 1
Course Outline Level 1
- 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
- Plan an Access Database
- Start a New Access Database
- Create a New Table
- Establish Table Relationships
- Create Basic Queries
- Perform Calculations in a Query
- Sort and Filter Data in a Query
- Start a New Form
- Enhance a Form
- Start a New Report
- Enhance Report Layout
- Restrict Data Input Through Field Validation
- Restrict Data Input Through Forms and Record Validation
- Data Normalization
- Associate Unrelated Tables
- Enforce Referential Integrity
Course Outline Level 2
- Create Lookups Within a Table
- Work with Subdatasheets
- Create Query Joins
- Create Subqueries
- Summarize Data
- Apply Conditional Formatting
- Create Tab Pages with Subforms and Other Controls
- Apply Advanced Formatting to a Report
- Add a Calculated Field to a Report
- Control Pagination and Print Quality
- Add a Chart to a Report
- Import and Link Data
- Export Data
- Create a Mail Merge
- Create Action Queries
- Create Unmatched and Duplicate Queries
- Create Subreports
- Create a Navigation Form
- Show Details in Subforms and Popup Forms
- Create a Standalone Macro to Automate Repetitive Tasks
- Create a Macro to Program a User Interface Component
- Restrict Records by Using a Condition
- Create a Data Macro
- Getting started with VBA
- Using VBA with Form Controls
- Back Up a Database
- Manage Performance Issues
- Document a Database
- Split a Database for Multiple-User Access
- Implement Security
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature