 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
Students will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.
Students learn how to create and use database objects, including tables, queries, forms, and reports.
Students should already understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. No prior knowledge of databases or Access is assumed.
Prerequisites:
Windows Introduction or equivalent knowledge.
Unit 1 : Overview of Access 2000
- Introduction to database concepts and terminology
- An introduction to Access 2000
- Database planning and design
- Examining a table
- Creating a table with the Table Wizard
- Creating a table in Design View
- Types of primary keys
Unit 3 : Working with tables
- Modifying a table using Design view
- Finding and editing records
- Filtering and sorting records
Unit 4 : Creating and using select queries
- Creating a Select query to view specific fields
- Specifying criteria in a query to view specific records
- Using queries to perform calculations
- Joining tables in a query
- Creating a form with the Form Wizard
- Modifying the form design
- Using a form to locate and organise information
- Multiple-table forms
Unit 6 : Creating and using reports
- Creating a report with the Report Wizard
- Creating a report that contains totals
Unit 7 : Database maintenance
- Creating a database
- Managing a database and its objects
- Database maintenance