Access Advanced
Days 1 Code AC132 Fee £195
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