United States Microsoft Access 2010 Training
CD Contents For This Title
All the chapters and lesson contents of Microsoft Access 2010 are listed below.
To help you evaluate our training, we have made some of the tutorials for Microsoft Access 2010 freely available. Click on any of the linked lesson listings below to preview FREE!
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:
To view the Free Tutorials listed below, you must have QuickTime installed. Please note that the online free samples have been compressed for quicker downloads. Purchased CDs have higher sound and video quality.Monitor resolution needs to be set to at least 1024 by 768 to view the entire movie.
Hide This|
Introduction
|
||
| Welcome | (01:31) | |
| Course Objectives | (02:20) | |
| Course Structure | (03:20) | |
| What is Access? | (05:36) | |
| New in 2010 | (03:36) | |
|
Database Basics
|
||
| What is a Database? | (03:24) | |
| Database Types | (03:22) | |
| Database Objects | (03:46) | |
| Tables | (04:07) | |
| Data Types | (03:55) | |
| Primary Key | (04:18) | |
| Indexes | (04:27) | |
|
Database Design Basics
|
||
| What is Normalization? | (05:26) | |
| Normalization Benefits | (02:27) | |
| Understanding Relationships | (03:28) | |
| Relationship Types pt. 1 | (03:22) | |
| Relationship Types pt. 2 | (02:29) | |
| Relationship Types pt. 3 | (04:35) | |
| Understanding Integrity | (03:23) | |
|
Access 2010 Basics
|
||
| What Can I Do with Access? | (04:59) | |
| Access Database Objects | (05:04) | |
| Opening Access 2010 | (04:35) | |
| Creating a Database | (03:34) | |
| Getting Around in Access | (06:15) | |
| Where to Really Start | (06:23) | |
|
Working with Tables
|
||
| Creating Our Database | (03:48) | |
| Quick Access Toolbar Shortcut | (02:03) | |
| Datasheet or Design? | (03:44) | |
| Access Data Types | (03:25) | |
| Field Size Settings | (05:25) | |
| Date/Time Formats | (02:58) | |
| Custom Date/Time Formats | (04:32) | |
| Creating Our Tables | (05:57) | |
| Required Fields | (03:05) | |
| Deleting Rows | (01:37) | |
| Input Masks | (03:30) | |
| Setting the Field Size | (03:21) | |
| Default Values | (03:45) | |
| Allow Zero Length | (05:38) | |
| Renaming Fields & Tables | (03:42) | |
| Editing a Table | (05:15) | |
| Data Validation | (05:57) | |
| Adding an Index | (05:36) | |
| Deleting a Table | (03:22) | |
| Using Caption | (02:38) | |
| Using the Data Documenter | (05:32) | |
|
Relationships
|
||
| Determining Relationships | (04:38) | |
| Creating a Relationship | (05:12) | |
| Relationship Options | (05:57) | |
| Relationship Reports | (02:58) | |
|
Working with Datasheet View
|
||
| Using Auto Numbering | (04:50) | |
| Adding Data to the Table | (04:13) | |
| Using Data Lookups | (06:34) | |
| Datasheet View Basics | (05:28) | |
| Replacing Values | (04:04) | |
| Datasheet Formatting | (02:43) | |
| Filter By Form | (03:23) | |
| Freezing & Thawing | (02:27) | |
|
Accessing Your Data
|
||
| Query Basics | (05:24) | |
| Access & SQL | (04:44) | |
| Access 2010 Query Types | (05:33) | |
| Using the Query Wizard | (04:28) | |
| Using the Query Design View | (05:03) | |
| Writing Queries in SQL | (05:09) | |
| Total Queries | (05:37) | |
| Make Table Queries | (05:18) | |
| Action Queries | (05:12) | |
| Crosstab Queries | (05:56) | |
| Union Queries | (04:48) | |
| Top Queries | (04:09) | |
| Multi-Table Queries | (06:40) | |
| Understanding Query Joins | (05:45) | |
| Distinct Queries | (03:20) | |
|
Data Forms
|
||
| Access 2010 Forms | (03:21) | |
| Why Use Forms? | (03:59) | |
| Using AutoForm | (03:21) | |
| Using the Form Wizard | (04:32) | |
| Starting from Scratch | (06:44) | |
| Layout or Design View? | (05:07) | |
| Form Controls | (03:00) | |
| Adding Controls | (06:26) | |
| Using the Control Wizard | (06:30) | |
| Control Properties | (04:22) | |
| Using Combo Boxes pt. 1 | (05:48) | |
| Using Combo Boxes pt. 2 | (04:37) | |
| Navigation Form | (03:55) | |
| Setting the Tab Order | (03:34) | |
| Creating a Pop-up Form pt. 1 | (03:25) | |
| Creating a Pop-up Form pt. 2 | (04:20) | |
|
Access 2010 Reports
|
||
| Report Basics | (05:04) | |
| Report Types | (03:11) | |
| Reports the Easy Way | (03:12) | |
| Reports the Wizard Way | (05:57) | |
| Reports the Real Way | (04:34) | |
| Finding the Data | (04:20) | |
| Basic Report Design | (04:35) | |
| Sorting & Grouping Data | (04:36) | |
| Report Headers | (05:15) | |
| Group & Sum Totals | (06:00) | |
| Using Expressions | (04:21) | |
| Report Cosmetics pt. 1 | (06:38) | |
| Report Cosmetics pt. 2 | (07:00) | |
| Report Cosmetics pt. 3 | (04:48) | |
|
External Data
|
||
| You Need It Where? | (03:29) | |
| Exporting Data | (06:41) | |
| Importing Data | (06:14) | |
| Linking to Data | (04:52) | |
| Linking Issues | (04:19) | |
|
Multi-user Access Applications
|
||
| Multi-User Application Basics | (04:37) | |
| Network Performance Issues | (04:04) | |
| Splitting the Database | (03:23) | |
| Pass-Through Queries | (03:51) | |
| Database Locking | (06:35) | |
|
More Cool Access Stuff
|
||
| Copying Tables | (02:53) | |
| Access Analyzer Tools | (04:23) | |
| Database Backups | (01:29) | |
| Pivot Tables & Charts | (05:34) | |
| Intro to Macros & Events | (05:48) | |
| Intro to VBA | (06:22) | |
|
Conclusion
|
||
| Course Wrap Up | (04:27) | |
|
Credits
|
||
| About the Author | (01:59) | |
Email this Page
Send us FeedbackTitle Information / Pricing
| Title: | Microsoft Access 2010 |
| Author: | Mark Long |
| SKU: | 34224 |
| ISBN: | 1-936334-91-7 |
| Release Date: | 2011-05-12 |
| Price: | |
| Duration: | 9 hrs / 121 lessons |
| Work Files: |
Yes |
| Captions: | Available on CD and Online University |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7 |
Online University Access all our Training for only 30
The Online University provides unlimited 24/7 access to ALL of VTC's incredible training content for the low fixed price of just $30/month (USD)
SIGNUP NOW
LEARN MORE » Related Titles
Select Bandwidth
Now Shipping
Client Testimonials
As a Principal in Public Education for the last 40 years, I have learned that competency, people skills and commitment are virtues that are...
Vincent C