This course is provided by Wintrac.
Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on
Desktop Application Software training,
E-Mail/Groupware training,
Office Suite training,
Operating Systems training,
Presentations training,
Spreadsheets training,
Web Browsers training and
Word Processing training
Overview:
Access 2000: Advanced is a hands-on instruction book that will introduce you to advanced techniques in Access 2000. You will learn how to perform complex queries, create efficient forms and reports, create and use macros, use Internet-related Web tools, and carry out data integration procedures.
Prerequisites:
To ensure your success with this course, we recommend that you first take the following Content courses or have equivalent knowledge:
- Access 2000: Level 1
- Access 2000: Level 2
Target Student:
Students enrolling in this course should be able to work with Access at an intermediate level and understand Access terminology.
Benefits:
Students will learn how to analyze data by creating complex queries, make forms and reports more efficient, speed repetitive tasks by creating macros, and become familiar with Internet-related Access tools.
Performance-Based Objectives:
- Make select queries more versatile and useful by using parameters;
and use action queries to update data values and add or delete records.
- Generate different query types by creating various types of joins
between tables; and use crosstab queries to summarize data.
- Use advanced form features including properties, functions, and
design tools to facilitate data entry and improve accuracy in forms; and display
table information that has a one-to-many relationship by creating forms that
contain subforms.
- Automate tasks by creating macros to open forms and control form
properties.
- Make forms more functional by using macros to provide user interaction
and automate data entry.
- Make reports more concise and easier to understand by using properties
and functions in report controls.
- Use Internet-related Access tools by inserting hyperlinks and
using the Web toolbar; and integrate Access data with other Office 2000 applications.
Certification:
Access 2000: Advanced 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.
What's Next:
Access 2000: Introduction to Application Development, the next course in this series, teaches students how to develop custom applications by using Access.
Hardware/Software Requirements:
This course was developed using the Windows 98 platform; however, the
manufacturer’s documentation states that Office 2000 can also run on Windows
95 or Windows NT 4.0 with Service Pack 3 or higher installed, though some
of the screen displays might be slightly different.
- A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium
133 or faster with 32 MB or more.)
- 600 MB of free hard-disk space. For optimal performance, we
recommend an additional 100 MB of free hard-disk space for user graphics and
temporary image caches.
- Either a local CD-ROM drive or access to a networked CD-ROM
drive for installation purposes.
- A 3.5"-disk drive.
- A two-button mouse, an IntelliMouse, or compatible pointing
device.
- VGA or higher-resolution monitor; Super VGA is recommended.
(The EGA display adapter is not supported.)
- An installed printer driver. (Printers are not required; however,
each PC must have an installed printer driver to use Print Preview.)
- An Internet connection with access to the World Wide Web. The
connection is necessary to complete some tasks and Web tips throughout the
book. (Note: Internet access may require payment of a separate fee to a service
provider.)
- Microsoft Windows 95 (or later) operating system, Microsoft
Windows 2000 operating system, Microsoft Windows NT Workstation operating
system version 4.0 Service Pack 3 (or later). If you are running Windows NT,
make sure that you have at least 4 MB of free Registry space.
- A custom installation of Microsoft Office 2000 Premium Edition—see
the following section, Class Requirements, for additional instructions.
Course duration:
1 Day(s)
Course outline:
Lesson 1: Parameter and Action Queries
- Topic 1A: Creating Parameter Queries
- Topic 1B: Creating Action Queries
Lesson 2: Query Joins and Crosstab Queries
- Topic 2A: Joining Tables and Working with Join Properties
- Topic 2B: Creating Crosstab Queries
- Topic 2C: Editing Limitations in Query Datasheets
Lesson 3: Using Advanced Form Techniques
- Topic 3A: Organizing Field Placement
- Topic 3B: Using Functions to Control Data Entry
- Topic 3C: Adding an Option Group to a Form
- Topic 3D: Using a Form as the User Interface
- Topic 3E: Creating a Form that Contains a Subform
Lesson 4: Creating Basic Macros to Automate Forms
- Topic 4A: Macro Basics
- Topic 4B: Attaching a Macro to a Command Button
- Topic 4C: Revising a Macro
Lesson 5: Using Macros to Provide User Interaction
and Automate Tasks
- Topic 5A: Using a Macro to Provide User Interaction
- Topic 5B: Using Macros to Automate Data Entry
- Topic 5C: AutoKeys and AutoExec Macros
Lesson 6: Using Advanced Report Techniques
- Topic 6A: Customizing the Appearance and Functionality
of a Report
Lesson 7: Web Capabilities and Data Integration
- Topic 7A: Creating and Using Hyperlinks
- Topic 7B: Data Integration
Appendix A: Replicating Databases
Appendix B: Encrypting Databases
- Encrypting and Decrypting a Database
Appendix C: Mailing Labels
- The Mailing Label Report Wizard
