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.
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)
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)
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)
Access 2016 includes a Navigation control that makes it easy to switch between forms and reports in your database. (Navigation Control, Navigation Forms)
Conditional formatting is a feature of Microsoft Access that allows you to apply special formatting to data when a particular criterion is met.
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)
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)
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)
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)
One of the great features of Access, not only being able to import data, is being able to export data.
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)
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)
Access includes a feature that allows you to link your tables to external data sources.
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)
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)
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)
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)
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)
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.
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)
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.
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)
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.
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)
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)
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)
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)
Microsoft® Access® provides database administrators with tools to move from a single-user database to a multipleuser networked database application. (Lesson Introduction)
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)
Another way to secure objects is to hide them. (Options)
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)
Using a password prevents unauthorized access to a database that might contain sensitive data. (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)
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)
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)
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)
In this topic, you will modify the switchboard to your needs. (Switchboard Appearance Options)
Start-up options can help protect your database and make it easier for users to access forms, reports, and queries. (Database Start-up Options)
Congratulations! You've completed the Microsoft® Office Access® 2016: Part 3 course. (What's Next?)
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.