Microsoft Access 2013 - Level 3 (with Challenge Exercises)

LoanNew

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

Anyone who wants to further their skills with Microsoft Access 2013.

Microsoft Access 2013 - Level 3 (with Challenge Exercises) assumes some knowledge of the software to create basic databases and generate reports. 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
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Data

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
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Sample

Macro Techniques

• Creating A Print Macro
• Using Conditions To Enhance A Macro
• Creating A Sequence Of Conditions
• Understanding The Versatility Of MsgBox
• Using The MsgBox Function
• Reconfiguring A Message Box
• Using The InputBox Function
• Practice Exercise
• Practice Exercise Sample

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
• Practice Exercise
• Practice Exercise Workspace

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
• create queries based on one or more tables
• create and work with aggregation queries
• create and use a series of action queries
• work with a number of macro techniques
• create some simple programming code using VBA

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

Windows with Microsoft Access 2013

Approximately 10 hours

• Access 2016: Creating a Simple Database
• Access 2016: Fast Track Introduction
• Access 2016: Further Use
• MySQL: Implementing a Relational Database Design
• Relational Database Design (In Person Face to Face)