More Customers and Case Studies

Customers Include: Microsoft Pepsi Verio GE Boeing Xerox EDS Chevron



At a Glance
  • Total Length 7 Hours and 10 Minutes
  • Level Beginner to Advanced
  • Instructor Deanna Reynolds

Access 2010 Training Highlights

  • Advanced Filter
  • Designing Select and Action Queries
  • Working with Form and Report Controls
  • Planning & Designing a Database
  • Assigning Cascading Updates and Cascading Deletes when enforcing referential integrity
  • Creating multi-valued fields
  • Preventing Data Entry Errors
  • Using Input Masks
  • Creating a Calculated Field
  • Highlighting form data with Conditional Formatting
  • Creating Groups and Total Reports
  • Create Single and Multiple Parameter Queries
  • Arranging Report Data Into Columns

Microsoft Access 2010 Training: Course Description

 

It’s Access…do we need to say more?

The possibilities are nearly limitless of how you can use Access at work. But, many aren’t brave enough to tackle this pretty powerful development tool. In our Microsoft Access 2010 training course, we’ve worked hard to take the fear out of database development to produce a course that even the most novice database user can progress through and walk away a developer. We hope that’s music to your ears. 

 

 
 

Of course, you can read the outline, but here’s what you’ll get…in a nutshell

 

Like many of our Microsoft Office training courses, Access 2010 Training consists of short, succinct, standalone topics – a favorite feature among many of our clients. This structure means you don’t have to wade through content that you already know. You can skip directly to the topics you want to learn about or start right from the beginning and watch the entire Access 2010 Training course from beginning to end. Although, we do recommend to take at least one break to grab some food.

 

Access 2010 Training topics include:

  • Build & modify forms and reports
  • Building & modifying tables
  • Design Select and Action Queries
  • Export your Access data to Word and Excel
  • Planning & Designing a Database including an overview of the database design process
  • Prevent data entry errors using features like the lookup fields, data validation, conditional formatting and combo boxes
  • Sort and Filter tables and forms
  • Understand primary keys, foreign keys and table relationships
  • Work with Common Filters, Filter by Form, Filter by Selection and Advanced Filters
  • Work with Parameter queries to pull different data sets every time you run a report

Are you still reading? Good. Because, we have something important to talk about.

Our Microsoft Access 2010 Training course is best enhanced when viewed with our fresh learning platform that merges the best Learning Management Systems (LMS) and knowledgebase features into a slick enterprise-wide Software as a Service (SaaS) application. 

What does that mean for you?
 
* Online, 24/7 access to full Microsoft Access 2010 Training course content that is also available as searchable, bite-sized training articles and videos that can be quickly found when needed through a handy, quick search feature.  (Training you need, when you need it)
 
* Customized Microsoft Access 2010 Training for all levels of Office users that starts with topic introduction, continues through real-world exercises to practice what you learned and wraps up with a quiz to test your recall.  (Start where you want, practice what you see, prove your new skills)
 
* With almost 200 topics to choose from and over 7 hours of recorded Access 2010 Training lessons, we're pretty confident that you'll learn something new, and if not, call us; we may have a teaching job for you.  (Every Microsoft Access 2010 Training video has a matching article)
 

KeyStone OnDemand Interface

Access 2010 Training at a Glance:

Total Length: Over 7 hours

Level: Beginner to Advanced

You Need 24X7 Access 2010 Training Support for common day-to-day questionsConnecting the Pieces

  • An easy way to support Access users
  • Proactively cut costs with reduced support
  • Easily customize training for local needs

You're in the Right Place

  • Find what you need instantly by keyword
  • Beginner to Advanced topics in Video & Text
  • Interactive training includes Excercises & Quizzes

And We Know Enterprise

Whether you are suppporting a local migration or managing a global roll out, KeyStone provides complete end-to-end support!

Business Features include:

  • Migration and Roll out support packages
  • Pre and Post Assessments
  • Robust Learning and Content Management
  • Built in Helpdesk Integration
  • 24x7 Access with no hidden costs
  • Unlimited Tier 1 support for licensed users
  • Globalization & awareness campaigns including Webinars, Posters, Quick Reference Cards
  • Customize and create your own content for rapid deployment

 



Includes Learning and Content Management, Certificates of Completion, and a complete library of courses.

 


 

 

     

The Complete Microsoft Access 2010 Training Solution (because you need a plan)

We think this Microsoft Office Access 2010 training course is great, and we believe you’ll think so, too.  We could go on and on about the benefits of training and how it positively impacts user productivity ultimately resulting in a net gain of getting more done in a shorter amount of time. But, you already know all of that. 

What you don't know is what makes us different.

 

KeyStone Learning Systems offers comprehensive solutions for enterprise clients. What does that mean? If you’re a company looking for high quality Microsoft Office Access 2010 end-user training you can track and assign with the ability to customize the off-the-shelf content, we can help.

The next you get a request for Access 2010 training, you can open your web browser, assign a user to the Access 2010 Training course and they have access... immediately. Our system tracks your users, what courses they've taken and sends that usage data right back to you.

Did we mention there's no software to buy or install? The news just keeps getting better. Does your organization have Internet access? Silly question, we know. But, if you have that, you can have KeyStone OnDemand.

Basically, you license it and we stream it.

That's 24/7 access for you and your company with no hidden IT, support or other technology costs that we all know tend to add up pretty quickly. We think it's revolutionary, but we wouldnít mind hearing your opinion.

Did we mention?

  • Our trainers are MCTs with a passion for training that you'll feel from the first video
  • We offer unlimited Tier 1 support via email for licensed users
  • We provide complete training, migration and roll out support packages including Quick Reference Cards, Webinars, Posters, Pre and Post Assessments, Custom Introduction Videos (from your Management team), Awareness Campaigns, and Helpdesk Support Features.
  • Your company could be up and running with our training within 2-4 business hours (there are some time zone requirements here, but you get the idea)
  • You can add your own training content to our existing, and fabulous, off-the-shelf training

Key Learning Objectives for Microsoft Access 2010 Training: 

This is such a big course, even bigger when you get it with the rest of the Microsoft Office 2010 training course, we can't possibly list all of the learning objectives here. For that, check out the outline. But, here are some things that we think are pretty cool.
  • Understand the database design process to create and build your own Access database
  • Streamline data entry processes using quick data entry techniques and development features like lookup fields, combo boxes, data validation and conditional formatting
  • Extract information from a database using custom filters and enhanced select queries
  • Make large scale database edits using action queries
  • Create user-friendly forms and reports
  • Build databases that adhere to development guidelines with proper relationship assignments
  • Document your database structure
At a Glance
  • Total Length 7 Hours and 10 Minutes
  • Level Beginner to Advanced
  • Instructor Deanna Reynolds

 

Microsoft Office Access 2010 Training Outline

 

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

Microsoft Access 2010 Training Course Instructor

Instructor Photo

Deanna Reynolds

MCTS, Technical Trainer, Published Author

Deanna is an author and technical instructor residing in Bellingham, Washington. For close to 20 years, Deanna has trained students in all arenas, specializing in delivering enterprise training. Throughout her career, Deanna has led hundreds of computer productivity training sessions, from beginner through advanced levels.  These days, Deanna’s technical training has extended beyond the classroom to include more than 20 courses for KeyStone Learning Systems and three published books: Excel 2010: No Problem! (Wiley), Word 2007 Pocket Book (Prentice Hall), and Managing Projects with Microsoft Office Project 2007 (Microsoft Press).

In the Microsoft Access 2010 Training course, Deanna will guide users of all levels to better database productivity through a complete understanding of Access 2010.

Some Quick Microsoft Access 2010 Training Tips

Access 2010 TRAINING TIP:  Rename a table

The easiest way to rename a table, or any database object, is through the context menu. From the Navigation pane, right-click the table you want to rename.

From the context menu, choose Rename. You won’t get a fancy dialog, but rather the table name in the Navigation Pane will be displayed in edit mode. However, if you have the table open, you won’t be able to rename it. The object must be closed before renaming.

Once in this mode, type the new table name and press Enter to accept the changes.  (Microsoft Access 2010 Training Tips: © KeyStone Learning Systems)

 

ACCESS 2010 TRAINING TIP:  Enter the current date

Another quick data entry technique is plugging in the current date by pressing CTRL+; on your keyboard. When you use this key combination, the current date is added to the active field and formatted based on that’s field’s set properties. (Microsoft Access 2010 Training Tips: © KeyStone Learning Systems)

 

ACCESS 2010 TRAINING TIP:  Copy the value in the row above

This is a quick topic that will save you quite a bit of data entry time. When you are entering data in a table, to copy the contents of the field directly above your current position, press CTRL+’ on the keyboard.

Go try it and then come back for more training. (Microsoft Access 2010 Training Tips: © KeyStone Learning Systems)

 

ACCESS 2010 TRAINING TIP:  Force all text to upper or lower case

One of the more interesting table properties for fields with the Text data type assigned is Format. With the addition of just one character, you can force all entered information in a chosen field to either all uppercase or all lowercase text.

The greater than (>) symbol forces all characters to uppercase while the less than (<) symbol forces all characters to lowercase.

Just enter that symbol, save your table and then test the field. (Microsoft Access 2010 Training Tips: © KeyStone Learning Systems)

 

ACCESS 2010 TRAINING TIP:  show or hide the date picker in the date/time field

By default, when you assign the Date/Time data type to a field, the display of the date picker next to that field during data entry is enabled.

Although it’s handy for data entry, it is sometimes unnecessary. In those instances, you can remove its display from the table’s Design view in the field properties.

This way, the field will still store dates, but you won’t have access to the date picker specific to that field. (Microsoft Access 2010 Training Tips: © KeyStone Learning Systems)

 

 

Other Resouces on the Web

LinkedIn's Microsoft Learning Professionals Group
This is a group for Microsoft learning and training professionals, including desktop support managers, project managers, instructional designers, learning officers and classroom trainers.

 

 

 

 

Purchase

Single User

365 Day Single User Licenses

Multi-User

Please call us at 1-866-245-5224 for special multi-user and enterprise license pricing options.

At a Glance
  • Total Length 7 Hours and 10 Minutes
  • Level Beginner to Advanced
  • Instructor Deanna Reynolds