Untitled document
Upon completion of this course, students will be able to:
1. Design databases by identifying components and designing data tables
2. Examine Access objects such as tables, queries, forms, and reports
3. Create databases and tables by using the table design window,
determining field names and data types, and assigning a primary key
4. Work with records by adding, editing, deleting, and sorting records
5. Work with table structure by modifying the table design and setting
field properties
6. Find records by using comparison operators
7. Locate information by creating filters by form and by input
8. Create select queries to select tables and fields as well as hide
and sort fields in result sets
9. Modify query design by adding, deleting, inserting, and moving fields
10. Create forms using AutoForm and Form Wizard
11. Work with Controls: adding, deleting, moving, sizing, and aligning.
12. Create forms by using Design View
13. Create reports using AutoReport and Design View
14. Enhance forms and reports by AutoFormat, applying special effects,
and adding graphics
15. Repeating students will apply software version changes
Untitled document
1. Designing databases
A. Identifying database components
B. Designing data tables
C. Designing relational databases
2. Examining Access objects
A. Starting Access and open a database
B. Exploring the database window
C. Examining tables, queries, forms, reports
D. Using the Office Assistant
E. Exiting Access
3. Creating databases and tables
A. Creating new databases
B. Creating tables by using the table design window, determining field
names and data types, assign a primary key, and use a table
wizard
4. Working with records
A. Modifying datasheet layout by changing column widths, move columns,
and hide and show columns
B. Adding, edit, delete, and sort records
5. Working with table structure
A. Modifying table design by adding, deleting, moving, and renaming
fields
B. Setting field properties by limiting field size and setting field
formats
6. Locating information
A. Finding records
B. Understanding comparison operators
C. Using filters by creating filters by selection, excluding selection,
by form, and for input
7. Using select queries
A. Create select queries by selecting tables to query, selecting
fields to query, and hiding and sorting fields in result sets
B. Apply filters to query result sets
C. Modify query design by adding, deleting, inserting, and moving
fields as well as setting field properties for query fields
D. Specify criteria and multiple criteria
8. Creating and using forms
A. Creating forms using the AutoForm and Form Wizard
B. Work with controls by adding, deleting, moving, sizing, and
aligning controls
C. Work with control and form properties
D. Creating forms using design view
E. Adding records using forms
F. Printing forms
9. Creating and using reports
A. Create reports using Auto Report
B. Work with report sections
C. Work with controls by moving and sizing controls as well as
grouping and sorting records
D. Work with control and report properties
E. Create reports using design view
F. Print reports
10. Enhancing forms and reports
A. Formatting with AutoFormat
B. Changing the appearance of forms and reports by applying special
effects and coloring forms and reports
C. Using form sections
D. Adding graphics by drawing lines and rectangles as well as
inserting graphic images
11. Repeating students will learn about software version changes
Untitled document
Instructor prepared materials
