Microsoft Access Training
Learning Outcomes: At the completion of this course, students will be able to create database systems, enter, edit and delete data in database files, produce information in forms and reports and generate queries on the data.
Course Pre-Requisites: Microsoft Access Level 1 assumes students have little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.
COURSE OUTLINE
Getting to Know Access
Understanding Microsoft Access
Starting Access From the Desktop
Understanding the Start Screen
Creating a New Blank Database
Understanding the Backstage View
Opening an Existing Database File
Understanding the Access Screen
Using the Ribbon
Working With the Navigation Pane
Adding Commands to the QAT
Working With Touch Mode
Working With a Table
Working With Other Database Objects
Closing a Database File
Exiting From Access
Designing a Lookup Database
Understanding How Access Stores Data
Understanding Access Data Types
Scoping Your New Database
Identifying Table Problems
Refining Table Structures
Finalising the Design
Creating a Lookup Database
Creating a New Database File
Creating the Lookup Table
Defining the Primary Key
Saving and Closing a Table
Creating the Transaction Table
Understanding Lookup Table Relationships
Connecting to a Lookup Table
Viewing Table Relationships
Modifying Table Structures
Opening an Existing Table
Adding Fields to an Existing Table
Understanding Field Properties
Changing Field Size & Field Names
Changing Decimal Places
Changing Date Formats
Indexing Fields
Deleting Fields From a Table
Copying a Table Within a Database
Deleting a Table From a Database File
Adding Records to a Table
Typing Records in a Table
Adding Records Using a Form
Saving a Form Layout for Reuse
Adding Records Using an Existing Form
Adding Additional Records
Importing From Microsoft Excel
Adding Transactional Records
Typing Transactional Records
Adding Transactional Records Using a Form
Adding Additional Transactional Records
Adding Records Using a Subdatasheet
Removing a Subdatasheet
Inserting a Subdatasheet
Working With Records
Table Navigation
Navigating to a Specific Record
Editing a Record
Deleting Record Data
Undoing a Change
Deleting a Record
Deleting Several Records
Searching in a Table
Searching in a Field
Finding and Replacing
Printing Records From a Table
Compacting a Database
Sorting and Filtering
Simple Sorting
Sorting on Several Fields
Simple Filtering
Working With Filters
Filtering Between Dates
Creating Queries
Understanding Queries
Creating a Query Design
Working With a Query
Changing a Query Design
Applying Record Criteria
Clearing Selection Criteria
Saving a Query
Running Queries From the Navigation Pane
Creating Additional Queries
Creating and Using Reports
Understanding Reporting in Access
Creating a Basic Report
Working With Existing Reports
Previewing and Printing a Report
Changing the Report Layout
Using the Report Wizard
Creating a Grouped Report
Creating a Statistical Report
Working With Grouped Reports
Creating and Using Forms
Understanding Forms
Creating a Basic Form
Creating a Split Form
Binding a Form to a Query
Using the Form Wizard
Working With Existing Forms
Editing Records in a Form
Deleting Records Through a Form
Deleting an Unwanted Form
