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
Booking / availability