Send to a Colleague Print Bookmark

Advanced Microsoft Access 2007 - Masterclass

Access 2007 users looking to enhance their skills will learn to design a secured, multi-user database. Create formula-driven validation, analyse data, create queries and more.

Quick Facts

 

$880 incl GST

Duration: 2 Days

Class Size: 10

Level: Advanced

Times: 9.00am - 5.00pm approx

 
Microsoft

Download Course Brochure

Access_2007_Masterclass.pdf

Other Microsoft Access 2007 Courses:

 

About the Course

This 2 day course builds on the foundations covered in the Fast Track to Microsoft Access 2007. Learn about advanced data validation, split a database, optimise performance, and gain familiarity with Joins, Union Queries and Cartesian products. Instructors will teach participants about SQL syntax, security features, basic VBA commands, and other advanced features. At the completion of the formal sessions a workshop is conducted where the participants will be encouraged to use their own database model and ideas.

Who should do this course?

This course is designed for people who already have a good understanding of Microsoft Access, and need to upgrade their skills. Upon completion participants should be able to effectively design a secured, multi-user database.

Prerequisites

Students should have completed the FastTrack to Access 2007 course, or have equivalent practical knowledge, including database design, tables, queries, forms and reports.

Course Units

Unit 1: Using the Navigation Pane
- Tables and Related Views
- Navigation Pane Objects
- Custom Groups
Unit 2: Validating and Standardising Table Data
- Setting Default Values
- Defining Field Validation
- Requiring a Field to be Completed
- Adding Date Picker to Date Fields
- Using Rich Text Formatting (Memo Fields)
- Table Validation Rules
Unit 3: Setting Table Relationships
- Locating Orphan Records
- Cascading Updates and Deletes
- Join Types
Unit 4: Introducing Access SQL
- Commonly used SQL Keywords
Unit 5: Advanced Select Queries
- Using Left
- Using Mid
- Using the LEN Function
- Using IIF Functions
- Using LCASE Functions
- Using TRIM Functions
Unit 6: Action Queries
- Make Table Queries
- Update Queries
- Append Queries
- Delete Queries
- Action Query Workflow Example
- Maintaining Record History via Append Only Memo Fields
Unit 7: Aggregate Queries
- Grouping Data
- Adding Criteria to Aggregate Queries
Unit 8: Cross Tab Queries
- Creating CrossTab Queries
- Modifying a CrossTab
Unit 9: Using Pivot Table in Access (And Via Excel)
- Creating Pivot Tables Within Access
- Using Access Pivot Tables
Unit 10: Introducing Access Macros and VBA
- Just what is a Macro?
- Macro Review
- Creating and Editing Macros
- Enhancing Macros with TempVars
- Adding Conditions to Macros
- Introducing Access VBA
- Adding Conditions to Macros
- Introducing Access VBA
Unit 11: Advanced Form Design
- GUI Design
- Designing a Standardised User Interface Model
- Working with Form Filters
- Validating Form Data
- Cascading Combo Boxes
Unit 12: Designing with Layout View
- a Quick Look at Layout View
- Creating a Form Using the Quick Form Tool
Unit 13: : Advanced Reports
- NoData Event
- Show/Hide Report Sections based on User Selections
- Add Running Sums to Report Sections
- Add a Watermark to a Report
Unit 14 : Reporting Systems
- Reviewing Methods to Run Reports
- A Fully Featured Reporting Module
Unit 15 : Database Security
- Logging Users into the System
- Restricting User Access to Design Elements
- Converting to ACCDE Format
Unit 16 : Splitting the Database
- Why Split a Database
- Using the Database Splitter
- Relinking Tables
- Manually Linking and Using Multiple Linked Table

Upcoming Courses

Sydney

Level 11, 32 Walker Street
North Sydney
View map

Date:
20-21 Sep 10
16-17 Dec 10

Melbourne

Level 12, 379 Collins Street
Melbourne
View map

Date:
08-09 Nov 10

Brisbane

C/- Training Choice, Mezzanine Level, 88 Creek Street
Brisbane
View map

Date:
23-24 Sep 10
20-21 Dec 10

Canberra

C/- Training Choice, Level 4, 54 Marcus Clarke Street
Canberra
View map

Date: upon demand

Adelaide

C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map

Date: upon demand

Perth

C/- Training Choice, Level 7, 105 St Georges Terrace
Perth
View map

Date: upon demand
 

$880 incl GST

Duration: 2 Days

Class Size: 10

Level: Advanced

Times: 9.00am - 5.00pm approx

 
Man and woman sitting at a computer SEEK logo