Access 2007, Introduction
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools.
In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.
Audience
The target student for this course should be comfortable using a personal computer and Microsoft Windows XP or later. Students will get the most out of this course if their goal is to become proficient using the features of Microsoft Access, including the tables, forms, reports, and filters.
Students taking this course should be familiar with personal computers and the use of a keyboard and a mouse. Furthermore, this course assumes that students have completed the Windows XP: Basic course (or Windows Vista: Basic) or have equivalent experience.
Upon successful completion of this course, students will be able to:
- Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
- Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
- Modify a table’s design; use the attachment data type; find and replace data; sort, filter, and delete records.
- Set field properties, create input masks, and set validation rules.
- Create queries and sort and filter the results; modify queries; and perform operations in queries.
- Create, modify, and work with forms; and use them to sort and filter records.
- Create reports by using the Report button, the Report Wizard, Design view, Layout view, and queries; modify and print reports.
- CertBlaster preparation and materials also included.
- Unit 1: Getting started
- Unit 2: Databases and tables
- Unit 3: Fields and records
- Unit 4: Data entry rules
- Unit 5: Basic queries
- Unit 6: Using forms
- Unit 7: Working with reports
In order for a class to be successful, all students should share the same general level
of knowledge and experience. If a participant does not demonstrate these, the instructor will take
the necessary steps either to prepare the participant or place him/her in a more appropriate course.
This policy is intended to maintain the high level of quality control that you have come to expect.