Course outline
Exporting Data• Exporting Data to an Excel Workbook
• Saving Export Setup
• Dragging and Dropping Data into Excel
• Creating Word Mail Merge Documents
Using Advanced Database Features
• Importing Data
• Linking Data to an Access Table
• Using the Linked Table Manager
• Exporting Data
• Converting Files
• Printing a Relationship Document
• Compacting a Database
• Using Name AutoCorrect
• Backing Up a Database
Using Subforms/Subreports
• Working with Subforms/Subreports
• Creating a Subform/Subreport
• Editing the Layout of a Subform
• Displaying a Subform in Datasheet View
• Displaying a Subform/Subreports Total
Using Controls and Layouts
• Switching Views
• Using Controls
• Using Control, Stacked and Tubular Layouts
• Moving and Removing a Control from a Layout
• Viewing the Properties of an Object
• Changing a Control Property
• Manipulating Controls
Using Other Form Techniques
• Creating a Split Form
• Converting an Existing Form to a Split Form
• Editing a Split Form
• Adding a Command Button
• Saving a Form as a Report
Using Charts
• Creating a Chart and Adding it to a Form or Report
• Activating Microsoft Graph to Edit
• Changing the Chart Type and Title
• Formatting the Chart Title and Adding Data Labels to a Chart
Using PivotTables and PivotCharts
• Creating a PivotTable View
• Creating a PivotChart View
• Using Other Form Techniques
Creating Macros
• Working with Macros
• Opening the Macro Tools Window
• Creating a Macro
• Displaying Macro Design Arguments
• Assigning an Argument to an Action
• Saving a Macro
• Using Single Step Mode for Testing
• Running a Macro
• Editing an Existing Macro
Using Macros
• Using Properties
• Creating Embedded Macros
• Assigning a Macro to a Control and Creating a Command Button
• Adding a Condition to a Macro
• Creating a Group Macro
• Creating an Autoexec Macro
Collecting Data by E-mail
• Data Collection and using the Collect Data By E-mail Messages Wizard
• Setting Data Collection by E-mail Options
• Manually Processing Replies
Customising the Navigation Pane
• Creating Custom Categories
• Creating Custom Groups
• Adding Database Objects to a Group
• Showing/Hiding the Unassigned Objects Group
• Deleting Objects from a Group
