Access 2010 Training


Start learning now.

Sign up for Microsoft Office training, SharePoint training and more.

100% spam free.

What's Included:

Interactive Tutorials
Bite-sized software simulations.
Interactive Quizzes
Accurately test your staff's skills.
Customizable Courseware
Training manuals with unlimited printing rights.
FREE Cheat Sheets
Just sign up, download, and share.
Multiple Platforms
  • Desktop
  • Tablet / mobile

Access 2010 Courses

The Fundamentals

Length: 19 minutes

Access 2010 Training is a powerful database program you can use to store all kinds of information, from a simple list to an inventory catalog of thousands of products. Once the information in put in Access, it's easy to find and analyze. In this course you'll become familiar with the Access 2010 working environment. You'll learn about the program screen, how to give commands, use Help, and all the new features that have been added to Access 2010 Training.

Introduction to Databases
Starting Access 2010
The Getting Started Page and Opening a Database
What's New in Access 2010
Understanding the Access Program Screen
Understanding the Ribbon
Using the Office Button and Quick Access Toolbar
Using Keyboard Commands
Using Contextual Menus
Using Help

Database Basics

Length: 33 minutes

There are many great things you can do in Access 2010 Training, but before you can dive in headfirst you need to learn the basics. In this course you will learn how Access' basic functionality, such as entering date and the basics of tables, forms, queries, and reports.

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
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying and Pasting Data
Using Undo and Redo
Checking Your Spelling
Using the Zoom Box
Exiting Access 2010

Creating and Working with a Database

Length: 49 minutes

Thankfully, you can stop typing lists of information in Word and Excel by creating a database in Access. In this Access 2010 Training course you will learn how to create databases that store names, addresses, and any other type of information you can think of.

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

Length: 1 hour 8 minutes

As a database becomes larger and larger, finding a specific record becomes harder and harder. Luckily, Access 2010 Training has commands, such as Find, Sort, and Filter that can track down particular records. This course will teach you how to use these commands, sort information in a table, and use filters to display only records that meet your criteria.

Finding and Replacing Data
Sorting Records
Using Common Filters
Filtering by Selection
Filtering by Form
Creating an Advanced Filter
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

Length: 1 hour 34 minutes

The most useful and efficient databases consist of well-structured tables. This Access 2010 Training course will explain what you need to know about tables and fields: how to link two related tables, how to create indexes for faster performance, and how to create primary key fields.

Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Using 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

Length: 13 minutes

Many people find the concept of relational databases difficult to understand. In this Access 2010 Training course you will receive a clear understanding of relational databases. You will learn how to link tables together in a one-to-many relationship to create a relational database. You will also learn how to enforce referential integrity to keep records accurate.

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

Working with Queries

Length: 1 hour 2 minutes

Queries are the superstars of Access. Queries make sense out of all the jumbled records and display only what you need to know. In this Access 2010 Training course you will learn how to harness the power of queries. You will learn about all the different types of queries and how they function within Access.

Understanding the Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions and the Expression Builder
Using an IIF Function
Summarizing Groups of Records
Displaying 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

Length: 38 mintues

A form created in Access is just like any ordinary paper form; only you donĀ't have to worry about reading bad penmanship. In Access, forms give you an easy way to enter and view data in a table. In this Access 2010 Training course you will learn how to create, add content, and create a form.

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
Changing a Control's Data Source
Form Property Reference
Creating a Calculated Control
Changing a Control's Default Value
Creating a Subform
Modifying and Working with Subforms

Working with Reports

Length: 24 minutes

Reports are handy to know if you need to print professional copies of any analyzed from your database. This Access 2010 Training course will explain how to create and work with reports from tables and queries.

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

Formatting Forms and Reports

Length: 8 minutes

Looking to create sharp-looking forms and reports? This Access 2010 Training course will explain how to format your forms and reports. You will learn how to change appearance of text and add graphics to make forms and reports visually appealing and functional.

Formatting Fonts
Changing Text Alignment
Changing Colors
Applying Special Effects
Using Conditional Formatting
Adding Pictures, Lines and Gridlines
Working with Number Formatting
Using AutoFormat

Working with Macros

Length: 15 minutes

Macros are extremely useful when working in Access 2010. A macro helps you perform routine tasks by automating them. Learn how to create, run, edit, and work with Macro groups to simplify routine tasks.

Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference

Advanced Topics

Length: 18 minutes

Now that you are an expert at Access 2010, learn how you can easily share information between different databases and different programs. In this Access 2010 Training course you will learn how to import and export data from external resources.

Importing Information
Exporting Information
Linking Information from an External Source
Using Hyperlink Fields
Displaying Database Object Dependencies
Setting a Password in Access
Compacting and Repairing a Database