Access Advanced
Days 1 Code AC132
This course introduces students to the more advanced features in Access.
Course Details
This course introduces students to the more advanced features in Access. Tasks include using charts, sub-forms, other form and Report techniques. Students will also learn how to work with indexes, create macros and customise the Access navigation pane. Finally student will learn how to create a switchboard in order the database users can navigate around the different forms, tables and reports.
Prerequisites
Students should have the following prerequisite knowledge prior to attending this course:
-
Attended the MS Access Introduction or a very good working knowledge of the subject
Examination
Course Outline
- Creating a Chart
- Adding a Chart to a Form or Report
- Changing the Chart Type
Lesson 2: Using Subforms/Subreports
- Creating a Subform/Subreport
- Editing the Layout of a Subform
- Displaying a Subform in Datasheet View
- Creating Navigation Forms
- Creating a Tab Hierarchy
Lesson 3: Working with Indexes
- Creating a Single Field Index
- Creating a Multiple Field Index
- Creating a Multiple Field Primary Key
Lesson 4: Using Access and the Internet
- Creating a Hyperlink Field
- Inserting a Hyperlink Field
Lesson 5: Using Access Database Security
- Encrypting/Decrypting a Database
- Assigning a Database Password
- Removing a Database Password
Lesson 6: Creating Macros
- Creating a Macro
- Assigning an Argument to an Action
- Saving a Macro
- Editing an Existing Macro
- Creating a Macro using the Macro Builder
Lesson 7: Using Macros
- Creating Embeded Macros
- Assigning a Macro to a Control
- Creating a Command Button
- If Then Else Statements
- Using Macros in a Table
- Creating and Using Submacros
Lesson 8: Customising the Navigation Pane
- Creating Custom Categories
- Creating Custom Groups
- Deleting Objects from the Group
Lesson 9: Exporting Data
- Exporting Data to an Excel Workbook
- Saving Export Steps
- Dragging and Dropping
Lesson 10: Using Switchboards
- Creating a Switchboard Form
- Adding a Command Button to a Switchboard
- Setting Startup Options