Advanced Microsoft Access 2016 – Full Day

Code INF 1632

Table of Contents

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 and Exporting Records

Exporting Records to Microsoft Exce

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

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


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 CodeC

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

Download this outline as a PDF.

Advanced Microsoft Access 2016 – Full Day