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
Tables
Forms and Views
Queries
Reports
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
AutoCorrect
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
Galleries
Themes
 
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
Self-Joins
The Alias Property
 
TOPIC D: Work with Sub-data sheets
Sub-data sheets
 
TOPIC E: Create Subqueries
Subqueries
 
Lesson 9: Organising a Database for Efficiency
TOPIC A: Data Normalisation
First Normal Form
Second Normal Form
Third Normal Form
Denormalisation434
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
Delimiters
 
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
Charts
 
TOPIC D: Add a Calculated Field to a Report
Calculated Fields
 
TOPIC E: Add a Sub-report to an Existing Report
Sub-reports
 
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.

TBST's Available Courses

Browse our range of government funded, fee paying and MYOB courses.