Introduction to Microsoft Access 2016 – Full Day
Code INF 1630
Table of Contents
Getting to Know Access 2016
Understanding Microsoft Access 2016
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 2016 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 2016
Designing a Lookup Database
Understanding How Access Stores Data
Understanding Access 2016 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
Changing 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
Deleting a Query
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
Download this outline as a PDF.