Course Description
In this advanced course you will learn how to use tools like "Data Validation" and "Form Design" to manage your data entries professionally. Without a consistent set of data your queries and reports will result in wrong conclusions, which might lead to wrong business decisions.
Prerequisites
• 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
• This course builds on the knowledge acquired in the Microsoft Access – Part 2 course
Target Audience
THIS COURSE IS SUITABLE FOR YOU, IF
• you are a database administrators or prospective database administrators who already have experience working with Access 2016 and need to learn advanced skills
• you want to use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016
Course Objectives
• 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