Database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.
One full day.
Database administrators or prospective database administrators who have experience working
with Access 2013 and need to learn advanced skills.
This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.
We do not have workshops currently, but only provide on site training customized to your needs.
Unit 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
Unit 2: Using Data Validation
Topic A: Field and Record Validation
Topic B: Form Validation
Unit 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
Unit 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
Unit 5: Distributing and Securing a Database
Topic A: Splitting 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
Unit 6: Managing Switchboards
Topic A: Create a Database Switchboard
Topic B: Modify a Database Switchboard
Topic C: Set Startup Options