MS Access Level 1 Fundamentals

Access 2019 Level 1 – Introduction

Versions 2013, 2016, 2019, Office 365, & Online are also available. In this course, you will create and manage an Access 2019 database.

Course Outline

Lesson 1 – Access Basics

• Understanding Databases
• Using Database Templates
• Open an Existing Database
• the Access Environment
• a Look at Tables
• a Look at Forms
• Look at Queries
• a Look at Reports
• Creating a Blank Database
• Setting Access Options
• Using Help
• Using Tell Me to Obtain Help

Lesson 2 – Working with Tables

• Creating a Table Using Application Parts
• Entering Data into a Table
• Adding New Fields to a Table
• Creating a Table from Scratch
• Setting a Primary Key
• Changing Column Width and Row Height
• Rearranging Fields
• Inserting and Deleting Fields
• Changing Field Properties
• Designing in Datasheet View

Lesson 3 – Working with Data

• Editing Data
• Formatting Table Data
• Importing Excel Data into an Existing Table
• Importing a Text File into a New Table
• Selecting and Deleting Records
• Sorting Records
• Finding and Replacing Data
• Filtering Data by Selection
• Filtering Data by Form
• Using Common Filters
• Hiding/Unhiding Columns
• Freezing Columns
• Rearranging Columns
• Displaying Column Totals in a Datasheet

Lesson 4 – Working with Queries

• Working in Query Design View
• Creating a Query in Design View
• Adding Fields to a Query
• Removing Fields from a Query
• Saving a Query
• Running a Query
• Adding Criteria to a Query
• Specifying Multiple Criteria
• Sorting Data in a Query
• Moving Columns in a Query
• Using the Query Wizard

Lesson 5 – Creating Forms

• Using the Form Wizard
• Entering Data into a Form
• a Look at Design View
• Adding a Field to a Form
• Changing Control Properties
• Using Layout View
• Finding Records in a Form

Lesson 6 – Creating Reports

• Creating a Basic Report
• Applying a Theme to a Report
• Using the Report Wizard
• Report View and Layout View
• a Look at Design View
• Modifying Report Setup
• Printing Reports
• Using the Label Wizard