Microsoft Access Level 3 - Advanced Access

Name: Microsoft Access Level 3 - Advanced Access
Rating: 4.4 (45 reviews)

Become an Access Guru by Mastering Advanced Access Table Structuring, Subqueries, Macros, Table of Contents and More!

Created byKirt Kershaw

Last updated 4/2021

English

What you'll learn

How to normalize other databases for quicker data retrieval
Find unmatched and, or duplicate records using a Query
Reduce repetitive actions using Macros and adding Macro Buttons
How to require and automate data entry with Macros
Pull up related records fast using the Where Condition
Emphasize data, or records with Conditional Formatting
Compact, repair, backup and password protect your database
Taught by Certified Microsoft Office Access 2000, 2002, 2003, 2007, 2010, 2013 & 2016 Specialist with over 17 years of Access training

Course content

11 sections • 50 lectures • 4h 14m total length

Normalization Standard3:34
Microsoft Access training video on how to break Tables down into smaller, more meaningful Tables through the Normalization Standard process in Access.

Exercise Files, Instructor's Notes, Quiz & Answers5:58
Exercise Files - the exercise files are provided for you to practice what you've learned after watching the training videos. The exercise files are numbered, and are the exact same as the instructor uses in the video
Instructor Notes - are quick notes about the main points covered in the training videos, and are typically used to reference a point quickly without having to watch the entire training video over again
Quiz & Answers - there are two separate .pdf files: Quiz and Answers. The Quiz has one question for each video to test yourself on what was presented, and of course the answers to compare

Table Analyzer11:52
Microsoft Access 2016 training video on how to straighten out databases created by less-knowledgeable users by using the Table Analyzer Wizard in Access.
Many to Many Relationships7:21
Microsoft Access 2016 training video on how to create a Many-to-Many relationship between two Tables in Access.
Restructuring Tables8:31
Microsoft Access 2016 training video on how to restructure poorly designed Tables to be able to create relationships with other Tables in Access.
Hide Table Columns1:18
Microsoft Access 2016 training video on how to hide a column in a Table in Access.
More Advanced Tables Quiz

Subqueries5:40
Microsoft Access 2016 training video on how to Query within a Query also know as a Subquery in Access.
Unmatched Query4:45
Microsoft Access 2016 training video on how to find unmatched fields between two Tables using the Unmatched Query in Access.
Duplicate Query2:27
Microsoft Access 2016 training video on how to find duplicates data in a Table or Query using Duplicate Query in Access.
Criteria Groups Query7:57
Microsoft Access 2016 training video on how to group and summarize records using the Criteria field in Access.
Crosstab Query Wizard5:58
Microsoft Access 2016 training video on how to create a summary of calculation of intersecting values of row and column headings using the Crosstab Query in Access.
More Advanced Queries Quiz

Create Macros9:48
Microsoft Access 2016 training video on how to record a collection of actions used to automatically run a set of tasks by creating Macros in Access.
Macro Button4:08
Microsoft Access 2016 training video on how to assign a Macro to a command button in Access.
Where Condition3:34
Microsoft Access 2016 training video on how to automatically compare records in one Form, and to find its match in another Form using the Where Condition in Access.
Require Data Entry Macro5:08
Microsoft Access 2016 training video on how to require data to be entered into a field before saving the record by creating a Require Data Entry Macro in Access.
Display Message Macro2:29
Microsoft Access 2016 training video on how to display a message box to alert front-end user about required data by creating a Message Macro in Access.
Automated Macro5:16
Microsoft Access 2016 training video on how to automatically fill in one field based upon data in another with the Automate Macro in Access.
Macros Quiz

Conditional Formatting4:37
Microsoft Access 2016 training video on how to apply formatting to a field based upon a condition using Conditional Formatting in Access.
Report Charts4:47
Microsoft Access 2016 training video on how to insert a chart into a Report in Access.
Multiple Columns & Groups15:04
Microsoft Access 2016 training video on how to create and modify columns in a Report in Access.
Cancelling Print Job3:52
Microsoft Access 2016 training video on how to automatically cancel a print job of a Report in Access.
Export to PDF or XPS1:33
Microsoft Access 2016 training video on how to export a Report into a PDF or XPS file in Access.
More Advanced Forms & Reports Quiz

Linking to Other Database Tables4:35
Microsoft Access 2016 training video on how to link to another Table in another database in Access.
Database Properties3:09
Microsoft Access 2016 training video on how to learn and add details about your database in Access.
Compact & Repair Database1:35
Microsoft Access 2016 training video on how to speed up and compress the size of your database using the Compact & Repair in Access.
Backup Database1:21
Microsoft Access 2016 training video on how to create a backup of your database in Access.
Password Protect3:53
Microsoft Access 2016 training video on how to password protect your database in Access.
Object Dependency2:19
Microsoft Access 2016 training video on how to find what other objects are dependent upon, before deleting them, using Object Dependency in Access.
Database Documenter3:11
Microsoft Access 2016 training video on how to create a detailed Report about some, or all objects in your database using Database Documenter in Access.
Performace Analyzer2:23
Microsoft Access 2016 training video on how to analyze your database and get suggested performance improvements with Performance Analyzer in Access.
Maintaining Database Quiz

Import XML Data10:55
Microsoft Access 2016 training video on how to import XML (Extensible Markup Language) data into your database in Access.
Export to XML2:41
Microsoft Access 2016 training video on how to export Access into XML (Extensible Markup Language) in Access.
Link to Outlook Contacts4:11
Microsoft Access 2016 training video on how to link to Microsoft Outlook Contacts in Access.
Table Attachment Field5:01
Microsoft Access 2016 training video on how to attach files to each record using Table Attachment Fields in Access.
Save As Previous Version2:50
Microsoft Access 2016 training video on how to save your database to a previous version of Access.
Navigation Forms8:06
Microsoft Access 2016 training video on how to create Forms to help a front-end user navigate to other objects using Navigation Forms in Access.
Switchboard10:12
Microsoft Access 2016 training video on how to control the front-end user’s access to the database by creating a Switchboard including: Main Switchboard, Report Switchboard and a Form Switchboard in Access.
Modifying Switchboards4:12
Microsoft Access 2016 training video on how to modify Switchboards in Access.
Form Startup & Options8:54
Microsoft Access 2016 training video on how to set startup options for any Form when opening your database in Access.
Database Integration Quiz

Split Database5:49
Microsoft Access 2016 training video on how to split a database in Access.
Distributing Split Database2:29
Microsoft Access 2016 training video on how to distribute a split database: the front-end to computers and the back-end onto the network, or server in Access.
Database Access Modes2:44
Microsoft Access 2016 training video on about the four different access modes to your database including: Open, Open Read-Only, Open Exclusive, and Open Exclusive Read-Only in Access.
Trusted Location2:37
Microsoft Access 2016 training video on how to setup a folder known to Access as a location that should not be checked by the Trust Center, so as to prevent any warnings about macros, ActiveX controls, or data connections that the Trust Center would typically see as harmful.
Protect VBA Code1:56
Microsoft Access 2016 training video on how to prevent unauthorized users from deleting, editing and copying your VBA (Visual Basic Application) code in Access.
File Protection ACCDE2:38
Microsoft Access 2016 training video on how to prevent Forms, Reports and Modules from being viewed and modified in the Design View, and creating, adding, deleting or changing references to database, or object libraries, changing source code and importing or exporting Forms, Reports or Code Modules in Access.
Distribute Database & Security Quiz

Digitally Sign Database5:55
Microsoft Access 2016 training video on how to add your Digital Signature, or Digitally Sign your database to let others who you distribute it to know that the content is safe and can be trusted in Access.
Hide Empty Record Labels in Reports7:04
Microsoft Access 2016 training video on how to hide empty records and their corresponding labels in a Report in Access.
Create Table of Contents13:10
Microsoft Access 2016 training video on how to create a Table of Contents in Access.
Custom Display Control for Text Box4:50
Microsoft Access 2016 training video on how to be able to create a Data Type Field Yes/No with its Display Control set to Text Box. As well as customizing it to text and color.
Bonus! Quiz

Requirements

You will need Access installed on your computer to follow along and complete the exercise files
Videos have been recorded using Access 2016, but all features will work in Access 2010, 2013, 2016, 2019, 365 and most in 2007

Description

Drive Your Microsoft Access Skills to an Advanced Level

Take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an advanced level. You will learn how to work with additional Access features including: Table restructuring, Criteria Groups Query, Macros, Multiple Columns and Groups, Form and Startup Options.

Using my 18+ years of Microsoft Access training and Certification I will guide you through these advanced Access features and become an Access Expert. Below are just a few of the topics that you will master:

Table normalization and restructuring of poorly designed databases
More targeted Query results by using Subqueries
Perform summary calculations of intersecting values of row and column headings using Crosstab Queries
Automate data entry, based upon certain data entered into other fields, with Automated Macros
Alphabetically sort, label, and group records in your Reports
How to attach any file including documents and images to a record.
How to hide empty Record Labels from displaying and taking up unnecessary space in your Reports
and much, much, more…

Who this course is for:

This Microsoft Access Level 3 course was designed for those looking to advance their Access knowledge and skills to an advanced level, taking advantage of several more advanced Microsoft Access features
Anyone who wants all the training needed from all three Levels of my Access courses to take the Microsoft Access 2016 (77-730) Exam and become certified

Microsoft Access Level 3 - Advanced Access

What you'll learn

Explore related topics

Course content

Normalization Standard1 lecture • 4min

Access Level 3 - Advanced1 lecture • 6min

More Advanced Tables4 lectures • 29min

More Advanced Queries5 lectures • 27min

Macros6 lectures • 30min

More Advanced Forms & Reports5 lectures • 30min

Maintaining Database8 lectures • 22min

Database Integration9 lectures • 57min

Distribute Database & Security6 lectures • 18min

Bonus!4 lectures • 31min

Requirements

Description

Who this course is for: