Microsoft Office Access 2013 Level 3 Training

COURSE OVERVIEW

Schedule our instructor led classroom training at your convenience and never miss another lecture or fall behind. You are in complete control. We invited the Best Office Trainers in the industry to help us develop the ultimate training & certification program.

This course covers the advanced functions and features of Access 2013. Students will learn about implementing advanced form design, using data validation and using macros to improve user interface design. They will also learn how to use advanced database management, distribute and secure a database and manage switchboards.

YOUR INSTRUCTOR

Sandra Batakis - A+ Trainer, MCT, MCSE, CIW

Sandra is a Senior Microsoft Certified Instructor with over 15 years in the IT certification training and courseware development field. She has offered a wide variety of IT training and high level consulting projects for Fortune 500 companies. She possesses extensive hands-on IT experience including working with building computer networking infrastructure, configuring LAN, WAN and Internet security gateways, Implementing and migrating to Microsoft Exchange 5, 2000, 2003, 2007 and the new Exchange 2010. She has delivered numerous Microsoft, CompTIA and Adobe classroom-based as well as online Boot Camps and Seminars across the United.

FEATURES

Main Menu
The organized and effective structure enables users to browse through hours of comprehensive content rapidly and with ease.

Resume
Every course resumes where you finished during the previous session in case you forget where you stopped.

Live Demonstrations
Instructors provide live and "hands on" demonstrations to explain and show users how to complete tasks. This enables users to witness professionals perform everyday tasks in real world settings as often as they like.

Topic A: Field and Record Validation
Field and Record Navigation
Field Properties for a Number Data Type Field in tblInventory
Input Masks
Input Mask Characters
Lookup Lists
Demo 2-1: Validating Data with a Field Property
Topic B: Form Validation
Selecting the Type of Combo Box for a Form
Controls – List Box and Option Group
Demo 2-2: Using a Combo Box Control to Limit Option Values
Lesson 02 Review

Lesson 03 - Using Macros to Improve User Interface Design

Topic A: Create a Macro
Macros
The Macro Builder Window and Action Catalog
Macro Actions and Positioning Arrows
Types of Macro Actions
Event Options Form Field
Macro Event Groups
Events and Supported Controls
Demo 3-1: Creating a Macro to Open a New Record on a Form
Topic B: Restrict Records Using a Condition
The OpenForm Macro Action with Where Condition
Demo 3-2: Using the Where Condition to Restrict Data
Topic C: Validate Data Using a Macro
Validate Data Using a Macro
Demo 3-3: Using a Macro to Validate Data
Topic D: Automate Data Entry Using a Macro
Event Properties for Automating Data Entry
Demo 3-4: Automating Data Entry with a Macro
Topic E: Convert a Macro to VBA
Macros and VBA
Demo 3-5: Converting a Macro to VBA
Lesson 03 Review