Access 2010 Training

Access 2010 Training


Personalized Online Training

Get answers to everyday questions and on-demand training with over 7,000 Interactive Tutorials.

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 Devices

  • Desktop
  • Tablet / mobile

Course Outline

The Fundamentals

Microsoft Access 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.
  1. Introduction to Databases
  2. Starting Access 2010
  3. The Getting Started Page and Opening a Database
  4. What’s New in Access 2010
  5. Understanding the Access Program Screen
  6. Understanding the Ribbon
  7. Using the Office Button and Quick Access Toolbar
  8. Using Keyboard Commands
  9. Using Contextual Menus
  10. Using Help

Database Basics

There are many great things you can do in Access, but before you can dive in headfirst you need to learn the basics. This course you will learn Access basic functionality, such as entering date and the basics of tables, forms, queries, and reports.
  1. Working with Database Objects
  2. Tour of a Table
  3. Adding, Editing and Deleting Records
  4. Tour of a Form
  5. Tour of a Query
  6. Tour of a Report
  7. Previewing and Printing a Database Object
  8. Selecting Data
  9. Cutting, Copying and Pasting Data
  10. Using Undo and Redo
  11. Checking Your Spelling
  12. Using the Zoom Box
  13. Exiting Access 2010

Creating and Working with a Database

Thankfully, you can stop typing lists of information in Word and Excel by creating a database in Access. In this course you will learn how to create databases that store names, addresses, and any other type of information you can think of.
  1. Planning a Database
  2. Creating a New Database
  3. Creating a Table
  4. Modifying a Table
  5. Creating a Query
  6. Sorting a Query
  7. Using AND and OR Operators in a Query
  8. Creating a Form with the Form Wizard
  9. Creating a Report with the Report Wizard
  10. Creating Mailing Labels with the Label Wizard
  11. Converting an Access Database

Finding, Filtering, and Formatting Data

As a database becomes larger and larger, finding a specific record becomes harder and harder. Luckily, Access 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.
  1. Finding and Replacing Data
  2. Sorting Records
  3. Using Common Filters
  4. Filtering by Selection
  5. Filtering by Form
  6. Creating an Advanced Filter
  7. Adjusting and Rearranging Rows and Columns
  8. Changing Gridline and Cell Effects
  9. Changing the Datasheet Font
  10. Freezing a Column
  11. Hiding a Column

Working with Tables and Fields

The most useful and efficient databases consist of well-structured tables. This 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.
  1. Understanding Field Properties
  2. Indexing a Field
  3. Adding a Primary Key to a Table
  4. Inserting, Deleting, and Reordering Fields
  5. Using Field Descriptions and Captions
  6. Changing the Field Size
  7. Formatting Number, Currency, and Date/Time Fields
  8. Formatting Number, Currency, and Date/Time Fields by Hand
  9. Formatting Text Fields
  10. Setting a Default Value
  11. Requiring Data Entry
  12. Validating Data
  13. Creating an Input Mask
  14. Creating a Lookup Field
  15. Creating a Value List
  16. Modifying a Lookup List

Creating Relational Databases

Many people find the concept of relational databases difficult to understand. In this 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.
  1. Understanding Table Relationships
  2. Creating Relationships between Tables
  3. Enforcing Referential Integrity
  4. Printing and Deleting Relationships
  5. Understanding Relationship Types

Working with Queries

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 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.
  1. Understanding the Different Types of Queries
  2. Creating a Multiple Table Query
  3. Creating a Calculated Field
  4. Working with Expressions and the Expression Builder
  5. Using an IIF Function
  6. Summarizing Groups of Records
  7. Displaying Top or Bottom Values
  8. Parameter Queries
  9. Finding Duplicate Records
  10. Finding Unmatched Records
  11. Crosstab Queries
  12. Delete Queries
  13. Append Queries
  14. Make-Table Queries
  15. Update Queries

Working with Forms

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 course you will learn how to create, add content, and create a form.
  1. Creating and Using a Form
  2. Understanding Form Views
  3. Modifying a Form in Layout View
  4. Form Design View Basics
  5. Changing Tab Order
  6. Working with Control Properties
  7. Control Property Reference
  8. Working with Form Properties
  9. Changing a Control’s Data Source
  10. Form Property Reference
  11. Creating a Calculated Control
  12. Changing a Control’s Default Value
  13. Creating a Subform
  14. Modifying and Working with Subforms

Working with Reports

Reports are handy to know if you need to print professional copies of any analyzed from your database. This course will explain how to create and work with reports from tables and queries.
  1. Creating a Report
  2. Working in Layout View
  3. Adding a Logo
  4. Working in Design View
  5. Adjusting Page Margins and Orientation
  6. Adding Page Numbers and Dates
  7. Grouping and Sorting
  8. Summarize Data using Totals
  9. Understanding Report Sections

Formatting Forms and Reports

Looking to create sharp-looking forms and reports? This 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.
  1. Formatting Fonts
  2. Changing Text Alignment
  3. Changing Colors
  4. Applying Special Effects
  5. Using Conditional Formatting
  6. Adding Pictures, Lines and Gridlines
  7. Working with Number Formatting
  8. Using AutoFormat

Working with Macros

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.
  1. Creating and Running a Macro
  2. Editing a Macro
  3. Working with Macro Groups
  4. Assigning a Macro to an Event
  5. Creating Conditional Expressions
  6. Assigning a Macro to a Keystroke Combination
  7. Macro Action Reference

Advanced Topics

Now that you are an expert at Access 2010, learn how you can easily share information between different databases and different programs. In this course you will learn how to import and export data from external resources.
  1. Importing Information
  2. Exporting Information
  3. Linking Information from an External Source
  4. Using Hyperlink Fields
  5. Displaying Database Object Dependencies
  6. Setting a Password in Access
  7. Compacting and Repairing a Database