COURSE DESCRIPTION FOR
MICROSOFT ACCESS - ADVANCED
This class description basically covers all versions of Access.
To request the class description and system requirements
for your version of Access, send e-mail to the
Office Wiz
This class will show you how to analyze data by creating
complex queries, make forms and reports more efficient, speed up repetitive
tasks and work with Internet-related Access tools. The class is instructor-led
with plenty of hands-on activities. Learn 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.
LENGTH
Approximately eight hours. Recommend two four hour sessions.
PREREQUISITES
Access - Level 1 and 2 or equivalent
knowledge. You should be able to work with Access at an intermediate level
and understand Access terminology. Also you must have a good understanding
of basic Microsoft Windows, file management and personal computers.
SPECIFIC CLASS 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 technqiues
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
NECESSARY SOFTWARE AND HARDWARE
- A 486/66-compatible PC that meets minimum hardware requirements
for Windows 95 or later or Windows NT 4.0 or later. A Pentium 90 MHz processor
with 32 MB RAM or better is recommended. The minimum memory requirement
is 16 MB RAM. Check your reference manual for specific hardware considerations.
- Windows 95, 98 or Windows NT 4.0 with Service Pack 3
(or higher) installed.
- Installation of the entire Office 2000 suite of software
(including Access 2000) requires 280 MB of hard-disk space. Copying the
zipped exercise files from the data disk to the hard disk requires 3 MB
of hard-disk space.
- Microsoft mouse or compatible pointing device.
- A printer (optional). You must have an installed printer
driver to use Print Preview.
OTHER ACCESS CLASSES
- Mini Power Sessions:
--Analyze Your Product And Sales Data Using Access
--Create And Normalize A Database From Excel Using Access
--Customize Your Reports Using Access
--Manage, Plan And Analyze Your Inventory Using Access
--Produce Letters, Lists And Catalogues Using Access And Word
| 