Byron Employment

Byron Employment. Over 71,594 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $440.00

Course Outline: Access 2002 - Level 3

Learning Method: Instructor Led

Duration: 1 Day

Overview:
In this course, student will extend their Access skills to create and implement switchboard forms, develop data access pages that include advanced controls, protect that information using security protocols, and make the data more accessible and portable.

Outline:
Lesson 1: Creating a Switchboard and Setting the Startup Options
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
- Modify the Startup Options

Lesson 2: Developing a Data Access Page and Including a PivotTable and PivotChart
- Create a Data Access Page in Design View
- Incorporate a ComboBox Control in the Data Access Page
- View Data Access Pages with the Browser
- Add Records to a Database Using the Data Access Page
- Plan a PivotTable
- Develop a PivotTable with the Office PivotTable Tool
- Develop a PivotChart from a PivotTable

Lesson 3: Distributing and Securing the Database
- Split a Database
- Implement Security
- Set Passwords
- Encrypt and Decrypt a Database
- Convert an Access Database to an MDE File

Lesson 4: Integrating Access into Your Business
- Link Tables to External Data Sources
- Import XML Data into an Access Database
- Export Access Data to XML Format
- Replicate an Access Database

Lesson 5: Automating a Business Process with VBA
- Create a Standard Module
- Create and Insert a Procedure
- Develop Procedure Code
- Call a Procedure from a Form
- Run the Procedure

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 8263 5906
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 8263 5906 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search