United States Microsoft Access 2010 Tutorials
Online Contents For This Course
We have made some of the video tutorials for
Microsoft Access 2010
freely available to help you evaluate our training. Click on any of the linked lesson listings below to preview FREE!
Course Description
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!
Choose your media type:
|
Introduction
|
|||
| Welcome | (01:31) | T | |
| Course Objectives | (02:20) | T | |
| Course Structure | (03:20) | T | |
| What is Access? | (05:36) | T | |
| New in 2010 | (03:36) | T | |
|
Database Basics
|
|||
| What is a Database? | (03:24) | T | |
| Database Types | (03:22) | T | |
| Database Objects | (03:46) | T | |
| Tables | (04:07) | T | |
| Data Types | (03:55) | T | |
| Primary Key | (04:18) | T | |
| Indexes | (04:27) | T | |
|
Database Design Basics
|
|||
| What is Normalization? | (05:26) | T | |
| Normalization Benefits | (02:27) | T | |
| Understanding Relationships | (03:28) | T | |
| Relationship Types pt. 1 | (03:22) | T | |
| Relationship Types pt. 2 | (02:29) | T | |
| Relationship Types pt. 3 | (04:35) | T | |
| Understanding Integrity | (03:23) | T | |
|
Access 2010 Basics
|
|||
| What Can I Do with Access? | (04:59) | T | |
| Access Database Objects | (05:04) | T | |
| Opening Access 2010 | (04:35) | T | |
| Creating a Database | (03:34) | T | |
| Getting Around in Access | (06:15) | T | |
| Where to Really Start | (06:23) | T | |
|
Working with Tables
|
|||
| Creating Our Database | (03:48) | T | |
| Quick Access Toolbar Shortcut | (02:03) | T | |
| Datasheet or Design? | (03:44) | T | |
| Access Data Types | (03:25) | T | |
| Field Size Settings | (05:25) | T | |
| Date/Time Formats | (02:58) | T | |
| Custom Date/Time Formats | (04:32) | T | |
| Creating Our Tables | (05:57) | T | |
| Required Fields | (03:05) | T | |
| Deleting Rows | (01:37) | T | |
| Input Masks | (03:30) | T | |
| Setting the Field Size | (03:21) | T | |
| Default Values | (03:45) | T | |
| Allow Zero Length | (05:38) | T | |
| Renaming Fields & Tables | (03:42) | T | |
| Editing a Table | (05:15) | T | |
| Data Validation | (05:57) | T | |
| Adding an Index | (05:36) | T | |
| Deleting a Table | (03:22) | T | |
| Using Caption | (02:38) | T | |
| Using the Data Documenter | (05:32) | T | |
|
Relationships
|
|||
| Determining Relationships | (04:38) | T | |
| Creating a Relationship | (05:12) | T | |
| Relationship Options | (05:57) | T | |
| Relationship Reports | (02:58) | T | |
|
Working with Datasheet View
|
|||
| Using Auto Numbering | (04:50) | T | |
| Adding Data to the Table | (04:13) | T | |
| Using Data Lookups | (06:34) | T | |
| Datasheet View Basics | (05:28) | T | |
| Replacing Values | (04:04) | T | |
| Datasheet Formatting | (02:43) | T | |
| Filter By Form | (03:23) | T | |
| Freezing & Thawing | (02:27) | T | |
|
Accessing Your Data
|
|||
| Query Basics | (05:24) | T | |
| Access & SQL | (04:44) | T | |
| Access 2010 Query Types | (05:33) | T | |
| Using the Query Wizard | (04:28) | T | |
| Using the Query Design View | (05:03) | T | |
| Writing Queries in SQL | (05:09) | T | |
| Total Queries | (05:37) | T | |
| Make Table Queries | (05:18) | T | |
| Action Queries | (05:12) | T | |
| Crosstab Queries | (05:56) | T | |
| Union Queries | (04:48) | T | |
| Top Queries | (04:09) | T | |
| Multi-Table Queries | (06:40) | T | |
| Understanding Query Joins | (05:45) | T | |
| Distinct Queries | (03:20) | T | |
|
Data Forms
|
|||
| Access 2010 Forms | (03:21) | T | |
| Why Use Forms? | (03:59) | T | |
| Using AutoForm | (03:21) | T | |
| Using the Form Wizard | (04:32) | T | |
| Starting from Scratch | (06:44) | T | |
| Layout or Design View? | (05:07) | T | |
| Form Controls | (03:00) | T | |
| Adding Controls | (06:26) | T | |
| Using the Control Wizard | (06:30) | T | |
| Control Properties | (04:22) | T | |
| Using Combo Boxes pt. 1 | (05:48) | T | |
| Using Combo Boxes pt. 2 | (04:37) | T | |
| Navigation Form | (03:55) | T | |
| Setting the Tab Order | (03:34) | T | |
| Creating a Pop-up Form pt. 1 | (03:25) | T | |
| Creating a Pop-up Form pt. 2 | (04:20) | T | |
|
Access 2010 Reports
|
|||
| Report Basics | (05:04) | T | |
| Report Types | (03:11) | T | |
| Reports the Easy Way | (03:12) | T | |
| Reports the Wizard Way | (05:57) | T | |
| Reports the Real Way | (04:34) | T | |
| Finding the Data | (04:20) | T | |
| Basic Report Design | (04:35) | T | |
| Sorting & Grouping Data | (04:36) | T | |
| Report Headers | (05:15) | T | |
| Group & Sum Totals | (06:00) | T | |
| Using Expressions | (04:21) | T | |
| Report Cosmetics pt. 1 | (06:38) | T | |
| Report Cosmetics pt. 2 | (07:00) | T | |
| Report Cosmetics pt. 3 | (04:48) | T | |
|
External Data
|
|||
| You Need It Where? | (03:29) | T | |
| Exporting Data | (06:41) | T | |
| Importing Data | (06:14) | T | |
| Linking to Data | (04:52) | T | |
| Linking Issues | (04:19) | T | |
|
Multi-user Access Applications
|
|||
| Multi-User Application Basics | (04:37) | T | |
| Network Performance Issues | (04:04) | T | |
| Splitting the Database | (03:23) | T | |
| Pass-Through Queries | (03:51) | T | |
| Database Locking | (06:35) | T | |
|
More Cool Access Stuff
|
|||
| Copying Tables | (02:53) | T | |
| Access Analyzer Tools | (04:23) | T | |
| Database Backups | (01:29) | T | |
| Pivot Tables & Charts | (05:34) | T | |
| Intro to Macros & Events | (05:48) | T | |
| Intro to VBA | (06:22) | T | |
|
Conclusion
|
|||
| Course Wrap Up | (04:27) | T | |
|
Credits
|
|||
| About the Author | (01:59) | T | |
Email this Page 
Send us FeedbackCourse Information
| Course: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Duration: | 9 hrs / 121 tutorials |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
Search within Captions
Subscription / Purchase Information
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Sign up for a Free Trial
Full Access Members have full access to VTC.com's entire library of video tutorials.
If you are already a member, please login here.