Access 2010 Essential Training

Gives a comprehensive overview of creating databases in Access, whether using predefined database templates or building from scratch.

In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.

Introduction

• Welcome
• Using the exercise files

1. Access Basics

• Database concepts and terminology
• Starting Access
• Creating a new file
• Trusting a file
• The Quick Access toolbar
• Backstage view
• Exploring ribbons
• Using the Navigation pane
• Getting help

2. Creating a First Database and Using the Tools

• Planning and designing your database
• Creating tables using Application Parts
• Creating tables in Layout view with Quick Start
• Creating and editing tables in Design view
• Setting a primary key
• Creating a lookup field
• Creating multi-value fields
• Using calculated fields

3. Setting Up the Data

• Setting field properties
• Setting input masks
• Setting validation rules

4. Building Structure

• Creating relationships and enforcing referential integrity
• Viewing subdatasheets

5. Formatting and Appearance

• Entering data into your tables
• Formatting tables
• Finding, sorting, and filtering records

6. Forms

• Creating data-entry forms
• Using the Form Wizard
• Modifying a form in Layout view
• Using Design view
• Setting tab stops
• Adding buttons to a form
• Using navigation forms

7. Queries

• Introduction to queries
• Using the Query Wizard
• Creating a query in Design view with criteria
• Creating wildcard queries
• Creating reusable parameter queries
• Creating yes/no queries
• Creating "and" and "or" queries
• Building calculation queries
• Creating statistical queries
• Using update queries
• Using delete queries
• Creating crosstab queries

8. Reports

• Introduction to reports
• Using the Report Wizard
• Formatting reports in Layout view
• Identifying report structure in Design view
• Adding group and sort capabilities to a report
• Adding existing fields from other tables
• Adding totals and subtotals to a report
• Adding conditional formatting and data bars to a report
• Creating multi-table reports
• Creating mailing labels
• Printing reports

9. Putting Data to Work

• PivotTables
• PivotCharts

10. Automating with Macros

• Creating macros
• Attaching macros to objects
• Using data macros

11. Using Other Applications with Access

• Importing Excel and text data
• Exporting data into Excel
• Exporting to PDF
• Exporting into a Word Mail Merge
• Publishing to a web browser in HTML or XML
• Sharing via email
• Collecting data over email
• Using Package and Sign
• Publishing to SharePoint
• Importing and exporting with SharePoint

12. Advanced Tools in the Database

• Compacting and repairing a database
• Using data analysis tools
• Encrypting a database and setting a password
• Splitting a database

13. Customization

• Customizing the ribbons
• Setting Access options

Conclusion

• Goodbye