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
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
Hardware/software required to run this course
For this course, you will need one computer for each student and one for the instructor. Each computer will need the following minimum hardware components:
- 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.
Delivery Method:
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Course duration
1 Day(s)
Course outline
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
Appendix B: Using Access with other applications
- Linking and importing data
- Using the OfficeLinks tool
|
