Access 2010 Training

Access 2010 Training

interactive-training-access-2010

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
  • LMS / SCORM

The Fundamentals

Length: 0:19:00

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.

Lesson 1 Introduction to Databases
0:04:43
Lesson 2 Starting Access 2010
0:01:50
Lesson 3 The Getting Started Page and Opening a Database
0:01:20
Lesson 4 What’s New in Access 2010
0:05:33
Lesson 5 Understanding the Access Program Screen
0:00:44
Lesson 6 Understanding the Ribbon
0:01:56
Lesson 7 Using the Office Button and Quick Access Toolbar
0:00:32
Lesson 8 Using Keyboard Commands
0:01:47
Lesson 9 Using Contextual Menus
0:00:10
Lesson 10 Using Help
0:00:07

Database Basics

Length: 0:33:00

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 will teach Access’ basic functionality, such as entering date and the basics of tables, forms, queries, and reports.

Lesson 1 Working with Database Objects
0:02:52
Lesson 2 Tour of a Table
0:01:19
Lesson 3 Adding, Editing and Deleting Records
0:01:40
Lesson 4 Tour of a Form
0:01:44
Lesson 5 Tour of a Query
0:04:55
Lesson 6 Tour of a Report
0:04:06
Lesson 7 Previewing and Printing a Database Object
0:02:45
Lesson 8 Selecting Data
0:03:10
Lesson 9 Cutting, Copying and Pasting Data
0:05:28
Lesson 10 Using Undo and Redo
0:02:22
Lesson 11 Checking Your Spelling
0:02:16
Lesson 12 Using the Zoom Box
0:00:55
Lesson 13 Exiting Access 2010
0:01:27

Creating and Working with a Database

Length: 0:49:00

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.

Lesson 1 Planning a Database
0:02:44
Lesson 2 Creating a New Database
0:06:15
Lesson 3 Creating a Table
0:04:04
Lesson 4 Modifying a Table
0:04:30
Lesson 5 Creating a Query
0:05:17
Lesson 6 Sorting a Query
0:02:02
Lesson 7 Using AND and OR Operators in a Query
0:02:23
Lesson 8 Creating a Form with the Form Wizard
0:04:29
Lesson 9 Creating a Report with the Report Wizard
0:07:58
Lesson 10 Creating Mailing Labels with the Label Wizard
0:06:57
Lesson 11 Converting an Access Database
0:02:21

Finding, Filtering, and Formatting Data

Length: 1:08:00

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.

Lesson 1 Finding and Replacing Data
0:14:11
Lesson 2 Sorting Records
0:04:18
Lesson 3 Using Common Filters
0:07:18
Lesson 4 Filtering by Selection
0:03:11
Lesson 5 Filtering by Form
0:06:42
Lesson 6 Creating an Advanced Filter
0:12:37
Lesson 7 Adjusting and Rearranging Rows and Columns
0:02:33
Lesson 8 Changing Gridline and Cell Effects
0:06:18
Lesson 9 Changing the Datasheet Font
0:03:15
Lesson 10 Freezing a Column
0:03:21
Lesson 11 Hiding a Column
0:04:30

Working with Tables and Fields

Length: 1:34:00

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.

Lesson 1 Understanding Field Properties
0:04:14
Lesson 2 Indexing a Field
0:05:05
Lesson 3 Adding a Primary Key to a Table
0:07:42
Lesson 4 Inserting, Deleting, and Reordering Fields
0:08:30
Lesson 5 Using Field Descriptions and Captions
0:10:16
Lesson 6 Changing the Field Size
0:08:35
Lesson 7 Formatting Number, Currency, and Date/Time Fields
0:09:28
Lesson 8 Formatting Number, Currency, and Date/Time Fields by Hand
0:14:31
Lesson 9 Formatting Text Fields
0:02:16
Lesson 10 Setting a Default Value
0:01:50
Lesson 11 Requiring Data Entry
0:04:04
Lesson 12 Validating Data
0:04:59
Lesson 13 Creating an Input Mask
0:02:56
Lesson 14 Creating a Lookup Field
0:03:18
Lesson 15 Creating a Value List
0:03:16
Lesson 16 Modifying a Lookup List
0:02:58

Creating Relational Databases

Length: 0:13:00

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.

Lesson 1 Understanding Table Relationships
0:01:15
Lesson 2 Creating Relationships between Tables
0:02:56
Lesson 3 Enforcing Referential Integrity
0:05:25
Lesson 4 Printing and Deleting Relationships
0:01:51
Lesson 5 Understanding Relationship Types
0:01:28

Working with Queries

Length: 1:02:00

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.

Lesson 1 Understanding the Different Types of Queries
0:00:35
Lesson 2 Creating a Multiple Table Query
0:06:12
Lesson 3 Creating a Calculated Field
0:02:01
Lesson 4 Working with Expressions and the Expression Builder
0:09:38
Lesson 5 Using an IIF Function
0:02:15
Lesson 6 Summarizing Groups of Records
0:03:07
Lesson 7 Displaying Top or Bottom Values
0:03:14
Lesson 8 Parameter Queries
0:04:08
Lesson 9 Finding Duplicate Records
0:03:48
Lesson 10 Finding Unmatched Records
0:02:57
Lesson 11 Crosstab Queries
0:04:15
Lesson 12 Delete Queries
0:04:05
Lesson 13 Append Queries
0:07:18
Lesson 14 Make-Table Queries
0:03:50
Lesson 15 Update Queries
0:04:43

Working with Forms

Length: 0:38:00

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.

Lesson 1 Creating and Using a Form
0:03:16
Lesson 2 Understanding Form Views
0:02:04
Lesson 3 Modifying a Form in Layout View
0:03:07
Lesson 4 Form Design View Basics
0:04:26
Lesson 5 Changing Tab Order
0:01:55
Lesson 6 Working with Control Properties
0:02:49
Lesson 7 Control Property Reference
0:01:03
Lesson 8 Working with Form Properties
0:03:07
Lesson 9 Changing a Control’s Data Source
0:00:59
Lesson 10 Form Property Reference
0:02:48
Lesson 11 Creating a Calculated Control
0:02:19
Lesson 12 Changing a Control’s Default Value
0:01:39
Lesson 13 Creating a Subform
0:03:39
Lesson 14 Modifying and Working with Subforms
0:04:00

Working with Reports

Length: 0:24:00

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.

Lesson 1 Creating a Report
0:01:38
Lesson 2 Working in Layout View
0:07:59
Lesson 3 Adding a Logo
0:00:48
Lesson 4 Working in Design View
0:01:37
Lesson 5 Adjusting Page Margins and Orientation
0:02:43
Lesson 6 Adding Page Numbers and Dates
0:02:01
Lesson 7 Grouping and Sorting
0:01:51
Lesson 8 Summarize Data using Totals
0:02:15
Lesson 9 Understanding Report Sections
0:02:29

Formatting Forms and Reports

Length: 0:08:05

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.

Lesson 1 Formatting Fonts
0:00:05
Lesson 2 Changing Text Alignment
0:01:03
Lesson 3 Changing Colors
0:00:06
Lesson 4 Applying Special Effects
0:01:13
Lesson 5 Using Conditional Formatting
0:02:04
Lesson 6 Adding Pictures, Lines and Gridlines
0:01:59
Lesson 7 Working with Number Formatting
0:00:23
Lesson 8 Using AutoFormat
0:01:12

Working with Macros

Length: 0:14:46

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.

Lesson 1 Creating and Running a Macro
0:00:15
Lesson 2 Editing a Macro
0:00:27
Lesson 3 Working with Macro Groups
0:00:06
Lesson 4 Assigning a Macro to an Event
0:02:20
Lesson 5 Creating Conditional Expressions
0:06:54
Lesson 6 Assigning a Macro to a Keystroke Combination
0:03:58
Lesson 7 Macro Action Reference
0:00:46

Advanced Topics

Length: 0:18:00

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.

Lesson 1 Importing Information
0:03:10
Lesson 2 Exporting Information
0:02:49
Lesson 3 Linking Information from an External Source
0:01:09
Lesson 4 Using Hyperlink Fields
0:04:23
Lesson 5 Displaying Database Object Dependencies
0:02:15
Lesson 6 Setting a Password in Access
0:01:51
Lesson 7 Compacting and Repairing a Database
0:02:05