Access 2003: Advanced

Course specifications
Course number: 074 462
Software version number: 2003
Course length: 1 day

Hardware/software required to run this course

This book was written for the Windows XP platform.
•	A 233 MHz Pentium-class processor if you use Windows XP Professional as your operating system. (300 MHz is recommended.)
•	A 133 MHz Pentium-class processor if you use Windows 2000 Professional as your operating system.
•	128 MB of RAM.
•	A 5 GB hard disk or larger, if you use Windows XP Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
•	A 3 GB hard disk or larger, if you use Windows 2000 Professional as your operating system. You should have at least 600 MB of free hard-disk space available for the Office installation.
•	A floppy-disk drive.
•	A mouse or other pointing device.
•	An 800 x 600 resolution monitor.
•	Network cards and cabling for local network access.
•	Internet access (see your local network administrator).
•	A printer (optional).
•	A projection system to display the instructor's computer screen.
•	Either Windows XP Professional with Service Pack 1, or Windows 2000 Professional with Service Pack 3.
•	Microsoft Office Professional Edition 2003.

Course description

Overview: Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Prerequisites: To ensure your success with this course, we recommend that you first take the following Element K Content courses or have equivalent knowledge:
•	Access 2003: Level 1
•	Access 2003: Level 2

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

Access 2003: Level 2

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

•	Make select queries more versatile and useful by using parameters; use action queries to update data values and add or delete records.
•	Generate different query types by creating various types of joins between tables; 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; 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; create mailing labels.
•	Use Internet-related Access tools by inserting hyperlinks and using the Web toolbar.

Access 2003: Level 2

Course content

Lesson 1: Parameter and action queries
Creating parameter queries 
Creating action queries

Lesson 2: Query joins and crosstab queries
Joining tables and working with join properties 
Creating crosstab queries
Editing limitations in query datasheets

Lesson 3: Using advanced form techniques
Organizing field placement
Using functions to control data entry
Adding an option group to a form
Using a form as the user interface
Creating a form that contains a subform 

Lesson 4: Creating basic macros to automate forms 
Macro basics
Attaching a macro to a command button
Revising a macro
Attaching a macro to an event in a form

Lesson 5: Using macros to provide user interaction and automate tasks
Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros 

Lesson 6: Using advanced report techniques 
Customizing the appearance and functionality of a report
Mailing and other types of labels 

Lesson 7: Access 2000 and the Internet
Using hyperlinks
Access tools for working on the Internet

Appendix A: Replicating databases
Replicating databases

Appendix B: Using Access with other applications
Linking and importing data
Using the OfficeLinks tool