Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities.
Course Objectives
You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications.
Prerequisites
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
- Access 2002 Level 1
- Access 2002 Level 2
Target Student:
This course targets persons who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools. Persons who have some or all of these responsibilities and who perform these tasks for their own work or in support of less-advanced Access users.
Performance-Based Objectives
- put existing data into correctly designed tables and compact
your database.
- use a variety of techniques to summarize data.
- create and revise basic Access macros.
- create macros that require data entry in certain fields
and automatic data entry in others.
- use advanced features to enhance forms.
- use advanced features to enhance reports and distribute
a report to non-Access users.
- use Office Links to use Access data in other Office programs.
Certification
Access 2002: Level 3 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
- Windows 2000 Professional. 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.
- 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.
- An installed local printer driver; a PostScript driver is
recommended. (Printers are not required; however, each PC must have an installed
local printer driver to use certain features.)
Software Requirements
- A complete installation of Microsoft Office XP Professional.
In particular, this course uses Access, Snapshot Viewer, Excel, and Word.
Course duration
1 Day(s)
Course outline
Lesson 1: Structuring Existing Data
- Topic 1A: Use
the Table Analyzer Wizard for Help
- Topic 1B: Decide on Your Own Design
- Topic 1C: Create a Junction Table
- Topic 1D: Modify
the Original Tables and Complete the Design
- Topic 1E: Compact and Repair a Database
Lesson 2: Summarizing Data
- Topic 2A: Group and Summarize Records in Different Ways
- Topic 2B: Summarize with a Crosstab Query
- Topic 2C: Pivot Query Results
- Topic 2D: Display
a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
- Topic 3A: Create a Macro
- Topic 3B: Attach a Macro to a Command Button
- Topic 3C: Restrict Records
Lesson 4: Adding Interaction and Automation with Macros
- Topic 4A: Require Data Entry with a Macro
- Topic 4B: Display
a Message Box with a Macro
- Topic 4C: Automate Data Entry
Lesson 5: Making Forms More Usable
- Topic 5A: Change the Display of Data Under Certain Conditions
- Topic 5B: Display a Calendar on a Form
- Topic 5C: Organize Information with Tab Pages
Lesson 6: Making Reports More Powerful
- Topic 6A: Cancel Printing of a Blank Report
- Topic 6B: Include
a Chart
- Topic 6C: Arrange
Data in Columns
- Topic 6D: Distribute
Reports as a Snapshot
Lesson 7: Expanding the Reach of Your Data
- Topic 7A: Merge Access Data with a Word Document
- Topic 7B: Publish
Access Data as a Word Document
- Topic 7C: Analyze Access Data in Excel
Appendix A: Access
Object Names
Appendix B: Microsoft
Office Specialist Program
