Microsoft Access 2013 Advanced Course Online

Course Curriculum

➤ Module 01 - Implementing Advanced Form Design

Course Introduction

1.0 Topic A: Add Controls to Forms

2.0 Topic B: Create Subforms

3.0 Topic C: Organize Information with Tabs Pages

4.0 Topic D: Enhance Navigation of Forms

5.0 Topic E: Apply Conditional Formatting

➤ Module 02 - Using Data Validation

1.0 Topic A: Field and Record Validation

2.0 Topic B: Form Validation

➤ Module 03 - Using Macros to Improve UI Design

1.0 Topic A: Create a Macro

2.0 Topic B: Restrict Records Using a Condition

3.0 Topic C: Validate Data Using a Macro

4.0 Topic D: Automate Data Entry Using a Macro

5.0 Topic E: Convert a Macro to VBA

➤ Module 04 - Using Advanced Database Mgmt

1.0 Topic A: Link Tables to External Data Sources

2.0 Topic B: Manage a Database

3.0 Topic C: Determine Object Dependency

4.0 Topic D: Document a Database

5.0 Topic E: Analyze the Performance of a Database

➤ Module 05 - Distributing and Securing a Database

1.0 Topic A: Splitting a Database for Multiple User Access

2.0 Topic B: Implement Security

3.0 Topic C: Set Passwords

4.0 Topic D: Convert an Access Database to an ACCDE File

5.0 Topic E: Package a Database with a Digital Signature

➤ Module 06 - Managing Switchboards

1.0 Topic A: Create a Database Switchboard

2.0 Topic B: Modify a Database Switchboard

3.0 Topic C: Set Startup Options

Learning Outcomes

• Understand how to create and normalise a database
• Gain an understanding of Primary Keys and Relationships
• Learn how to work with Dates in a Query
• Learn how to create relationships between database Tables
• Learn how to optimise a database and improve network performance

Progression and Career Path

Once you successfully complete Microsoft Access 2013 Advanced you will be qualified to work in the following positions. The Microsoft Access 2013 Advanced qualification will also put you in line to demand a higher salary or job promotion.

• Programmer
• Office Manager
• Web Developer
• Project Assistant
• Business Executive
• Business Analyst
• Technical Support Analyst

Other Benefits

• Written and designed by the industry’s finest expert instructors with over 15 years of experience
• Repeat and rewind all your lectures and enjoy a personalised learning experience
• Gain access to quality video tutorials
• Unlimited 12 months access from anywhere, anytime
• Excellent Tutor Support Service (Monday to Friday)
• Save time and money on travel
• Learn at your convenience and leisure
• Quizzes, tests mock exams, practice exams to ensure you are 100% ready
• Eligible for a NUS discount card
• Free Career Support Service
• 25% Discount on personal Statement and covering letter writing service
• Free Access to Over 150 courses for 2 days (48 hours)
• Free access to course before you purchase (For selected courses only)