Microsoft Courses

Short Courses

Microsoft Access 2016 Foundation Topics

Lesson 1: Getting Started with Access
TOPIC A: Orientation to Microsoft Access
Microsoft Access 2016
Access Files
Opening Databases
Access Web Apps12
The Access 2016 Application Window
Forms and Views
The Ribbon Interface
TOPIC B: Create a Simple Access Database
Database Templates
Web App Templates
Save Options
Field Definition
Methods to Create a Form
Form Object Views
Form Sections
Modifying Existing Forms
Saving Forms
Deleting Forms
Access Web App Views
TOPIC C: Get Help in Microsoft Access
Using Tell Me
Accessing Advanced Help Options
Lesson 2: Working with Table Data
TOPIC A: Modify Table Data
Commit, Save, and Undo
Quick Search
The Find and Replace Dialog Box
Data sheet Totals
TOPIC B: Work with Records
Adding New Records
Updating Records with a Query
Append Queries
Navigating Through Records
Printing Records
TOPIC C: Sort and Filter Records
The Sort Feature
The Filter Feature
Filter Commands
The Group Feature
TOPIC D: Create Lookups
Lookup Fields
The Property Sheet Pane
Lesson 3: Querying a Database
TOPIC A: Join Data from Different Tables in a Query
Query Views
The Simple Query Wizard
Types of Queries
The Run Command
Query Design
Saving Queries
Deleting Queries
Renaming Queries
TOPIC B: Sort and Filter Data in a Query
Query Criteria154
Comparison Operators
Logical Operators
Sorting Query Results
Grouping Query Results
Formatting Query Fields
The Zoom Dialog Box
TOPIC C: Perform Calculations in a Query
Arithmetic Operators
Adding Calculated Fields
Adding Conditional Logic
Lesson 4: Creating Advanced Queries
TOPIC A: Create Parameter Queries
Parameter Queries
Wildcards in a Parameter Query
The Ampersand Operator
TOPIC B: Create Action Queries
Action Queries
Types of Action Queries
TOPIC C: Create Find Duplicate and Find Unmatched Queries
The Find Duplicates Query Wizard
The Find Unmatched Query Wizard
TOPIC D: Summarise Data
Cross tab Queries
Multiple Table Queries
Lesson 5: Generating Reports
TOPIC A: Create a Report
Report Creation Tools
Using Application Parts to Create Reports
Report Views
The Report Wizard
Saving a Report249
Modifying an Existing Report
Deleting a Report
TOPIC B: Add Controls to a Report
Report Sections
Adding Controls
Modifying Control Properties
Managing Labels
Inserting Images
TOPIC C: Enhance the Appearance of a Report
TOPIC D: Prepare a Report for Print
Adding a Header or Footer
Inserting Page Numbers
Page Setup Options
The Print Preview Tab
Lesson 6: Customising the Access Environment
TOPIC A: The Access Options Dialog Box
Access Options
Lesson 7: Designing a Relational Database
TOPIC A: Relational Database Design
Relational Databases
The Relational Database Design Process
The Statement of Purpose
Existing Data
Guidelines for Determining Fields
Business Rules323
Guidelines for Grouping Fields into Tables
Primary Keys
Foreign Keys
Composite Keys
Table Relationships
TOPIC B: Create a Table
Table Creation Options
Importing Tables from Other Databases
Creating Tables with Templates
Table Views
Data Types
Inserting Fields
Quick Start Fields
Deleting Fields
Calendar for Picking Dates
The Lookup Wizard
The Table Properties Dialog Box
TOPIC C: Modify a Table and Fields
Renaming a Table
Changing Field Captions
Changing Field Sizes
Configuring Fields to Auto-Increment
Setting the Default Value for a Field
TOPIC D: Create Table Relationships
The Relationships Window
Referential Integrity
Guidelines for Enforcing Referential Integrity
The Edit Relationships Dialog Box
Join Lines
Relationship Report
Lesson 8: Joining Tables
TOPIC A: Create Query Joins
Query Joins
Inner Joins
Outer Joins
The Join Properties Dialog Box
TOPIC B: Join Tables That Have No Common Fields
Joining Tables with No Common Fields
TOPIC C: Relate Data within a Table
The Alias Property
TOPIC D: Work with Sub-data sheets
Sub-data sheets
TOPIC E: Create Subqueries
Lesson 9: Organising a Database for Efficiency
TOPIC A: Data Normalisation
First Normal Form
Second Normal Form
Third Normal Form
The Table Analyser Wizard
TOPIC B: Create a Junction Table
Many-to-Many Relationships
Junction Tables
Lesson 10: Sharing Data Across Applications
TOPIC A: Import Data into Access
Data Importing
The Get External Data Wizard
TOPIC B: Export Data to Text File Formats
Data Exporting
TOPIC C: Export Access Data to Excel
Exporting Access Data to Excel
TOPIC D: Create a Mail Merge
The Microsoft Word Mail Merge Wizard
Merge Fields
The Mail Merge Task Pane
Lesson 11: Advanced Reporting
TOPIC A: Organise Report Information
Report Design Elements
Report Design Tools
The Group, Sort, and Total Pane
The Field List Pane
Adding a Background Image to a Report
TOPIC B: Format Reports
Report Format Tools
Report Control Properties
Report Pagination
TOPIC C: Include Charts in a Report
Data Bars
TOPIC D: Add a Calculated Field to a Report
Calculated Fields
TOPIC E: Add a Sub-report to an Existing Report
Lesson 12: Additional Reporting Options
TOPIC A: Create a Mailing Label Report
The Label Wizard
TOPIC B: Publish a Report as PDF
Publishing a Report as PDF

Microsoft Short Course Enrolment Form

TBST offers powerful short course training opportunities in both Microsoft Office 2013 & 2016.

Whether your creating professional-looking presentations, working on spreadsheets, or word processing, Microsoft Office allows you to open, save, modify, or collaborate on documents in the cloud, so you can maximise efficiencies & do great work anywhere, anytime.

Short course online training is a powerful way to learn.