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
English
Curiosity Sale
Current price: $10 Original price: $25 Discount: 60% off
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • 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.
Description

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
02:09:58
+
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
06:47

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)

Subforms
03:03

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
04:30

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
00:29

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
02:24

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
05:50

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
04:43

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

Export Access Data - Introduction
01:12

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
03:36

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
02:06

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
07:36

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
04:03

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
06:28

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
03:33

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
00:51

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
06:01

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
00:34

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
04:44

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
03:16

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
03:25

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
02:33

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
03:19

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
03:57

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

Hide Objects
02:30

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
02:52

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

Password Protection
03:36

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
03:32

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
03:58

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
05:37

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

Modify a Database Switchboard
02:21

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
02:03

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.