Login 
Password
  
 


Free Exams!
Test your skills with one of our certification exams and see how you stack up right now.

Homepage
Visit our homepage and find out more about what NCSA can do for you.

Learn More About Us
Find out more about how our certifications can benefit you.

Course Descriptions
View a complete listing of certifications available through NCSA.

Microsoft Office 2003
Office 2007
Office 2010
Windows Vista
Windows 7
Visio 2003 & 2007
OneNote 2003 & 2007
Project 2007
SharePoint 3.0 User
Access 2007
Excel 2007
Outlook 2007
PowerPoint 2007
Word 2007
Office For Mac 2008
Acrobat 8 Pro
ADO .NET 2.0
Crystal Reports XI
Flash 8

HTML Tag Library
Visit our HTML tag library, a free reference we provide to our visitors.

Certificate Database
Lookup a certification in our online database.

Affiliate Program
Make money by helping people get the computer training and certification they need. Sign-up Here!

Support Center
If you have questions or concerns feel free to visit our online support center.


 

Order NCSA OnDemand today and get access to over 7500 quality instuctor led videos and training courses covering today's most popular software programs and programming languages including:

          many more!

PlanComparison

Customers Include:

  • Texas Education Foundation
  • Job Corps
  • Piggly Wiggly
  • Texas A&M Corpus Christi
  • Airsplat
  • Asian College of Technology
  • INOVA Federal Credit Union
  • Capital Area Career Center
  • Las Positas College
  • Many More!

Microsoft Access 2010 Training


Course Highlights

  • Use pre-built tables to start tracking your information immediately.
  • Create select and action queries to seamlessly view and change your data.
  • Create multiple reports and save audience-specific views.
  • Take advantage of the Ribbon and interactive Access interface to quickly build a database.

About This Course

This Microsoft Office Access 2010 Essentials Course will lead you through the improved interface and interactive design capabilities of Access 2010. With quick tips and detailed instructions, you will learn how to track and report information with ease.

Access 2010 comes loaded with pre-built elements such as tables and field names. In this course, you will learn how to take advantage of those elements as well as how to import data from external applications, share your database information, and much more.

This Microsoft Office Access 2010 Essentials Training Course contains four levels of instruction designed to walk you through the database design process and how to use Access to develop detailed databases. You will learn how to work in-depth with many of the Access objects including Tables, Forms, Queries and Reports.

There are over 100 lessons in this Access course – all designed to increase your productivity.

Microsoft Access 2010 Training: Level 1

(Build a Strong Database Foundation with Microsoft Access 2010)
  • 1. The Access 2010 Interface & File Types
  • 1.1. Create a New Database Based on a Template 010101
  • 1.2. Create a New Database Using Templates Available at Office.com
  • 1.3. Experience the New Access 2010 Interface
  • 1.4. Go Backstage via the File Tab
  • 1.5. Customize the Quick Access Toolbar
  • 1.6. Customize the Ribbon
  • 1.7. Access File Types and What They Mean to You
  • 1.8. Need Help? It’s Local & Online

  • 2. Understanding Key Database Development Concepts
  • 2.1. About Relational Databases like Access 2010
  • 2.2. Understand Database Objects
  • 2.3. Use the Navigation Pane
  • 2.4. Database Design Process
  • 2.5. Work with Just One Database at a Time

  • 3. Build the Foundation of a Database
  • 3.1. The Role Tables Play in a Database
  • 3.2. Create a Table Using Application Parts
  • 3.3. Create a Table in Datasheet View
  • 3.4. Create a Table Based on a SharePoint List
  • 3.5. About Field Data Types
  • 3.6. Create a Multivalued Field
  • 3.7. Rename a Table
  • 3.8. Set the Maximum Allowable Characters for a Field
  • 3.9. Assign a Field’s Default Value

  • 4. Define Links Between Your Tables with Relationships
  • 4.1. The Role of Primary Keys in a Database
  • 4.2. Set or Clear a Database Primary Key
  • 4.3. About Table Relationships
  • 4.4. Add a Table to the Relationship Window
  • 4.5. Create a Relationship Between Two Tables
  • 4.6. When to Enforce Referential Integrity
  • 4.7. Use Cascade Update and Cascade Delete to Manage Your Data
  • 4.8. Send the Relationships Report to the Printer
  • 4.9. Save the Relationships Report Outside of Access

  • 5. Get Your Data Into an Access Table
  • 5.1. Use Datasheet View for Data Entry Tasks
  • 5.2. Add or Delete a Record in a Table
  • 5.3. Use Find and Replace
  • 5.4. Undo and Redo
  • 5.5. Copy the Value in the Row Above
  • 5.6. Enter the Current Date
  • 5.7. Import an Excel Spreadsheet Into Access
  • 5.8. Populate an Access Table Based on Email Messages

  • 6. Advanced Table Design
  • 6.1. Create a Table in Design View
  • 6.2. Customize a Field’s Properties in Design View
  • 6.3. Use the Property Sheet Task Pane for Tables
  • 6.4. Use Input Masks to Control the Format of Entered Data
  • 6.5. Force All Text to Upper or Lower Case
  • 6.6. Add a Datasheet Total Row
  • 6.7. Use Rich Text in the Memo Field
  • 6.8. Show or Hide the Date Picker in the Date/Time Field

  • 7. Techniques to Help Avoid Data Entry Errors
  • 7.1. About Data Validation
  • 7.2. Assign Data Validation Parameters to a Field
  • 7.3. Customize the Data Validation Message Box
  • 7.4. How Lookup Fields Can Help Prevent Data Entry Errors
  • 7.5. Create a Lookup Field
  • 7.6. How to Switch a Lookup Field Back to a Text Field

  • 8. Microsoft Access 2010 Training: Level 1 Resources
  • 8.1. Access 2010 Level 1 Exercises
  • 8.2. Access 2010 Level 1 Sample Files
  • 8.3. Access 2010 Level 1 Knowledge Checks
  • 8.4. Access 2010 Level 1 Training KeyNotes

Microsoft Access 2010 Training: Level 2

(Display and Extract Specific Data in Your Tables with Access 2010)
  • 1. Some Table Options You May Not Have Seen, Yet
  • 1.1. Insert a Record Based on an Outlook Contact
  • 1.2. Adjust the Height of a Row in Datasheet View
  • 1.3. Adjust the Width of a Field in Datasheet View
  • 1.4. Hide or Unhide a Field in Datasheet View
  • 1.5. Freeze a Field in Datasheet View for Easier Scrolling
  • 1.6. Text Formatting Options in Datasheet View
  • 1.7. Print Options for Tables

  • 2. Filtering
  • 2.1. About Filters
  • 2.2. Common Filters
  • 2.3. Filter by Selection
  • 2.4. Filter by Form
  • 2.5. Advanced Filters

  • 3. Create Select Queries
  • 3.1. The Difference Between a Filter and a Query
  • 3.2. Select Queries: Explained
  • 3.3. Create a Simple Query Using the Wizard
  • 3.4. Create a New Query Using Design View
  • 3.5. Add a Table to a Query
  • 3.6. Use Criteria to Pull Matching Records in a Query
  • 3.7. Sort Fields in a Query
  • 3.8. Show or Hide Fields in a Query
  • 3.9. Run a Query

  • 4. Create Action Queries
  • 4.1. The Difference Between an Action Query and a Select Query
  • 4.2. Action Queries: Explained
  • 4.3. Types of Action Queries
  • 4.4. Create a Query that Updates Records
  • 4.5. Create a Query that Deletes Specified Records
  • 4.6. Create a Query that Appends Records from One Table to the Bottom of Another Table
  • 4.7. Create a Query that Makes a New Table

  • 5. Work with Queries
  • 5.1. Create a Calculated Field in a Query
  • 5.2. Create a Crosstab Query
  • 5.3. Create a Query that Finds Duplicate Values
  • 5.4. Create a Query that Finds Unmatched Values
  • 5.5. Create a Query that Prompts for Single Criteria Each Time it is Run
  • 5.6. Create a Query that Prompts for Multiple Criteria Each Time it is Run
  • 5.7. How Joins Can Impact Your Queries
  • 5.8. Return the Top Values in a Query
  • 5.9. Print Options for Queries

  • 6. Send Your Access Information to Other Programs
  • 6.1. Send an Access Table to Excel
  • 6.2. Send an Access Table to a Text File
  • 6.3. Send an Access Table to PDF
  • 6.4. Send an Access Table to a Word Document
  • 6.5. Email an Access Table
  • 6.6. Using Saved Exports

  • 7. Microsoft Access 2010 Training: Level 2 Resources
  • 7.1. Access 2010 Level 2 Exercises
  • 7.2. Access 2010 Level 2 Sample Files
  • 7.3. Access 2010 Level 2 Knowledge Checks
  • 7.4. Access 2010 Level 2 Training KeyNotes

Microsoft Access 2010 Training: Level 3

(Display Your Data in Access with Forms and Reports with Access 2010)
  • 1. Create a Form in Access
  • 1.1. Create a Form in Just One Click
  • 1.2. Create a Form Using Application Parts
  • 1.3. Create a Form Using the Wizard
  • 1.4. Start a Form from a Blank Slate
  • 1.5. Create a Form in Design View
  • 1.6. Understand Form Sections
  • 1.7. Set Form Section Properties
  • 1.8. Use Form Layout View

  • 2. Create a Report in Access
  • 2.1. Create a Report in Just One Click
  • 2.2. Create a Report Using the Wizard
  • 2.3. Start a Report from a Blank Slate
  • 2.4. Create a Report in Design View
  • 2.5. Understand Report Sections
  • 2.6. Set Report Section Properties
  • 2.7. Use Report Layout View

  • 3. Advanced Form & Report Design
  • 3.1. Add Controls to Your Form or Report
  • 3.2. Use the Property Sheet Task Pane for Forms and Reports
  • 3.3. Add the Date and Time to a Form or a Report
  • 3.4. Add a Title to a Form or Report
  • 3.5. Change a Form’s Tab Order
  • 3.6. Create a Lookup Field on a Form
  • 3.7. Add a Calculated Control to a Form or Report
  • 3.8. Create a Conditional Formatting Rule for a Calculated Field

  • 4. Arrange and Edit Form and Report Controls
  • 4.1. Switch a Form or Report Layout Between Stacked and Tabular
  • 4.2. Work with Gridlines in a Form or Report
  • 4.3. Insert Rows and Columns on a Form or Report
  • 4.4. Split a Field Vertically or Horizontally to Reduce its Size
  • 4.5. Move a Field Up or Down on a Form or Report
  • 4.6. Set the Space Between Fields on a Form or Report
  • 4.7. Work with Form and Report Margins

  • 5. Some Form Options You May Not Have Seen, Yet
  • 5.1. Add a Command Button to a Form
  • 5.2. Create a Split Form
  • 5.3. Add Tabs to a Form
  • 5.4. Form Print Options

  • 6. Some Report Options You May Not Have Seen, Yet
  • 6.1. Report Print Options
  • 6.2. Arrange Report Data Into Columns
  • 6.3. Work with Total Fields
  • 6.4. Create a Grouped or Sorted Report
  • 6.5. Edit Report Group Settings

  • 7. Work with Themes and Graphics on a Form or Report
  • 7.1. About Office 2010 Themes
  • 7.2. Change a Theme’s Color, Font & Effects
  • 7.3. Create & Save a Custom Theme
  • 7.4. Add a Logo to a Form or Report
  • 7.5. Format Form and Report Labels

  • 8. Microsoft Access 2010 Training: Level 3 Resources
  • 8.1. Access 2010 Level 3 Exercises
  • 8.2. Access 2010 Level 3 Sample Files
  • 8.3. Access 2010 Level 3 Knowledge Checks
  • 8.4. Access 2010 Level 3 Training KeyNotes

Microsoft Access 2010 Training: Level 4

(Bonus Techniques for the Advanced Access 2010 User)
  • 1. Database Management
  • 1.1. Copy a Table
  • 1.2. About Database Security
  • 1.3. Use a Database Password
  • 1.4. Identify Object Dependencies
  • 1.5. Run the Database Documenter
  • 1.6. Analyze a Table
  • 1.7. Analyze Database Performance
  • 1.8. Compact and Repair a Database

  • 2. Work with Macro Objects
  • 2.1. About Macros
  • 2.2. Use the Action Catalog to Record a Macro
  • 2.3. Create a Custom Macro
  • 2.4. Rename or Delete a Macro
  • 2.5. Edit a Macro
  • 2.6. Create a Data Macro from a Table
  • 2.7. Attach a Macro to a Command Button

  • 3. Work with PivotTables in Access
  • 3.1. About PivotTables & PivotCharts
  • 3.2. Create a PivotTable in Access
  • 3.3. Edit a PivotTable’s Field Settings in Access
  • 3.4. Control a PivotTable’s Data Calculations in Access
  • 3.5. Sort a PivotTable in Access
  • 3.6. Show the Top Values in a PivotTable in Access
  • 3.7. Export a PivotTable Created in Access to Excel
  • 3.8. Create a PivotChart in Access
  • 3.9. Change the PivotChart Type in Access

  • 4. Microsoft Access 2010 Training: Level 4 Resources
  • 4.1. Access 2010 Level 4 Exercises
  • 4.2. Access 2010 Level 4 Sample Files
  • 4.3. Access 2010 Level 4 Knowledge Checks
  • 4.4. Access 2010 Level 4 Training KeyNotes



 



Web-based Training Courses, including 7,500+ Videos & Articles, covering:

Microsoft Office
2010 | 2007
Microsoft Windows
7 | Vista
Visio
2003 / 2007
OneNote
2003 / 2007
Project
2003 | 2007
Sharepoint
3.0
Access
2010 | 2007
Excel
2010 | 2007
Outlook
2010 | 2007
PowerPoint
2010 | 2007
Word
2010 | 2007
Office for Mac
2008
Excel for Mac
2008
Entourage for Mac
2008
PowerPoint for Mac
2008
Word for Mac
2008

Acrobat 8 Professional ADO.NET 2.0 ASP.NET 2.0 for Visual Basic 2005
C# 2005 Crystal Reports XI Exchange Server 2003
Flash 8 ActionScripting Flash 8 for Designer FrontPage 2003
Mind Manager 7 Pro + Project 2007 Mind Manager 7 Pro Fundamentals Office 2007 - What's New
Photoshop CS2 PHP Programming QuickBooks Pro 2006
SharePoint End User: Administrator SharePoint End User: Contributor SharePoint End User: Reader
Small Business Server 2003 SQL Server 2005 Visual Basic 2005
Windows Server 2003


Typing Speed Test
Test your typing speed with our certified typing speed test today.



  
HOME      EMPLOYERS    TESTING CENTERS    CERTIFICATION LIST    INSURANCE QUOTES    AFFILIATES    CONTACT US

© 2002-2011 National Computer Science Academy, All Rights Reserved.