Overview
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools.
Course Objectives
You will work with Access 2003 tables, create new forms and reports, and customize database operations.
Prerequisites
Basic computer skills would be helpful, but are not necessary.
Target Student:
This course is designed for any professional whose goal is to achieve ECDL certification.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- examine the Microsoft Office® Access 2003 database
application.
- create a table, manipulate records in a table, modify the
design and layout of tables, and add and delete relationships between tables.
- create and navigate within a form, manipulate records in
a form, and add and modify headers and footers in a form.
- retrieve data from a table and a form by using the Find
command and filters, and also by querying a database.
- create a report and organize information within a report.
- prepare tables, forms, query results, and reports for printing,
and preview them before printing.
Platform Requirements
Hardware Requirements
For this course, you will need one computer for each student
and one for the instructor. Each computer will need the following minimum
hardware components:
- A 300 MHz Pentium-class processor if you use Windows XP Professional
as your operating system. (500 MHz is recommended.)
- A 233 MHz Pentium-class processor if you use Windows 2000
Professional as your operating system.
- 256 MB of RAM.
- A 6 GB hard disk.
- A floppy-disk drive.
- A mouse or other pointing device.
- A monitor capable of displaying 800 x 600 resolution.
- Network cards and cabling for local network access.
- Internet access (see your local network administrator).
- A printer (optional).
- A projection system to display the instructor's computer screen.
Software Requirements
- Either Microsoft® Windows® XP Professional with Service
Pack 1, or Microsoft® Windows® 2000 Professional with Service Pack
4.
- Microsoft® Office 2003 Professional Edition.
Course duration
1 Day(s)
Course outline
Lesson 1: Using the Access Application
- Topic 1A: Investigate Database Concepts
- Topic 1B: Identify Primary and Foreign Keys
- Topic 1C: Examine the Access Environment
- Topic 1D: Open the Database Environment
- Topic 1E: Create a New Database
- Topic 1F: Get Help Using Access
Lesson 2: Working with Tables
- Topic 2A: Examine an Access Table
- Topic 2B: Create a Table
- Topic 2C: Add a Field to a Table
- Topic 2D: Add, Modify, and Delete Records
- Topic 2E: Delete a Table
- Topic 2F: Sort Records
- Topic 2G: Modify Table Design
- Topic 2H: Change the Layout of a Table
- Topic 2I: Create Relationships Between Tables
- Topic 2J: Delete Relationships Between Tables
Lesson 3: Working with Forms
- Topic 3A: Examine an Access Form
- Topic 3B: Create a Form Using AutoForm
- Topic 3C: Create a Form Using the Form Wizard
- Topic 3D: Add, Modify, and Delete Records Using a Form
- Topic 3E: Add and Modify Headers and Footers in a Form
Lesson 4: Retrieving Information
- Topic 4A: Retrieve Data Using the Find Command
- Topic 4B: Retrieve Data Using Filters
- Topic 4C: Create a Select Query
- Topic 4D: Add Criteria to a Query
- Topic 4E: Modify a Query in Design View
Lesson 5: Working with Reports
- Topic 5A: Create a Report Based on a Table
- Topic 5B: Create a Report Based on a Query
- Topic 5C: Modify the Design of a Report
Lesson 6: Preparing Outputs
- Topic 6A: Preview and Print a Table
- Topic 6B: Preview and Print a Form
- Topic 6C: Preview and Print a Query
- Topic 6D: Preview and Print a Report
|
