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
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 Property Reference
Working with Form Properties
Form and Report Property Reference
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
