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