Contents
Students will be able to:
1) Create and edit a database.2) Create and use a query.3) Create and edit a report.4) Create and edit a form.
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 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
Creating a Report
Creating a Label
Grouping and Sorting Data in a Report
Performing Calculations in a Report
Creating and Editing a Report
Creating a Form by Using Form Wizard
Creating a Form by Using the Form Tool
Editing a Form in Design View
Creating a Form
1)Modify a database
2)Create complex queries to extract and process specific information
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
Creating a Complex Query
Creating a Totals Query
Creating and Editing a Query in SQL View
Creating Pivot Objects
Creating and Editing Complex Queries
1)Create programmed elements to automate tasks and add functionality to database objects and controls.
2)Share and distribute database information.
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
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