Introduction This training provides you with the
skills and knowledge required to create, customize, use, and share Access 2010
databases. · Database Basics · Creating a Database · Defining a Primary Key · Creating Datasheet Relationships · Creating a Complex Query · Using Lookup Fields · Creating and Editing a Query in SQL View · Creating a Report · Creating Pivot Objects · Creating and Editing a Macro · Handling Errors in a Macro · Creating and Editing a Module · Packaging a Database · Sharing a Database
Program Module 1: Course 10382: Beginner Skills in Microsoft Access 2010 Students will be able to: o Create and edit a database. o Create and use a query. o Create and edit a report. o Create and edit a form.
Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Lab Information Lab Information Beginner Skills in Access 2010 Module Overview Creating and Editing a Database Introduction Exploring the Access 2010 Interface Database Basics Reviewing Access 2010 Fundamentals Creating a Database Viewing a Database Importing and Exporting Data Editing and Formatting Table Data Creating and Managing Indexes Creating an Events Database Self Test Creating and Using a Query Introduction Creating a Query by Using Query Wizard Creating an Expression by Using Expression Builder Creating a Criteria-Based Query Performing Calculations by Using a Query Creating a Query Self Test Working with a Report Introduction Creating a Report Creating a Label Grouping and Sorting Data in a Report Performing Calculations in a Report Creating and Editing a Report Self Test Creating and Editing a Form Introduction Creating a Form by Using Form Wizard Creating a Form by Using the Form Tool Editing a Form in Design View Creating a Form Self Test Module Summary Module Summary Glossary Glossary
Module 2: Course 10383: Intermediate Skills in Microsoft Access 2010 Students will be able to: o Modify a database o Create complex queries to extract and process specific information Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Lab Information Lab Information Intermediate Skills in Access 2010 Module Overview Modifying a Database Introduction Creating a Table Modifying a Table Defining a Primary Key Reviewing Table Fundamentals Creating Datasheet Relationships Validating Data in a Table Using Lookup Fields Creating a Default Database Template Compacting a Database Editing a Database Self Test Working with Complex Queries Introduction Creating a Complex Query Creating a Totals Query Creating and Editing a Query in SQL View Creating Pivot Objects Creating and Editing Complex Queries Self Test Module Summary Module Summary Glossary Glossary
Module 3: Course 10384: Advanced Skills in Microsoft Access 2010 Students will be able to: o Create programmed elements to automate tasks and add functionality to database objects and controls. o Share and distribute database information. Lessons Course Overview Module Overview Navigation Overview Navigation Overview Course Information Course Information Lab Information Lab Information Advanced Skills in Access 2010 Module Overview Creating Programmed Elements Introduction Exploring the Macro Environment Creating and Editing a Macro Creating an Embedded Macro Handling Errors in a Macro Creating and Editing a Module Creating a Macro Self Test Sharing Database Information Introduction Creating an Execute-Only Database Encrypting a Database Using the Access 2010 Runtime Program Packaging a Database Synchronizing a Database with a SharePoint List Importing Data from and Exporting Data to SharePoint Lists Sharing a Database Self Test Module Summary Module Summary Glossary Glossary |
MOAC >