facebook     googleplus   twitter    linkedin

Microsoft Access Training 2010 Tutorial Courses Online

Microsoft Access 2010 is all about database simplicity, with ready-to-go templates to get you going and powerful tools that stay relevant as your data grows.

Our Access 2010 training course empowers you to make the most of your information—even if you're not a database expert. And, through newly added Web databases, Access amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser

Access 2010 is the newest version of Microsoft's dynamic database management tool and it offers features that allow you to create and modify a variety of database types. The ribbon is unique to Microsoft Office and stacks the many features of Access into related tabs, making it easy to quickly access the ones you need. Backstage view is a streamlined gathering of all database file-level tools, such as those used for saving, creating databases and tables, and working with external data. This course explores the fundamentals of databases and the many tools that will help you create and modify databases in Access 2010.

Access 2010

Our Training Features

  • Available in either Online ( One year unlimited access) or CBT CD
  • Used by 1000's of companies
  • Includes interactive simulations to practice - MS Office software not required
  • Printable transcripts of all lessons
  • Review questions - to test ones understanding of the material
  • Beginner to Advance Levels on Videos

Course Outline

Beginner Training Level

Getting Started

  • Fundamentals of databases
  • Plan a basic Access 2010 database
  • Key features of the Access 2010 interface and their functions
  • Create a database using a template
  • Create a blank database
  • Create a database from a template
  • Add application parts to a database

Creating Basic Tables

  • Correct naming convention for tables
  • Tables in Design view
  • Datasheet view
  • Primary key for a table
  • Input masks for table fields
  • Indexes for table fields
  • Validation rules modify tables
  • Create and modify a basic table

Data Manipulation and Simple Relationships

  • Modify how data is presented in datasheets
  • Sort and filter records in datasheets
  • Find and replace data in records
  • Import data from an Excel spreadsheet into an Access database
  • Export data from one Access database to another
  • Ky characteristics of table relationships
  • Create table relationships in a database
  • Edit table relationships
  • Sort and filter records
  • Find and replace data
  • Import and export data
  • Create and edit table relationships in a database

Introduction to Forms

  • Create basic forms
  • Layout view and Design view used when modifying basic forms
  • Configure controls on a form
  • Web Browser Control on a form
  • Input masks for bound controls
  • Control that refers to a control in another form
  • Create a basic form

Modifying Basic Forms

  • Customize forms
  • Format forms by creating your own themes
  • Manage records in forms
  • Sort and filter records in forms
  • Work with navigation forms
  • Use a theme to format a form
  • Create a navigation form

Introduction to Queries

  • Recognize the basic characteristics of queries
  • Create basic select queries
  • Modify queries
  • Use calculations to refine query data
  • Apply grouping and calculating functions to query results
  • Create crosstab queries
  • Unmatched queries
  • Find duplicates queries
  • Create and modify a Select query
  • Refine a query using groupings and calculations
  • Create a Crosstab query
  • Create a Find duplicates query

Introduction to Reports

  • Distinguish between the tools used to create reports
  • Create reports using client-compatible and web-compatible report tools
  • Reports using non-web-compatible report tools
  • Organize Access reports
  • Add controls to a report
  • Apply data bars to a report control to present data
  • Create a chart in a report to present data
  • Create a report using a client-compatible and web-compatible report tool
  • Create a report using a non-web-compatible report tool
  • Group data in a report
  • Add controls to a report

Advanced Training Level

Advanced Importing and Exporting

  • Import data from one Access database into another Access database
  • Import data from SQL Server into an Access database
  • Link an Access database to data in SQL Server
  • Export data from an Access database to a Word document
  • Export data from an Access database to an Excel spreadsheet
  • Export data from an Access database to an XML document
  • Collect data by using e-mail messages
  • Import Outlook 2010 contacts to a new Access 2010 table
  • Import data in Access
  • Export data from Access to other applications
  • E-mail messages to collect data in Access
  • Import an Outlook 2010 folder to a new Access 2010 table

PivotTables and PivotCharts

  • Key characteristics of Access PivotTables
  • Create a PivotTable in an Access database
  • Use a PivotTable to analyze data
  • Create a PivotChart in an Access database
  • Use a PivotChart to analyze data
  • Create a PivotTable and manipulate its data
  • Create a PivotChart and manipulate its data

Retrieving, Validating, and Attaching Data

  • Create a lookup field for data entry
  • Modify the behavior of a lookup field
  • Validate control data on a form using the Expression Builder
  • Identify ways that attachments can be used in Access 2010
  • Add an attachment to a table
  • Add an attachment to a form
  • Create a lookup field and change its behavior
  • Validate control data on a form
  • Add an attachment to a table
  • Add an attachment to a form

Subforms, Subreports, and Conditional Formatting

  • Create subforms
  • Set the default view of a subform
  • Sreate subreports
  • Make design change subreports
  • Apply conditional formatting to data in a report
  • Change the priority of a conditional formatting rule
  • Add a subform to a form and set it's default view
  • Add a subreport to a report and prepare to make subsequent design alterations
  • Use conditional formatting in a report

Joins, SQL, and Action Queries

  • Create and edit joins in Access 2010 databases
  • Creates a parameter query
  • Modify data in existing tables
  • Create a new table from data in other tables
  • Delete data from an Access 2010 database
  • Identify how to create a union queries
  • Modify an object within a database using a data-definition query
  • Access a hosted database with a view to running a pass-through query
  • Remove duplicate records from a table using a subquery
  • Specify a join in a query
  • Use action queries to modify a database
  • Create and refine queries using SQL

Using Access 2010 with SharePoint and Access Services

  • identify key characteristics of SharePoint and its integration with Access 2010
    share data by linking Access to a SharePoint list
    share data by exporting Access tables to SharePoint
    share data by moving Access tables to SharePoint
    use templates to create new SharePoint lists in Access
    identify key characteristics of publishing Access 2010 applications on SharePoint
    publish the entire Access application to SharePoint
    share Access and SharePoint data
    publish the entire Access application to SharePoint




Questions? e-mail us at:

Copyright  © 1996-2013 Netwind Learning Center / CDi Communications, Inc.


Call 1.800.617.5586 for pricing

Access Training 2010
(item# skacc10on)
Payment Options

1-800-617-5586 (352.404.8866)
All major credit cards (Visa, MasterCard, Amex, and Discover)
Company Purchase Orders may be faxed to 1.877.557.3064