| |
 Microsoft Access Database Development Training
- Advanced
Class Length 1 Day
Prerequisites Access 2003 Intermediate, Access 2003
Introduction, Windows XP: Introduction or equivalent knowledge
Maximum Class Size: 10
Course Objectives
- Restructure an existing set of data to improve the design
of a database
- Use a variety of techniques to summarize and present data
with queries
- Create and revise basic Access macros
- Create macros that improve data entry efficiency and integrity
- Improve the effectiveness of data entry in forms
- Improve the effectiveness of data displayed in reports
- Maintain an Access database by using various utility tools
Course Outline
- Structuring Existing Data: import data, analyze tables,
create a junction table, improve table structure
- Writing Advanced Queries: create unmatched and duplicates
queries, group and summarize records using the criteria field,
summarize data with cross tab query, create a Pivot Table
and a Pivot Chart, display a graphical summary on a form
- Simplifying Tasks With Macros: create a macro, attach a macro
to a command button, restrict records using a where condition
- Adding Interaction And Automation With Macros: require data
entry with a macro, display a message box with a macro, automate
data entry
- Making Forms More Effective: change the display of data conditionally,
display a calendar on a form, organize information with tab
pages
- Making Reports More Effective: cancel printing of a blank
report, include a chart in a report, arrange data in columns,
create a report snapshot
- Maintaining An Access Database: link tables to external data
sources, back up a database, compact and repair a database,
protect a database with a password, determine object
dependency, document a database, analyze the performance of
a database
|
|
