Complete the form below to request a quote for
Access 2010 L1-3

Name is required

Company is required


Phone is required

Select type

Select size

Tell us about your objectives

           
Code:
         INVALID CODE!

Microsoft Office Access 2010 CBT Training

Microsoft Office Access 2010 CBT Training
Online Delivery
$149
$99

DVD-ROM Delivery
$175
$149

DVD Lending License
$438
$388

Online Delivery License
    Add LearningZone Live Mentor for $50.  
($695 Value!)

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

  • Online Training Access or 3 DVD-ROMs featuring live instructor-led classroom sessions with full audio, video and demonstration components
  • Printable courseware
  • 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. 

COURSE OUTLINE

Unit 01 - Getting Started

Topic A: Database Concepts
Database Components
Relational Database

Topic B: Exploring the Access Environment
The Access Environment
Demo - B-1: Starting Access and Examining the Access Window
Opening Databases
Demo - B-2: Opening a Database
The Navigation Pane and Menu
Demo - B-3: Using the Navigation Pane
Open a Database Table
Demo - B-4: Examining a Database Table

Topic C: Getting Help
Access Help Online
Access Help Offline
Demo - C-1: Using Help
Unit 01 Review
Topic A: Database Concepts
Unit 01 Review
 
Unit 02 - Databases and Tables
 
Topic A: Planning and Designing Databases
Planning a Database
Rules for Names
Using a Database Template
Demo - A-2: Creating a Database from a Template
Creating a Blank Database
Demo - A-3: Creating a Blank Database

Topic B: Exploring Tables
Views for Tables
Datasheet View
Demo - B-2: Examining a Table in Datasheet View
Navigating in Datasheet View
The Record Selector
Demo - B-3: Navigating a Table in Datasheet View
Table in Design View
Demo - B-4: Examining a Table in Design View

Topic C: Creating Tables
Demo - C-1: Creating a Table from a Table Template
Creating Tables in Design View
Demo - C-2: Creating a Table in Design View
Demo - C-3: Adding Fields and Descriptions to a Table
Setting the Primary Key
Demo - C-4: Setting the Primary Key
The Save As Dialog Box
Demo - C-5: Saving the Table
Adding a Record
Demo - C-6: Adding a Record
The Paste Table As Dialog Box
Demo - C-7: Copying, Modifying, and Deleting a Table
A Composite Key
Demo - C-8: Creating a Composite Key
Demo - C-9: Using the Data Type Gallery
Unit 02 Review
 
Unit 03 - Fields and Records
 
Topic A: Changing the Design of a Table
Ineffective Field Names
Demo - A-1: Modifying Field Names
Selecting a Field
Deleting and Inserting Fields
Demo - A-2: Deleting and Inserting Fields
Moving a Field
Demo - A-3: Moving a Field
Using the Attachment Data Type
The Attachments Dialog Box
Demo - A-4:Using the Attachment Data Type
Demo - A-5: Adding a Totals Row

Topic B: Finding and Editing Records
The Find and Replace Dialog Box
Demo - B-1: Finding and Replacing a Value
Undoing Changes
Demo - B-2: Undoing Changes

Topic C: Organizing Records
Sorting Records by a Single Field
Demo - C-1: Sorting Records by a Single Field
Sorting Records by Multiple Fields
Demo - C-2: Sorting Records by Multiple Fields
Filter By Selection
Filter from the Shortcut Menu
Demo - C-3: Using Filter By Selection
Filter By Form
Demo - C-4: Using Filter By Form
Filter Excluding Selection
Demo - C-5: Using Filter Excluding Selection
Advanced Filter/Sort
Demo - C-6: Using Advanced Filter/Sort
Deleting Records
Demo - C-7: Deleting a Record
Unit 03 Review
 
Unit 04 - Data Entry Rules
 
Topic A: Setting Field Properties
Field Properties
Setting the Required Property
Demo - A-1: Setting the Required Property
Allow Zero Length Property
Demo - A-2: Using the Allow Zero Length Property
Field Size Property
Demo - A-3: Setting the Field Size Property
Append Only Property
The History Dialog Box
Demo - A-4: Setting the Append Only Property

Topic B: Working with Input Masks
Input Mask Definition: Sections
Creating an Input Mask
Demo - B-1: Creating an Input Mask
Using the Input Mask Wizard
Demo - B-2: Working with the Input Mask Wizard

Topic C: Setting Validation Rules
Creating a Validation Rule
Demo - C-1: Creating Validation Rules
Setting Validation Text
Demo - C-2: Setting Validation Text
Unit 04 Review
 
Unit 05 - Basic Queries
 
Topic A: Creating and Using Queries
Queries
The Simple Query Wizard
Demo - A-2: Using the Query Wizard
Creating Queries in Design View
Demo - A-3: Creating a Query in Design View
Saving and Running a Query
Demo - A-4: Saving and Running the Query
Sorting Query Results
Demo - A-5: Sorting Query Results
Filtering Query Results
Demo - A-6: Filtering a Query by Adding Criteria
Creating Queries from Filters
Demo - A-7: Creating a Query from a Filter

Topic B: Modifying Query Results and Queries
Editing Records in Query Results
Demo - B-1: Editing Query Results
Modifying the Query Design
Demo - B-2: Adding Fields to a Query
Searching for Null Values
Demo - B-3: Finding Records with Empty Fields

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 B: Using Design View
Creating Forms in Design View
Demo - B-1: Creating a Form in Design View
Adding a Control
Demo - B-2: Adding Controls
A Property Sheet
Modifying Section Properties
Demo - B-3: Modifying Properties
Conditional Formatting
Demo - B-4: Applying Conditional Formatting

Topic C: Sorting and Filtering Records
Sorting Records
Demo - C-1: Using a Form to Sort Records
Filtering Records
Demo - C-2: Using a Form to Filter Records
Unit 06 Review
 
Unit 07 - Working with Reports
 
Topic A: Creating Reports
Print Preview
Demo - A-1: Examining a Report
Basic Reports
Demo - A-2: Creating a Basic Report
Using the Report Wizard
Sample Report Preview
Demo - A-3: Creating a Report by Using the Report Wizard
Sections in Design View
Demo - A-4: Creating a Report in Design View

Topic B: Modifying and Printing Reports
Modifying Reports
Demo - B-1: Modifying a Report in Design View
Layout View
Demo - B-2: Modifying a Report in Layout View
Grouping Records in a Report
Group, Sort, and Total Pane
Demo - B-3: Grouping, Sorting, and Filtering a Report
Adding Summary Fields
Summary Options Dialog Box
Demo - B-4: Adding Summary Fields by Using the Report Wizard
Modifying Report Layout and Style
Demo - B-5: Modifying the Layout and Style of a Report
The Print Preview Tab
Demo - B-6: Printing a Report
Unit 07 Review
 
Unit 08 - Relational Databases
 
Topic A: Database Normalization
Normalization
Steps to Normalize: Rule 1
Steps to Normalize: Rule 2
Steps to Normalize: Rule 3
Demo - A-3: Using the Table Analyzer
Demo - A-4: Identifying Object Dependencies

Topic B: Table Relationships
Establishing Relationships
The Relationships Window
Demo - B-1: Establishing a One-to-One Table Relationship
One-to-Many Relationship
Demo - B-2: Establishing a One-to-Many Table Relationship
Junction Tables
Many-to-Many with Junction
Demo - B-3: Establishing a Many-to-Many Table Relationship
Printing Table Relationships
Demo - B-4: Printing Table Relationships

Topic C: Referential Integrity
Referential Integrity
Demo - C-1: Planning Table Relationships
Orphan Records
Demo - C-2: Working with Orphan Records
Using Cascading Deletes
Demo - C-3: Setting Cascading Deletes
Testing Cascading Deletes
Demo - C-4: Testing Cascading Deletes
Cascading Updates
Demo - C-5: Using Cascading Updates
Unit 08 Review
 
Unit 09 - Related Tables
 
Topic A: Creating Lookup Fields
Lookup Field
Creating a Lookup Field
Demo - A-1: Creating a Lookup Field
Multivalued Fields
A Multivalued Lookup Column
Demo - A-2: Creating a Multivalued Lookup Field

Topic B: Modifying Lookup Fields
Display Column Headings
Demo - B-1: Modifying Lookup Field Properties
Types of Controls
Using a Value List Combo Box
Demo - B-2: Changing a Text Box to a Combo Box

Topic C: Using Subdatasheets
A Subdatasheet
Inserting a Subdatasheet
Demo - C-1: Using a Subdatasheet
Unit 09 Review
 
Unit 10 - Complex Queries
 
Topic A: Joining Tables in Queries
Joins
Query Wizard
Creating a Query
Demo - A-1: Creating a Query with the Simple Query Wizard
Creating Joins in Design View
Demo - A-2: Creating a Join in Design View
Creating Outer Joins
Demo - A-3: Creating an Outer Join
Joins with an Intermediate Table
Demo - A-4: Creating a Join with an Intermediate Table
Creating a Self-Join Query
Demo - A-5: Creating a Self-Join Query
Finding Unmatched Records
Demo - A-6: Finding Records that Do Not Match Between Tables
Finding Duplicate Records
Demo - A-7: Finding Duplicate Records
Demo - A-8: Deleting Tables from a Query

Topic B: Using Calculated Fields
Syntax for Calculated Fields
Creating Calculated Fields
Demo - B-1: Creating a Calculated Field
Modifying Formats
Demo - B-2: Changing the Format of a Displayed Value
The Expression Builder
Specifying Criteria
Demo - B-3: Using the Expression Builder

Topic C: Summarizing and Grouping Values
Summary Functions in Queries
Demo - C-1: Creating a Query to Display Summary Values
Concatenation
Demo - C-2: Using Queries to Concatenate Values
Unit 10 Review
 
Unit 11 - Advanced Form Design
 
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
Unit 12 - Reports and Printing
Topic A: Customized Headers and Footers
Report Header
Add a Report Header
Demo - A-1: Adding a Report Header
Report Footer
Demo - A-2: Adding a Report Footer
New Formatting Rule Dialog Box
Demo - A-3: Applying Conditional Formatting
Set the Keep Together Property
Demo - A-4: Keeping Parts of a Report on the Same Page
The Group, Sort, and Total Pane
Demo - A-5: Adding Controls to Group Footers
Force a New Page
Demo - A-6: Forcing a New Page

Topic B: Calculated Values
The DateDiff Function
Using the DateDiff Function
Demo - B-1: Working with the DateDiff Function
The IIf Function
Demo - B-2: Using the IIf Function<

Topic C: Printing
Printing a Database Object
Demo - C-1: Printing a Table
Using the Database Documenter
Demo - C-2: Printing a Database Document<

Topic D: Labels
Using the Label Wizard
Labels in Print Preview
Demo - D-1: Creating Labels
Unit 12 Review

Unit 13 - Charts

Topic A: Charts in Forms
Adding a Chart to a Form
Chart Types
Demo - A-1: Creating a Chart in a Form
Naming the X- and Y-axes
Demo - A-2: Modifying a Chart in a Form

Topic B: Charts in Reports
Charts in Reports
Demo - B-1: Adding a Chart to a Report
Format a Chart Item
The Chart Type Dialog Box
Demo - B-2: Modifying Charts in Reports
Unit 13 Review
Unit 14 - PivotTables and PivotCharts


Topic A: PivotTables
PivotTable View
Drop Areas
Demo - A-1: Examining PivotTable View
Add Fields to a PivotTable
Demo - A-2: Adding Fields to a PivotTable

Topic B: Modifying PivotTables
Summarize Data
Demo - B-1: Creating Totals
Move Fields in a PivotTable
Demo - B-2: Moving Fields in a PivotTable
Hide or Show Details
Demo - B-3: Showing and Hiding Details in a PivotTable
Change Field Settings
Demo - B-4: Formatting Fields

Topic C: PivotCharts
PivotChart Field Mapping
A PivotChart
Demo - C-1: Creating a PivotChart

Topic D: PivotTable Forms
Create a PivotTable Form
Demo - D-1: Creating a PivotTable Form
Unit 14 Review
Unit 15 - Querying with SQL


Topic A: SQL and Access
Sample SQL Statements
A Query in SQL View
Demo - A2: Examining a SQL Statement in Access

Topic B: Writing SQL Statements
Writing a SQL Statement
Demo - B1: Writing a SQL SELECT Statement
Syntax for WHERE Clause
Demo - B2: Using the WHERE Clause
Aliases
Demo - B3: Creating Aliases
Syntax to Display Matched Records
Demo - B4: Displaying Matching Records from Related Tables
Syntax to Display Unmatched Records
Demo - B5: Finding Unmatched Records
Context-Sensitive Help
Demo - B6: Getting Context-Sensitive Help on SQL

Topic C: Attaching SQL Queries to Controls
SQL-Specific Queries
Create a Union Query
Attach a SQL Query to a Button
Command Button Wizard
Demo - C1: Assigning a SQL Query to a Command Button
Unit 15 Review>
Unit 16 - Advanced Queries

Topic A: Creating Crosstab Queries
A Crosstab Query Result
Demo - A-1: Viewing a Crosstab Query
Create a Crosstab Query
The Crosstab Query Wizard
Demo - A-2: Using the Crosstab Query Wizard

Topic B: Creating Parameter Queries
Create a Single-Criterion Query
Demo - B1: Creating a Single-Criterion Parameter Query
Create a Multiple-Criteria Query
Demo - B2: Creating a Query with Multiple Parameters
Create a Wildcard Query
Demo - B3: Using a Wildcard in a Parameter Query

Topic C: Using Action Queries
Types of Action Queries
Use an Append Query
Demo - C1: Adding Records to a Table with an Append Query
Use a Delete Query
Demo - C2: Deleting Records with a Delete Query
Use an Update Query
Demo - C3: Modifying Records with an Update Query
Use a Make Table Query
Demo - C4: Creating a Make Table Query
Unit 16 Review
Unit 17 - Macro

Topic A: Creating, Running, and Modifying Macros
Sample Macro
The Macro Tools | Design Tab
Demo - A1: Creating and Running a Macro
Demo - A2: Modifying a Macro

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
Unit 18 - Advanced Macros

Topic A: Creating Macros to Provide User Interaction
Sample Macro with a Condition
Create a Data Validation Macro
Demo - A1: Creating a Data Validation Macro
Create a Data Entry Macro
Demo - A2: Creating a Data Entry Macro

Topic B: Creating Macros that Require User Input
Macro to Run a Parameter Query
Demo - B1: Creating a Macro that Runs a Parameter Query

Topic C: Creating AutoKeys and AutoExec Macros
The AutoKeys Macro
Demo - C1: Creating an AutoKeys Macro
Create an AutoExec Macro
Demo - C2: Creating an AutoExec Macro

Topic D: Creating Macros for Data Transfer
The ImportExportData Action
Demo - D1: Importing a Database Object by Using a Macro
Export Data to a Spreadsheet
Demo - D2: Exporting Data to a Spreadsheet by Using a Macro
Unit 18 Review
Unit 19 - Importing, Exporting, and Linking

Topic A: Importing Objects
Import Objects from a Database
The Import Objects Dialog Box
Demo - A1: Importing Multiple Objects
Import Objects from Excel
Demo - A2: Importing an Object from Excel
Manage Data Tasks
Demo - A3: Using a Saved Import Specification
Fixed Width vs. Delimited Format
Demo - A4: Importing a CSV File

Topic B: Exporting Objects
Export Objects from a Database
The Export Table Dialog Box
Demo - B1: Exporting an Object
Demo - B2: Using a Saved Export Specification

Topic C: Working with XML Documents
Export as XML
The Export XML Dialog Box
The Import XML Dialog Box
Demo - C1: Exporting and Importing XML Documents
Export with an XSL File
Demo - C2: Exporting to an XML Document with an XSL File
Publish as PDF or XPS
Demo - C3: Saving a Table as an XPS File

Topic D: Linking Access Objects
Link a Table
Demo - D1: Linking to an Access Table
Update a Link
Linked Table Manager
Demo - D2: Updating Links
Link to an Excel Workbook
Demo - D3: Linking to an Excel Workbook<

Topic E: Using Hyperlink Fields
Create a Hyperlink Field
Demo - E1: Creating a Hyperlink Field
The Insert Hyperlink Dialog Box
Demo - E2: Inserting Data in a Hyperlink Field
Modify Hyperlink Data
Demo - E3: Modifying Data in a Hyperlink Field
Unit 19 Review
Unit 20 - Database Management

Topic A: Optimizing Resources
Convert to a Prior Version
Demo - A1: Converting a Database to a Prior Version
The Performance Analyzer
Performance Analyzer Results
Demo - A2: Analyzing Performance
Split a Database
Demo - A3: Splitting a Database
Compact and Repair a Database
Demo - A4: Using the Compact and Repair Database Utility
Back Up the Active Database
Demo - A5: Backing up a Database

Topic B: Protecting Databases
Encrypt and Password-Protect
Demo - B1: Encrypting a Database with a Password
Remove Password and Encryption
Demo - B2: Removing a Password and Encryption

Topic C: Setting Options and Properties
The Access Options Dialog Box
Demo - C1: Setting Access Options
Database Properties Dialog Box
Demo - C2: Creating and Populating Database Properties
Unit 20 Review
Course Closure



Product Code: MS-MO-10-AC