| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Access 2007: Introduction (Half-Day) |
| Course Number: APH0001 |
| Category: Business & Office Applications |
| Duration: 0.50 days |
Description
This half-day course covers the essential basics of Microsoft Access 2007. Class participants will learn basic database concepts as they explore the Access environment. They will also learn how to design and create databases; create tables, fields, and records; and sort and filter data.
Outline
- Unit 1: Getting started
- Topic A: Database concepts
- A-1: Identifying database components
- A-2: Identifying the advantages of relational databases
- Topic B: Exploring the Access environment
- B-1: Starting Access and examining the Access window
- B-2: Opening a database
- B-3: Using the Navigation Pane
- B-4: Examining a database table
- Topic C: Getting help
- C-1: Using Help
- Topic A: Database concepts
- Unit 2: Databases and tables
- Topic A: Planning and designing databases
- A-1: Planning a database
- A-2: Creating a database from a template
- A-3: Creating a blank database
- Topic B: Exploring tables
- B-1: Discussing views
- B-2: Examining a table in Datasheet view
- B-3: Navigating in a table in Datasheet view
- B-4: Examining a table in Design view
- Topic C: Creating tables
- C-1: Creating a table by using the table templates
- C-2: Creating a table in Design view
- C-3: Adding fields and descriptions ta table
- C-4: Setting the primary key
- C-5: Saving the table
- C-6: Adding a record
- C-7: Copying, modifying, and deleting a table
- C-8: Creating a composite key
- Topic A: Planning and designing databases
- Unit 3: Fields and records
- Topic A: Changing the design of a table
- A-1: Modifying field names
- A-2: Deleting and inserting fields
- A-3: Moving a field
- A-4: Using the Attachment data type
- A-5: Adding a total row
- Topic B: Finding and editing records
- B-1: Finding and replacing a value
- B-2: Undoing changes
- Topic C: Organizing records
- C-1: Sorting records by a single field
- C-2: Sorting records by multiple fields
- C-3: Using Filter By Selection
- C-4: Using Filter By Form
- C-5: Using Filter Excluding Selection
- C-6: Using Advanced Filter/Sort
- C-7: Deleting a record
- Topic A: Changing the design of a table
- Unit 4: Data entry rules
- Topic A: Setting field properties
- A-1: Setting the Required property
- A-2: Using the Allow ZerLength property
- A-3: Setting the Field Size property
- A-4: Setting the Append Only property
- Topic B: Working with input masks
- B-1: Creating an input mask
- B-2: Working with the Input Mask Wizard
- Topic C: Setting validation rules
- C-1: Creating validation rules
- C-2: Setting validation text
- Topic A: Setting field properties