Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Access 2010 Course

Microsoft Access 2010 Self Paced Training Course

Course Description: Introduces the new features and functions of Access 2010, while training students on all the core, intermediate and advanced operations available in Access 2010.

Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

6-month license

12-month license

free demo

Microsoft Access 2010 Self-Paced Course Syllabus

Microsoft Access 2010 online training syllabus

Database Basics

  • Introduction to Databases
  • What's New in Access 2010
  • Understanding the Access Program Screen
  • Working with Database Objects
  • Tour of a Table
  • Adding, Editing, and Deleting Records
  • Tour of a Form
  • Tour of a Query
  • Tour of a Report
  • Selecting Data
  • Using the Zoom Box
  • Creating and Working with a Database
    Planning a Database Creating a New Database Creating a Table Modifying a Table Creating a Query Sorting a Query Using AND and OR Operators in a Query Creating a Form with the Form Wizard Creating a Report with the Report Wizard Creating Mailing Labels with the Label Wizard Converting an Access Database

    Finding, Filtering, and Formatting Data

    Finding and Replacing Data Sorting Records Using Common Filters Filtering by Selection Filtering by Form Creating an Advanced Filters Adjusting and Rearranging Rows and Columns Changing Gridline and Cell Effects Changing the Datasheet Font Freezing a Column Hiding a Column

    Working with Tables and Fields
    Understanding Field Properties Indexing a Field Adding a Primary Key to a Table Inserting, Deleting, and Reordering Fields Adding Field Descriptions and Captions Changing the Field Size Formatting Number, Currency, and Date/Time Fields Formatting Number, Currency, and Date/Time Fields by Hand Formatting Text Fields Setting a Default Value Requiring Data Entry Validating Data Creating an Input Mask Creating a Lookup Field Creating a Value List Modifying a Lookup List

    Creating Relational Databases

    Understanding Table Relationships Creating Relationships Between Tables Enforcing Referential Integrity Printing and Deleting Relationships Understanding Relationship Types

    Working with Queries
    Understanding Different Types of Queries Creating a Multiple Table Query Creating a Calculated Field Working with Expressions and the Expression Builder Using an IF Function Summarizing Groups of Records Display Top or Bottom Values Parameter Queries Finding Duplicate Records Finding Unmatched Records Crosstab Queries Delete Queries Append Queries Make-Table Queries Update Queries

    Working with Forms

    Creating and Using a Form Understanding Form Views Modifying a Form in Layout View Form Design View Basics Changing Tab Order Working with Control Properties Control Property Reference Working with Form Properties Form Property Reference Changing a Control's Data Source Creating a Calculated Control Changing a Control's Default Value Creating a Subform Modifying and Working with Subforms

    Working with Reports
    Creating a Report Working in Layout View Adding a Logo Working in Design View Adjusting Page Margins and Orientation Adding Page Numbers and Dates Grouping and Sorting Summarize Data using Totals Understanding Report Sections

    Additional Topics
    Using Conditional Formatting Working with Number Formatting Using Themes Importing Information Exporting Information Displaying Database Object Dependencies Compacting and Repairing a Database

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)

Business Computer Skills BBB Profile