The skills and knowledge acquired in Microsoft Access 2016 Advanced course 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 2016.
The skills and knowledge acquired in Microsoft Access 2016 Advanced course 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 2016.
The Microsoft Access 2016 Advanced course assumes significant knowledge of the software, and it would be beneficial to have a general understanding of personal computers and the Windows operating system environment. The course is also suitable for those who attended our Access Intermediate course.
Our advanced Microsoft Access training course is suitable for those with a sound working knowledge of Access who wish to progress to the most complicated functions and features.
Learning Outcome
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
COURSE OUTLINE
Relational Database Design
Designing a Relational Database
Scoping the System
Determining the Inputs
Normalizing 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 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
Utilizing 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
Analyzing 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
Our long-standing success is based on our instructors bringing real-world experience to the classroom and providing engaging, relevant, and high-quality course curriculum.
When it comes to presenting a topic in a meeting or presentation, it can be difficult to capture the attention of your audience . Having a great presentation can make all the difference!
All of the necessary learning tools are provided, including class notes, computers, and software. All we require is a meeting room. Our unique training style will ensure no topic is unexplored, no question remains unanswered, and all participants exit the course more knowledgeable than they entered...
This Access training is intended for Access database administrators. At the end of this intensive Access training, you will be able to create tables in Access, create a relational model, create reports, and carry out queries to interact with the data in your tables.
This course is intended to help all users become familiar with the more advanced selection of features of Excel. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, work with graphical objects, and enhance workbooks.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel®: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy