Access - Advanced

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this 2 day program, participants will gain the knowledge and skills to allow them to understand and to utilise the more advanced features in Access.



You will learn to

Ø Create Action Queries and Use Query Wizards

Ø Import and export data

Ø Compact a database

Ø Manipulate form controls and set the tab order

Ø Use reports in Design View, create a calculated control and group data in a report

Ø Create and edit subforms and subreports

Ø Create a Pivot Table or Pivot Chart

Ø Work with single and multiple field indexes

Ø Replicate databases

Ø Create and use Macros

Ø Create and use Switchboards

Ø Create custom toolbars



What skills you need

A sound working knowledge of the topics covered in the Access Introduction course is assumed. Attendees should be able to work with tables and simple forms.



Electus training

Electus is a South Australian company with 20 years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.



Training includes

Each participant receives a training reference manual/workbook and supplementary training materials.

Refreshments and lunch are provided.


Course Content


Creating Action Queries

· Creating a Make-table Query

· Creating an Update Query

· Creating an Append Query

· Creating a Delete Query

Using Advanced Query Wizards

· Crosstab Query Wizard

· Find Duplicates and Find Unmatched Query Wizard

Using Advanced Database Features

· Importing & Exporting Data

· Linking Data to an Access Table

· Using the Linked Table Manager

· Converting Files

· Printing a Relationship Document

· Creating a Data Access Page - Page Wizard

· Compacting a Database

· Using Name AutoCorrect

· Using Object Dependencies

· Backing Up a Database

Manipulating Controls

· Using Controls

· Selecting Non-adjacent Controls and Adjacent Controls

· Deleting, Sizing and Moving Controls

· Sizing Controls Automatically

· Viewing the Properties of an Object

· Changing a Control Property

Using Advanced Form Design

· Using Forms in Design View

· Creating a Combo Box, a List Box and an Option Group

· Adding a Logic Control

· Setting the Tab Order Automatically and Manually

· Adding a Form Header and Footer

· Creating a Blank Form
Using Advanced Report Design

· Adding Report Sections in Design View

· Creating a Calculated Control

· Grouping Data in a Report

· Creating Group Headers and Footers

· Creating a Running Summary

· Inserting a Date/Time Control

· Inserting a Page Break

· Changing the Report Margins

· Using the Label Wizard

· Creating a Report without using a Wizard

Using Editing Tools

· Selecting Objects with the Toolbar

· Changing the Font, Character Format, Font Colour, Fill and Background Colours

· Formatting Lines and Borders

· Applying Special Effects

· Using AutoFormat

· Using Error Checking

· Using Smart Tags

· Setting AutoCorrect Options

Using Subforms/Subreports

· Creating a Subform/Subreport

· Editing the Layout of a Subform

· Displaying a Subform in Datasheet View

· Displaying a Subform/Subreport Total

Using Other Form Techniques

· Adding a Command Button

· Saving a Form as a Report

· Creating a PivotTable or PivotChart View

Working with Indexes

· Viewing Indexes

· Creating a Single Field Index

· Creating a Multiple Field Index

· Deleting an Index

· Creating a Multiple Field Primary Key
Creating Macros

· Opening the Macro Design Window

· Creating a Macro

· Assigning an Argument to an Action

· Saving a Macro

· Using Single Step Mode for Testing

· Running a Macro

· Editing an Existing Macro

· Running a Macro using the Tools Menu

· Creating a Macro using the Macro Builder

Using Macros

· Using Properties

· Assigning a Macro to a Control

· Creating a Command Button

· Adding a Condition to a Macro

· Creating a Group Macro

· Creating an Autoexec Macro

Using Switchboards

· Opening and using a Switchboard

· Creating a Switchboard Form

· Adding a Command Button to a Switchboard

· Setting Startup Options

· Switchboard Manager

Creating Custom Toolbars

· Creating a Custom Toolbar

· Adding a Built-in Menu Item

· Creating a Custom Menu Item

· Adding a Command to a Menu Item

· Adding Custom Commands

· Docking a Floating Toolbar

· Linking a Toolbar to a Report

· Adding a Separator Bar

· Creating a Shortcut Menu

· Linking a Custom Shortcut Menu

· Adding Buttons to a Custom Toolbar

· Changing a Button Image

· Deleting a Custom Toolbar

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Business Writing
Influencing & Negotiation
Minute Taking & Meeting Protocol
Customer Service
Report Writing
Speaking to Groups
Telephone Techniques
Indispensable Assistant
Leadership
Time Management
Access 2003
CorelDRAW 12
Dreamweaver MX 2004 Advanced
Dreamweaver MX 2004
Excel 2003 Advanced
Excel 2003 Intermediate
Excel 2003
FrontPage 2003 Advanced
FrontPage 2003

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results.