Access 2000 Courses

Access 2000

Module 2 (Advanced) Course Outline

Important Information Regarding Database Design

It is not possible to be a proficient Access user without also understanding how to correctly design and implement a relational database. We do not list "Database Design" as a separate topic in our course outline. Design issues are covered throughout the course so that by the end of the course each delegate is extremely proficient in both the advanced use of all Access features and relational database design best-practice.

As well as learning Access you'll also pick up many "golden rules" of database design - things we've discovered the hard way after over 20 years of designing and implementing commercial databases for some of the world's largest companies.

At the end of this course delegates will not only understand Dr Codd's Third Normal Form rules but also appreciate why they are important... and the problems that will occur if they are not observed. You'll also learn some of The Smart Method's database design rules that you will never find in a textbook! Read the outline below but remember that you'll come away from this course with far more than simply the topics listed.

Working with Queries
     A Quick Review
     Creating a Multiple Table Query
     Creating a Calculated Field
     Using Expressions
     Using an IIF Function
     Summarizing Groups of Records
     Using Criteria
     Display Top or Bottom Values
     Parameter Queries
     Finding Duplicate Records
     Finding Unmatched Records
     Crosstab Queries
     Delete Queries
     Append Queries
     Make Table Queries
     Update Queries

Working with Forms
     Creating a Form with AutoForm
     Modifying a Form
     Adding and Deleting Fields
     Moving and Sizing Controls
     Changing the Tab Order
     Working with Control Properties
     Control and Form Property Reference
     Working with Form Properties
     Working with Multiple Controls
     Adding, Cutting, Copying, and Pasting Controls
     Changing a Control’s Data Source
     Creating a Calculated Control
     Changing a Control’s Default Value
     Using the Control Wizard
     Creating a Subform
     Modifying and Working with Subforms

Working with Reports
     Creating a Report with AutoReport
     Modifying a Report
     Adding and Deleting Fields
     Moving and Sizing Controls
     Adjusting Page Margins and Orientation
     Adding Page Numbers and Dates
     Understanding Report Sections
     Grouping and Sorting Records
     Creating Calculated Controls
     Working with Section Properties
     Creating Charts with the Chart Wizard

Formatting Forms and Reports
     Formatting Fonts with the Formatting Toolbar
     Changing Text Alignment
     Using AutoFormat
     Changing Colours
     Applying Special Effects
     Using the Format Painter
     Adding Pictures and Lines
     Aligning Controls
     Changing a Control’s Formatting Properties

Working with Macros
     Creating and Running a Macro
     Editing a Macro
     Working with Macro Groups
     Assigning a Macro to an Event
     Creating Conditional Expressions
     Assigning a Macro to a Keystroke Combination
     Macro Action Reference

Working with Other Programs
     Importing Information
     Exporting Information
     Importing Objects from another Access Database
     Linking Information from an External Source
     Analyzing Records with Microsoft Excel
     Exporting Records to Microsoft Word
     Mail Merging Records to Microsoft Word
     Using Hyperlink Fields
     Using OLE Object Fields