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 2010 for students of any skill level. The course begins with basic concepts and gradually progresses to more advanced topics. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

Students will also learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

Finally, students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

PACKAGE INCLUDES

Exclusive LearningZone Live Mentor Click for Details(Value at $695)
Help Whenever you need it! Exclusive LearningZone - Chat Live with our Certified Instructors anytime around the clock (24/7)

Focused on practical solutions to real-world development problems

Free 1 Year Upgrade Policy

YOUR INSTRUCTOR

Drew Fierst - Drew has been working with databases in Microsoft Access for over 12 years. He has constructed databases for clients in a variety of industries including transportation, manufacturing, and insurance. Over the course of his career, Mr. Fierst has taught database construction and database application development skills to numerous individuals for both personal and business use. types of clients.

FEATURES

Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.

PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...

Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.

Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.

Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.

Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.

Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.

Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.

Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.

Certificate of Completion
Career Academy is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving a Career Academy Distance Education Certificate of Completion.

Topic C: Performing Operations in Queries
Using Comparison Operators
Demo - C-1: Using Comparison Operators
Using the OR Condition
Demo - C-2: Using the OR Condition
Using the AND Condition
Demo - C-3: Using the AND Condition
Wildcard Operators
Demo - C-4: Using the * Wildcard
Using Calculations
Demo - C-5: Using Calculations in a Query
Totaling a Group of Records
Demo - C-6: Totaling a Group of Records
Avg and Count Functions
Demo - C-7: Using the Avg and Count Functions
Demo - C-8: Using the Min and Max Functions
Unit 05 Review

Unit 06 - Using Forms

Topic A: Creating Forms
A Sample Form
A Form in Design View
Form Tools on the Design Tab
Form Tools on the Arrange Tab
Form Tools on the Format Tab
Demo - A-1: Examining a Form
Using the Form Button
A Basic Form
Demo - A-2: Creating a Basic Form
The Form Wizard
Demo - A-3: Creating a Form by Using the Form Wizard

Topic A: Adding Unbound Controls
Unbound Controls
Drawing a Rectangle on a Form
Demo - A-1: Drawing a Rectangle Around a Control
Changing the Tab Order
Demo - A-2: Changing the Tab Order
Creating a Grouped Control
Demo - A-3: Grouping Controls

Topic B: Adding Graphics
Add a Graphic to a Form
Demo - B-1: Adding a Graphic to a Form
Use an Unbound Object Frame
Demo - B-2: Embedding a Graphic in an Unbound Object Frame

Topic C: Adding Calculated Values
Bind Controls to Calculated Fields
Demo - C-1: Binding a Control to a Calculated Field
Create a Calculated Control
Align Controls on a Form
Demo - C-2: Creating a Calculated Control

Topic D: Adding Combo Boxes
Add a Combo Box to a Form
Demo - D-1: Adding a Combo Box to a Form
Modify Combo Box Properties
Demo - D-2: Modifying the Properties of a Combo Box

Topic E: Advanced Form Types
Create a Multiple-item Form
Demo - E-1: Creating a Multiple-Item Form
A Split Form
Demo - E-2: Creating a Split Form
A Datasheet Form
Demo - E-3: Creating a Datasheet Form
A Form and Subform
Demo - E-4: Creating a Subform
Unit 11 Review

Topic B: Attaching Macros to the Events of Database Objects
The Event Tab
Demo - B1: Attaching a Macro to the Open Event of a Form
Attach Macro to Command Button
Demo - B2: Attaching a Macro to a Command Button
Unit 17 Review