Microsoft Access 2003 Level 1
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual (074460S3) |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class is for the new user of Access and assumes no experience with relational databases. The topics cover the critical skills you need to get started creating databases in Access and working with the data by using tables, queries, forms, and reports. |
Overview of Access 2003
Introduction to database concepts and terminology
An introduction to Access 2003
Database planning and design
Creating tables
Examining a table
Creating a table with the Table Wizard
Creating a table in Design View
Types of primary keys
Working with tables
Adding records
Modifying the table design
Finding and editing records
Deleting, adding, and copying records and values
Filtering and sorting records
Using select queries
Selecting fields and sorting records
Refining the results of a query
Using queries to perform calculations
Joining tables in a query
Creating and using forms
Creating a form
Modifying the form design
Using a form to locate and organize information
Multiple-table forms
Creating and using reports
Creating a report
Creating a report that contains totals
Creating and maintaining a database
Creating a database
Managing a database and its objects
Database maintenance