|
Access 2007
Advanced
Course description
Overview: Students will learn how to create simple databases,
create and modify database objects including tables, forms, reports
and queries. They will use a variety of commands, functions, and
Microsoft Office Access 2007 capabilities. It is designed for
computer users who are new to database programs or who only plan to
use Access occasionally.
Prerequisites: Working knowledge of computers or previous
experience in Access.
Benefits: Students will learn the fundamentals of a
relational database management system.
Objectives:
- Indentifying parts of the Access Screen
- Defining fields, data types and tables
- Creating databases using templates or blank databases
- Opening, saving and closing databases
- Creating tables using Datasheet View or Design View
- Inserting, Deleting and Modifying data in a table
- Adding, modifying and removing primary key fields
- Inserting, modifying and deleting a field
- Adding a total row to a table
- Formatting, renaming and deleting tables
- Saving database items in a variety of file formats
- Importing and exporting data from or to other applications
- Finding and replacing data using exact or partial matches, case
sensitive and wildcard searches
- Sorting and filtering data
- Creating, saving, closing, or running a query using the wizard
or in Design View
- Creating query criteria using comparison, wildcard, AND, OR
operators, or calculated fields
- Changing query field properties and applying aliases
Course Content |
