Getting started
Database concepts
Exploring the Access environment
Getting help
Closing a database & Access
Databases and tables
Planning & designing databases
Exploring tables
Creating tables
Fields & records
Changing the design of a table
Finding & editing records
Organizing records
Data entry rules
Setting field properties
Working with input masks
Setting validation rules
Using indexes |
Basic queries
Creating & using queries
Modifying query results & queries
Performing operations in queries
Using forms
Creating forms
Using the Form Wizard
Using Design view
Finding, sorting, & filtering records
Working with reports
Creating reports
Modifying & printing reports
|
|
Access 2010: Introduction
|
After completing this course, students will know how to:
- Organize data efficiently by using a database management
system; start Access and open Access databases; and use the Help feature.
- Plan and create a database; use Datasheet view and Design
view; and create tables and work in tables.
- Modify a table’s design; use the Find feature and the
spelling checker; and sort, filter, and delete records.
- Set field properties; create input masks; set validation
rules; and create single- and multiple-field indexes.
- Create queries, and sort and filter the results; modify
queries; and perform operations in queries.
- Create, modify, and work with forms; and use them to find,
sort, and filter records.
- Create, modify and print reports and add summary fields to a report.
|
|
| Prerequisites: |
Windows XP - Introduction, Windows Vista - Introduction, or Windows 7 - Introduction, or equivalent experience.
|
