|
Course Name |
Microsoft Office Access 2003 Level 1 |
Contact Hours: 24 |
|
Course Description |
PIN code provided for this course allows unlimited on-line access for 90 days. This course is designed to introduce students to the basic elements that comprise a Microsoft Office Access database. Students will learn what a database is and how an effective database should be designed and set up. After they learn how to manipulate the Access interface and create their own databases, students will receive instruction in how to create and use the basic tools of the Access application: tables, forms, filters and sorts, queries, and reports. In addition, students will learn how to enter data in Access and how to manipulate and use that data. |
|
Outcome |
Upon completion of this course, students will be able to:
- Understand common database elements
- Navigate and modify tables
- Use Datasheet view to enter and manipulate table data
- Create new databases and tables
- Create relationships using referential integrity
- Create and modify forms
- Filter data and run queries
- Work with basic reports
|
|
Assessment |
Student performance is assessed by cumulative training time, number of lessons completed and, where tests are available, the percent correct. Many courses also have a pre- and post-test where the pre-test will automatically assign only the lessons needed to achieve course mastery. |
|
Outline |
- Look At Microsoft Office Access 2003
- Launch Microsoft Office Access 2003
- Open Access Databases And Examine The Database Window
- Change The Default File Format In Access
- Close Access Databases And Exit Access
- Understand Tables
- Navigate In Tables
- Modify Columns And Rows
- View Multiple Tables
- Enter Data In Datasheet View
- Use AutoCorrect
- Modify Table Data
- Find Records
- Delete Table Data
- Sort Table Data
- Explore And Use The Database Wizard
- Create Blank Databases From Scratch
- Examine Primary Keys
- Understand Data Types
- Create Tables In Design View And Set Primary Keys
- Use The Table Wizard -- Switch Between Views
- Understand Relationships
- Add Tables To The Relationships Window
- Create Table Relationships
- Enforce And Test Referential Integrity
- Edit Existing Relationships
- Organize And Print Relationships
- View Subdatasheets
- Understand Forms
- Create AutoForms
- Create Forms Using The Form Wizard
- Navigate Among Records
- Enter Data Using A Form
- Look At Form Design View
- Modify Control Properties
- Move And Delete Controls
- Align And Space Controls
- Understand Filters
- Use Filter By Form
- Use Filter By Selection And Sort Records
- Understand Queries
- Create Single-table Queries In Query Design View
- Create Select Queries Using A Wizard
- Delete, Move, And Hide Query Fields
- Find Duplicate Records
- Find Unmatched Records
- Understand Reports
- Create And Save AutoReports
- Create Reports Using A Wizard
- Navigate In Reports
- Preview Report Pages
- Modify Page Orientation And Margins
- Print Reports
- Examine The Help Task Pane
- Ask Help A Question
- Look At The Office Assistant
|
|
|
|