|
Overview
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 multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training, added to that which you've gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.
Objectives
In this course, you will learn to create and manage a fundamental Access 2016 database.
You will:
- Customize a form layout to improve usability and efficiency of data entry.
- Share data across applications.
- Use macros to improve user interface design.
- Use VBA to enhance tasks.
- 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 startup options.
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. You can obtain this level of skill and knowledge by taking the following courses:
- Microsoft® Office Access® 2016: Part 1
- Microsoft® Office Access® 2016: Part 2
Target Student:
Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.
Course-specific Technical Requirements
Hardware
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware configurations:
- 1 GHz or faster 32-bit (x86) or 64-bit (x64) processor
- 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
- 16 GB available hard disk space (32-bit) or 20 GB (64-bit)
- CD-ROM drive (if installing any software from a CD-ROM)
- Keyboard and mouse (or other pointing device)
- 1,024 × 768 resolution monitor recommended
- Network cards and cabling for local network access
- Internet access (contact your local network administrator)
- Printer (optional) or an installed printer driver
- Projection system to display the instructor's computer screen
Software
- Microsoft® Windows® 10
- Microsoft® Office Professional 2016
Course duration
1 Day
Course outline
Lesson 1: Implementing Advanced Form Design
TopicA: Add Controls to Forms
TopicB: Enhance Navigation and Organization of Forms
TopicC: Apply Conditional Formatting
Lesson 2: Sharing Data Across Applications
TopicA: Import Data into Access
TopicB: Export Access Data
TopicC: Link Tables to External Data Sources
TopicD: Create a Mail Merge
Lesson 3: Using Macros to Improve User Interface Design
TopicA: Create a Macro
TopicB: Restrict Records Using a Condition
TopicC: Validate Data Using a Macro
TopicD: Automate Data Entry Using a Macro
Lesson 4: Using VBA
TopicA: Getting Started with VBA
TopicB: Enhance Access Using VBA
Lesson 5: Using Advanced Database Management
TopicA: Manage a Database
TopicB: Determine Object Dependency
TopicC: Document a Database
Lesson 6: Distributing and Securing a Database
TopicA: Splitting a Database for Multiple User Access
TopicB: Implement Security
TopicC: Convert an Access Database to an ACCDE File
TopicD: Package a Database with a Digital Signature
Lesson 7: Managing Switchboards
TopicA: Create a Database Switchboard
TopicB: Modify a Database Switchboard
TopicC: Set Startup Options
|
