Microsoft Access 2016 - Level 3 (with Challenge Exercises)

BeginnersLoanNew

The skills and knowledge acquired in Microsoft Access 2016 - Level 3 (with Challenge Exercises) are sufficient to design and create a multitable database and automate operations using macros and have a general understanding of the programming environment in Microsoft Access 2016.

Anyone who wants to gain a deeper understanding of Microsoft Access 2016 or build upon the completion of Microsoft Access 2016 - Level 1 (with Challenge Exercises) and Microsoft Access 2016 - Level 2 (with Challenge Exercises)

• Completion of Microsoft Access 2016 - Level 2 (with Challenge Exercises) or equivalent knowledge
• The course assumes a significant knowledge of the software, and it would be beneficial to have a general understanding of personal computers and the Windows operating system environment.

Relational Database Design

• Designing A Relational Database
• Scoping The System
• Determining The Inputs
• Normalising A Database
• First Normal Form (1NF)
• Second Normal Form (2NF)
• Second Normal Form – Case Study
• Third Normal Form (3NF)
• Database Indexing

Creating A Relational Database

• Creating A New Database File
• Creating Lookup Tables
• Defining A Primary Key
• Saving And Closing A Table
• Creating The Expense Type Table
• Creating The Transactions Table
• Creating The Details Table

Setting Table Relationships

• Understanding Table Relationships
• Understanding Lookup Relationships
• Looking Up The Employees Table
• Looking Up The Expense Types Table
• Viewing Table Relationships
• Understanding Table Joins
• Editing The Employee Table Join
• Editing The Expense Type Table Join
• Creating A New Join
• Creating A Relationship Report

Importing & Exporting Records

• Exporting Records To Microsoft Excel
• Exporting Records To A Text File
• Importing From Microsoft Excel
• Importing From A Text File
• Linking To An External Source

Multi-Table Queries

• Understanding Relational Queries
• Creating A Relational Query Design
• Filtering A Relational Query
• Filtering Related Fields
• Adding More Tables And Fields
• Utilising Hidden Fields
• Understanding Query Joins
• Creating An Inner Join
• Creating A Left Outer Join
• Creating A Right Outer Join

Aggregation Queries

• Creating An Aggregation Query
• Working With Aggregation Queries
• Multiple Aggregations
• Modifying Aggregation Headings
• Aggregating Calculated Fields
• Applying Criteria To Aggregates
• Understanding Nested Queries
• Creating An Assembly Query
• Creating The Nesting Query

Action Queries

• Creating A Make Table Query
• Using A Make Table Query
• Understanding Expressions And Update Queries
• Preparing An Update Query
• Running An Update Query
• Updating Using Expressions
• Running An Expression-Based Update
• Creating A Delete Query
• Running A Delete Query
• Creating An Append Query
• Running An Append Query
• Turning Action Messages Off

Database Security

• Understanding Database Trust
• Enabling Blocked Content
• Understanding The Trust Centre
• Creating A Trusted Location
• Opening A Database From A Trusted Location
• Encrypting A Database
• Decrypting And Opening A Database
• Removing A Database Password
• Understanding Package And Sign
• Creating A Self-Signed Certificate
• Creating A Signed Package
• Extracting And Using A Signed Package

Database Wellness

• Compacting And Repairing A Database
• Understanding Database Splitting
• Using The Database Splitter
• Managing Linked Tables
• Checking Object Dependencies
• Analysing Database Performance
• Documenting A Database

An Introduction To VBA

• Understanding VBA
• Coding VBA For An Event
• Running VBA Event Code
• Understanding MsgBox And InputBox
• Modifying An Existing Procedure
• Understanding The Modified Code
• Creating A Standard Module
• Loan Simulator Code
• Running The Code
• Understanding The Loan Simulator Code
• Creating A Button For The Simulator
• Attaching The Simulator Code

At the completion of this course you should be able to:

• design a relational database project
• create a relational database file with multiple tables
• set table relationships and join tables together
• export records to and import records from a wide variety of sources and applications
• create queries based on one or more tables
• create and work with aggregation queries
• create and use a series of action queries
• make your Microsoft Access data and computer more secure
• understand and use a variety of tools that ensure the wellness of your database files
• create some simple programming code using VBA

Watsonia workbook with 93 topics. Files for the exercises are provided on a CD or can be downloaded here

Approximately 15 hours