Microsoft Office Access 2016: Part 3 (Advanced)
4.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
245 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office Access 2016: Part 3 (Advanced) to your Wishlist.

Add to Wishlist

Microsoft Office Access 2016: Part 3 (Advanced)

Become a database professional and separate yourself from the casual database users or occasional database designers.
4.6 (4 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
245 students enrolled
Last updated 8/2017
Curiosity Sale
Current price: $10 Original price: $25 Discount: 60% off
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the start-up options.
View Curriculum
  • To ensure your success in your course you should have experience working with Microsoft Access 2016, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships.

You've covered many of the basic functions of Microsoft Office Access 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple- user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. 

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.

Who is the target audience?
  • People taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
41 Lectures
Implementing Advanced Form Design
7 Lectures 24:58

The addition of controls, such as command buttons, adds extra functionality to your forms. You will edit the tab order of fields in your forms, adjust your form's layout, create a subform, create tab pages and a Navigation form, and apply conditional formatting to your forms. (Lesson Introduction)

Preview 01:52

Learn how to rearrange the controls on a form and change the tab order to ensure that users progress through the fields in a logical manner. (Controls, Types of Controls, Command Buttons, Calendar/Datepicker Control, Form Layouts, Tab Order)

Add Controls to Forms

Users find it easier to access related forms from a single location, rather than having to open multiple forms. Therefore, learn how to have a single form that links to multiple forms and reports. (The Subform Control)


Tab pages, or tabbed pages, are an organizational unit useful for collecting and aggregating similar data onto separate forms, while enjoying the ability to switch easily among open forms via tabs and making your forms look cleaner and simpler to the user. (Tab Pages)

Preview 05:53

Access 2016 includes a Navigation control that makes it easy to switch between forms and reports in your database. (Navigation Control, Navigation Forms)

Navigate Forms

Conditional formatting is a feature of Microsoft Access that allows you to apply special formatting to data when a particular criterion is met.

Apply Conditional Formatting - Introduction

In this topic, you will apply conditional formatting to your data to make it stand out in forms and reports. (Conditional Formatting, The Conditional Formatting Rules Manager)

Apply Conditional Formatting

Microsoft Access 2016 Part 3 Quiz 1
3 questions
Sharing Data Across Applications
10 Lectures 32:19

Microsoft Access enables you to integrate data with other programs. In this lesson, you will import external data into Access as well as export Access data to other applications. (Lesson Introduction)

Preview 01:10

Learn how to import external data into Access so you do not have to manually key it in. This will save you time and minimize errors. (TXT Files, CSV Files, The Get External Data Wizard, Delimiters)

Import CSV Files

Learn how to import external data into Access so you do not have to manually key it in. This will save you time and minimize errors. (The Import Spreadsheet Wizard)

Import Excel Files

One of the great features of Access, not only being able to import data, is being able to export data.

Export Access Data - Introduction

Text file formats can be used to display the exported data in a simple format, but are generally used as delimited files that can then be imported into another application. (TXT Files, CSV Files, Text File Wizard, Delimiters)

Export CSV Files

When you export data to Excel, Access creates a copy of the selected data or database object and then stores the copy in an Excel worksheet. Excel is great analysing data and to distribute the results of your analysis. (Excel File)

Export Excel Files

Access includes a feature that allows you to link your tables to external data sources.

Preview 01:21

One major advantage of linking to external files is that when those external files are updated, Microsoft Access automatically sees the updates without intervention. (The Linked Table Manager)

Linked Files

In this topic, you will create a mail merge.

Preview 00:42

It is much more efficient to merge Access data with Word documents than it is to reenter all the information into Word. (The Microsoft Word Mail Merge Wizard, Merge Fields, The Mail Merge Task Pane)

Create a Mail Merge

Microsoft Access 2016 Part 3 Quiz 2
4 questions
Using Macros to Improve User Interface Design
7 Lectures 23:18

Macros are a good alternative to learning a complex programming language to perform relatively simple tasks. Macros offers a huge range of possibilites to modifying, validating, manipulationg and working with data. (Lesson Introduction)

Preview 01:07

The users forget about the New Record button near the bottom of the screen. Lets's create a macro that opens a form, ready to accept a new record. (The Macro Builder Window, Macro Actions, Action Arguments, Object Events)

Create a Macro

A macro condition is an expression that enables a macro to perform a task if a specific set of circumstances exist. (Macro Conditions, The Where Condition)

Restrict Records Using a Condition

Learn how to introduce a macro into a form to enforce the integrity and the validity of the data that’s being input into that form.

Validate Data Using a Macro

Creating a macro to prompt the user to enter correct information ensures data integrity and maintains your database's value. (Event Properties for Data Validation, Embedded Macros)

Data Validation

Making data entry easy for your users through automation not only increases the accuracy of your data, but also increases the speed at which your users can enter data.

Automate Data Entry Using a Macro - Introduction

You can employ macros to do this work for you by associating them with events. For example, if you have your users enter part numbers, the price can be automatically entered based on the part number. (Event Properties for Automating Data Entry, Macro Actions for Automating Data Entry)

Automate Data Entry

Microsoft Access 2016 Part 3 Quiz 3
6 questions
Using Advanced Database Management
5 Lectures 14:45

As the database administrator, you have the responsibility of guaranteeing database integrity through good design, clean data, and a healthy database. This lesson guides you through those processes.

Preview 02:12

Many of the problems associated with working with databases can be mitigated by performing regular backups and by performing a simple maintenance task known as Compact and Repair. (Exclusive Mode, Compact and Repair)

Compact and Repair a Database

One of the things you never want to hear your users say is, “The database is slow.” Access has a built-in tool, the Performance Analyzer, that's designed to help you do just that: analyze performance. (Performance Analyzer)

Performance Optimizer

Object dependency is when database entities (objects) rely on one another for data. Object dependency in a database can become quite complex, and it's necessary to understand object dependency in cases of advanced troubleshooting. (Object Dependencies Pane)

Determine Object Dependency

If anyone else ever needs to work with your database, they will need to know how everything is configured. Database documentation can give them the information they need and provide a reference to you as well. (The Database Documenter, The Documenter Dialog Box)

Document a Database

Microsoft Access 2016 Part 3 Quiz 4
3 questions
Distributing and Securing a Database
7 Lectures 22:15

Microsoft® Access® provides database administrators with tools to move from a single-user database to a multipleuser networked database application. (Lesson Introduction)

Preview 01:50

Splitting a database is a simple process that divides your single ACCDB file into two files. One file becomes the front-end database and the second file becomes the back-end database and contains the data in tables. (Front-End and Back-End Databases, The Database Splitter, Advantages of a Split Database)

Split Databases

Another way to secure objects is to hide them. (Options)

Hide Objects

A trusted location is a folder that is known to Microsoft Access as a location that should not be checked by the Trust Center. The purpose of trusted locations is to prevent any warnings about macros, ActiveX controls, or data connections that the Trust Center ordinarily would see as potentially harmful. (Options, The Trust Center dialog box)

Trusted Locations

Using a password prevents unauthorized access to a database that might contain sensitive data. (Password Protection)

Password Protection

If you're distributing your database to users outside of your design group, then it's wise to convert them first so that you don't have users changing your design elements. (The ACCDE File Format)

Convert an Access Database to an ACCDE File

A digital signature is an authentication tool that verifies the content in a file. It tells the user that the content can be trusted. (Digital Signatures, Digital Certificates)

Package a Database with a Digital Signature

Microsoft Access 2016 Part 3 Quiz 5
4 questions
Managing Switchboards
5 Lectures 12:23

You can limit users to the database objects that they need to use and make it easier for them to access those objects. (Lesson Introduction)

Preview 01:08

A switchboard is a form that usually opens when you open a database. You should design your switchboard with the idea that it is the user's primary database interface. (Switchboard Manager)

Create a Database Switchboard

In this topic, you will modify the switchboard to your needs. (Switchboard Appearance Options)

Modify a Database Switchboard

Start-up options can help protect your database and make it easier for users to access forms, reports, and queries. (Database Start-up Options)

Set StartUp Options

Congratulations! You've completed the Microsoft® Office Access® 2016: Part 3 course. (What's Next?)

Preview 01:14

Microsoft Access 2016 Part 3 Quiz 6
3 questions
About the Instructor
SONIC - High Quality Training for Over 20 Years
4.3 Average rating
366 Reviews
6,258 Students
51 Courses
Training Company

SONIC Performance Support is a leading provider of e-learning and performance support solutions. We proudly serve individuals, government agencies, schools and businesses of all sizes. SONIC Performance Support provides high-quality video training, that is used by well-known domestic and foreign companies. With video based training, you have a personal coach explaining and demonstrating the task at hand. You can stop the video, perform the task in the application, and rewind if you want to review.