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
Upon successful completion of this course, students will be able to:
- examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
- design a simple database.
- build a new database with related tables.
- manage data in a table.
- query a database using different methods.
- design forms.
- generate reports.
This course is designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The first part of the course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.
Students should have completed the following courses or possess equivalent knowledge before starting this course:
- Windows 2000: Introduction
Lesson 1: Exploring the Microsoft® Office Access™ 2007 EnvironmentTopic 1A: Examine Database ConceptsTopic 1B: Explore the User InterfaceTopic 1C: Use an Existing Access DatabaseTopic 1D: Customize the Access EnvironmentTopic 1E: Obtain HelpLesson 2: Designing a DatabaseTopic 2A: Describe the Relational Database Design ProcessTopic 2B: Define Database PurposeTopic 2C: Review Existing Data Topic 2D: Determine Fields Topic 2E: Group Fields into TablesTopic 2F: Normalize DataTopic 2G: Designate Primary and Foreign KeysTopic 2H: Determine Table RelationshipsLesson 3: Building a DatabaseTopic 3A: Create a New DatabaseTopic 3B: Create a TableTopic 3C: Manage TablesTopic 3D: Create a Table RelationshipTopic 3E: Save a Database as a Previous VersionLesson 4: Managing Data in a TableTopic 4A: Modify Table DataTopic 4B: Sort RecordsTopic 4C: Work with SubdatasheetsLesson 5: Querying a DatabaseTopic 5A: Filter RecordsTopic 5B: Create a QueryTopic 5C: Add Criteria to a QueryTopic 5D: Add a Calculated Field to a Query Topic 5E: Perform Calculations on a Record GroupingLesson 6: Designing FormsTopic 6A: View Data Using an Access FormTopic 6B: Create a Form Topic 6C: Modify the Design of a FormLesson 7: Generating ReportsTopic 7A: View an Access ReportTopic 7B: Create a ReportTopic 7C: Add a Custom Calculated Field to a ReportTopic 7D: Format the Controls in a ReportTopic 7E: Apply an AutoFormat Style to a ReportTopic 7F: Prepare a Report for Print