Definition & Purpose
In our Advanced Access class you will learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques.
Course OutlineChapter One: 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
Chapter Two: Formatting Forms and Reports
- Formatting Fonts with the Formatting Toolbar
- Changing Text Alignment
- Using AutoFormat
- Changing Colors
- Applying Special Effects
- Using the Format Painter
- Adding Pictures and Lines
- Aligning Controls with One Another
- Changing a Control’s Formatting Properties
Chapter Three: 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
Chapter Four: Advanced Topics
- 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
- Displaying Database Object Dependencies
Inquire about the MS ACCESS course now
Chicago: (312) 920-8822
Oak Brook: (630) 705-9999
Hours: 8
Price: $299