As you begin this course, you should have the basic skills you need to design and create relational databases with Access. At this point, you're about knee-deep in Access. You're able to get started and work through many of the essential and straightforward tasks related to your work. You might be hopeful that no one will ever ask for anything too complicated! This course takes you to the next step. By the end of it, you'll be “waist-deep” and more fully able to put the power of database computing to work for you. You will have a handle on many intermediate-level skills, particularly those related to creating more complex queries, customizing your forms and reports, and broadening the availability of your data.
Course Objectives
You will learn intermediate Access 2002 skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages.
Prerequisites
Students enrolling in this course should have a basic level of understanding of the Access 2000 interface and should have experience designing tables, simple queries, forms, and reports. To ensure your success, we recommend you first take the following course or have equivalent knowledge:
- Windows 2000 Introduction
- Access 2002 Level 1
Target Student:
This course targets persons who use Access 2002 as a tool for getting their work done. Your responsibilities might include creating and/or revising the design of tables, queries, forms, reports, and data access pages. This course also serves as a prerequisite for persons interested in learning more advanced skills and features.
Performance-Based Objectives
Upon successful completion of this course, students will be able to:
- share data with other applications and enforce referential integrity.
- modify the design of a table to streamline data entry and maintain data integrity.
- use a filter to show you records in a datasheet or a form that match whatever conditions you specify, and you will generate different query results by creating different types of joins between tables.
- create select queries that display special records and you will design other types of queries, including parameter and action queries.
- create forms and change their designs to enhance the appearance and usability of a form and to make your form more professional.
- create reports and change their designs to better organize and summarize information and to improve the appearance by enhancing data layout and working with report pagination.
- create and work with data access pages.
Certification
Access 2002: Level 2 is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Platform Requirements
- This book was written using the Windows 2000 Professional operating
system. Using this book with other operating systems may affect how the activities
work.
Hardware Requirements
- Pentium 133 MHz or higher processor required for all operating
systems.
- 64 MB of RAM recommended minimum for Windows 2000 Professional;
in addition, you should have 8 MB of RAM for each application running simultaneously.
- 600 MB of free hard-disk space. (Under Windows 2000, at least
4 MB of space must be available in the Registry.)
- Either a local CD-ROM drive or access to a networked CD-ROM
drive for the installation of the software and course data files.
- A two-button mouse, an IntelliMouse, or compatible pointing
device.
- VGA or higher-resolution monitor; Super VGA recommended.
Software Requirements
- A complete installation of Microsoft Office XP Professional.
- An installed printer driver. (Printers are not required; however,
each PC must have an installed printer driver to use Print Preview.)
- Windows 2000 Professional.
Course duration
1 Day(s)
Course outline
Lesson 1: Managing
a Database and Data
- Topic 1A: Import Data
- Topic 1B: Maintain
Record Integrity
- Topic 1C: Exporting
Data
- Topic 1D: Documenting
Table Relationships
Lesson 2: Controlling
Data Entry
- Topic 2A: Make Data
Entry More Accurate
- Topic 2B: Make Data
Entry More Efficient
- Topic 2C: Facilitate
Data Entry
Lesson 3: Finding and
Joining Data
- Topic 3A: Find Data
with Filters
- Topic 3B: Get the Correct
Data with Query Joins
- Topic 3C: Building
Bridges Between the Data
- Topic 3D: Relating
Data within a Table
Lesson 4: Creating
Flexible Queries
- Topic 4A: Summarizing
Data with Queries
- Topic 4B: Enter Criteria
on the Fly
- Topic 4C: Maintain
Data with Queries
Lesson 5: Improving
Your Forms
- Topic 5A: Enhance the
Appearance of a Form
- Topic 5B: Enhance the
Usability of a Form
- Topic 5C: Make Your
Forms More Professional
- Topic 5D: Display Form
Data from Multiple Tables
Lesson 6: Customizing
Your Reports
- Topic 6A: Organize
Report Information
- Topic 6B: Enhancing
Data Layout
- Topic 6C: Working with
Report Pagination
- Topic 6D: Summarizing
Information
- Topic 6E: Add a Subreport
to an Existing Report
- Topic 6F: Creating
Mailing Labels
Lesson 7: Making Your
Data Available on the Web
- Topic 7A: Create a
Data Access Page
- Topic 7B: Improving
the Look of a Data Access Page
- Topic 7C: Editing Data
Using a Data Access Page
- Topic 7D: Group Records
in a Data Access Page
Appendix A: Microsoft
Office Specialist Program
