Advanced Access Course

INTRODUCTION

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.

DURATION OF THIS ADVANCED ACCESS COURSE

One full day.

WHO SHOULD ATTEND THIS COURSE?

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.

COURSE DATES

We do not have workshops currently, but only provide on site training customized to your needs.

PRICING

The cost for on-site training is R10,000 per day. Maximum 15 delegates for computer training and 30 delegates for soft skills training. For individual course, see our elearning platform.

OUTLINE

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

 

 

 

Empower Yourself - BOOK NOW!

Advanced  access course

Address:

Unit 11, Block 2
Falcon Crest Office Park
142 South Street
Die Hoewes
Centurion
South Africa

Contact Details:

Advanced  access course



*


Everyone can rise above their circumstances and achieve success
if they are dedicated to and passionate about what they do
Nelson Mandela