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!

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