Access 2013: Advanced

Audience	This course is designed for individuals interested in learning the skills necessary to manage a database, design advanced forms, secure a database, and prepare a database for multi-user access in Microsoft® Office Access® 2013. This course helps individuals prepare for the Access 2013 Microsoft Office Specialist (MOS) Certification exam.
Description	Upon successful completion of this course, participants will be able to: Customize a form layout to improve usability and efficiency of data entry. Add user interface features to validate data entry. 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 startup options
Prerequisites	To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Microsoft® Windows® experience Microsoft® Office Access® 2013 Beginning Microsoft® Office Access® 2013 Intermediate
Suggested Class Size	Minimum 3 Maximum 12
Course Length	Full day
Table of Contents	Lesson 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Create Subforms Topic C: Organize Information with Tab Pages Topic D: Enhance Navigation of Forms Topic E: Apply Conditional Formatting Lesson 2: Using Data Validation Topic A: Field Validation Topic B: Form and Record Validation Lesson 3: Using Macros to Improve User Interface Design Topic A: Create a Macro Topic B: Restrict Records Using a Condition Topic C: Validate Data Using a Macro Topic D: Automate Data Entry Using a Macro Topic E: Convert a Macro to VBA Lesson 4: Using Advanced Database Management Topic A: Link Tables to External Data Sources Topic B: Manage a Database Topic C: Determine Object Dependency Topic D: Document a Database Topic E: Analyze the Performance of a Database Lesson 5: Distributing and Securing a Database Topic A: Split a Database for Multiple User Access Topic B: Implement Security Topic C: Set Passwords Topic D: Convert an Access Database to an ACCDE File Topic E: Package a Database with a Digital Signature Lesson 6: Managing Switchboards Topic A: Create a Database Switchboard Topic B: Modify a Database Switchboard Topic C: Set Startup Options

A lack of English language skills will not be a barrier to admission to and participation in career and technical education programs. Brazosport College shall not discriminate on the basis of race, creed, color, national origin, citizenship status, age, disability, pregnancy, religion, gender, gender identity, genetic information, marital status, veteran status or any other protected class in accordance with applicable federal and state laws. The following person has been designated to handle inquiries regarding the non-discrimination policies: Vice President of Human Resources, 500 College Drive, Lake Jackson, TX, 77566; 979-230-3459; Marshall.Campbell@brazosport.edu