In this course, students will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
- Topic A: Orientation to Microsoft Access
- Topic B: Create a Simple Access Database
- Topic C: Get Help and Configure Options in Microsoft Access
- Topic A: Modify Table Data
- Topic B: Sort and Filter Records
- Topic A: Create Basic Queries
- Topic B: Sort and Filter Data in a Query
- Topic C: Perform Calculations in a Query
- Topic A: Create Basic Access Forms
- Topic B: Work with Data on Access Forms
- Topic A: Create a Report
- Topic B: Add Controls to a Report
- Topic C: Enhance the Appearance of a Report
- Topic D: Prepare a Report for Print
- Topic E: Organise Report Information
- Topic F: Format Reports
- Topic A: Relational Database Design
- Topic B: Create a Table
- Topic C: Create Table Relationships
- Topic A: Create Query Joins
- Topic B: Relate Data Within a Table
- Topic C: Work with Subdatasheets
- Topic A: Use Field Validation
- Topic B: Use Form and Record Validation
- Topic A: Create Parameter Queries
- Topic B: Summarise Data
- Topic C: Create Subqueries
- Topic D: Create Action Queries
- Topic E: Create Unmatched and Duplicate Queries
- Topic A: Data Normalisation
- Topic B: Create a Junction Table
- Topic C: Improve Table Structure
- Topic A: Include Control Formatting in a Report
- Topic B: Add a Calculated Field to a Report
- Topic C: Add a Subreport to an Existing Report
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
In this course, you will create and manage an Access 2016 database. You will: Navigate within the Microsoft Access application environment, create a simple database, and customise Access configuration options. Organise and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports.
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
Immediate Feedback on Mastery
SATV Eligible
Direct From the Source
Learn Anywhere Anytime
Live Hands-on
Labs
