Microsoft Office Access 2013 (Level 1-3)

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 is a comprehensive course covering all of the functions and features of Access 2013 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. Students will first learn about working with table data, querying a database, creating advanced queries, generating reports and customizing the Access environment. They will also learn about designing a relational database, joining tables, advanced reporting, organizing a database for efficiency and sharing data across applications. Finally, students will learn about implementing advanced form design, using data validation, using macros to improve user interface design, advanced database management, distributing and securing a database and managing 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