ICT Education Newsletter
This training provides you with the skills and knowledge required to create, customize, use, and share Access 2010 databases.
Topics covered in this training include:
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
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.
1) 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
2)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
3)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
4)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
Students will be able to:
1)Modify a database
2)Create complex queries to extract and process specific information
1)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
2)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
Students will be able to:
1)Create programmed elements to automate tasks and add functionality to database objects and controls.
2)Share and distribute database information.
1)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
2)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