Tutorials and Online Training Videos

Microsoft Access 2010 Tutorial


As part of the release of the Office 2010 software suite, Microsoft is introducing the latest version of Access, their entry-level database application software. Don't let the words 'entry-level' fool you, this is one very powerful database tool. Access was designed to collect, store, manage, report, and dissect data for individuals and small businesses. The release of the 2010 version continues to raise the bar of what an entry-level database product can do. In this course, Mark Long takes you from opening Access 2010 for the first time through the entire process of creating a database. He covers tables, queries, forms, reports, and many of the other bells and whistles that make up Access 2010. Click the movie links below to get started now!

Introduction

Welcome
Course Objectives
Course Structure
What is Access?
New in 2010

Database Basics

What is a Database?
Database Types
Database Objects
Tables
Data Types
Primary Key
Indexes

Database Design Basics

What is Normalization?
Normalization Benefits
Understanding Relationships
Relationship Types pt. 1
Relationship Types pt. 2
Relationship Types pt. 3
Understanding Integrity

Access 2010 Basics

What Can I Do with Access?
Access Database Objects
Opening Access 2010
Creating a Database
Getting Around in Access
Where to Really Start

Working with Tables

Creating Our Database
Quick Access Toolbar Shortcut
Datasheet or Design?
Access Data Types
Field Size Settings
Date/Time Formats
Custom Date/Time Formats
Creating Our Tables
Required Fields
Deleting Rows
Input Masks
Setting the Field Size
Default Values
Allow Zero Length
Renaming Fields & Tables
Editing a Table
Data Validation
Adding an Index
Deleting a Table
Using Caption
Using the Data Documenter

Relationships

Determining Relationships
Creating a Relationship
Relationship Options
Relationship Reports

Working with Datasheet View

Using Auto Numbering
Adding Data to the Table
Using Data Lookups
Datasheet View Basics
Replacing Values
Datasheet Formatting
Filter By Form
Freezing & Thawing

Accessing Your Data

Query Basics
Access & SQL
Access 2010 Query Types
Using the Query Wizard
Using the Query Design View
Writing Queries in SQL
Total Queries
Make Table Queries
Action Queries
Crosstab Queries
Union Queries
Top Queries
Multi-Table Queries
Understanding Query Joins
Distinct Queries

Data Forms

Access 2010 Forms
Why Use Forms?
Using AutoForm
Using the Form Wizard
Starting from Scratch
Layout or Design View?
Form Controls
Adding Controls
Using the Control Wizard
Control Properties
Using Combo Boxes pt. 1
Using Combo Boxes pt. 2
Navigation Form
Setting the Tab Order
Creating a Pop-up Form pt. 1
Creating a Pop-up Form pt. 2

Access 2010 Reports

Report Basics
Report Types
Reports the Easy Way
Reports the Wizard Way
Reports the Real Way
Finding the Data
Basic Report Design
Sorting & Grouping Data
Report Headers
Group & Sum Totals
Using Expressions
Report Cosmetics pt. 1
Report Cosmetics pt. 2
Report Cosmetics pt. 3

External Data

You Need It Where?
Exporting Data
Importing Data
Linking to Data
Linking Issues

Multi-user Access Applications

Multi-User Application Basics
Network Performance Issues
Splitting the Database
Pass-Through Queries
Database Locking

More Cool Access Stuff

Copying Tables
Access Analyzer Tools
Database Backups
Pivot Tables & Charts
Intro to Macros & Events
Intro to VBA

Conclusion

Course Wrap Up

Credits

About the Author


Related Books on Microsoft Access 2010







Save $80 on the
DROID BIONIC
by Motorola with Verizon Wireless service for less than from Verizon Wireless directly.
Save $80 on DROID BIONIC
More Cell Phone Discounts