Book Online: Login | Register

1300 658 388

Search form

 

 

This Access 2007 Advanced course is running in Sydney and Melbourne. You will learn how to fine-tune queries and reports to extract very specific information from your databases. You will also learn how to insert calculations in forms, create charts and write macros and VBA code to perform routine tasks and procedures.

Course Price (inc GST where applicable): 
$900.00
Locations: 
Sydney, Melbourne
Duration: 
2 days
Versions: 

2007

You'll Learn how to: 
  • Create action queries
  • Use advanced queries
  • Customise forms
  • Perform calculations within forms
  • Create reports
  • Use macros to automate repetitive tasks
Course Content: 

Review of Database Concepts

The database objects
Database concepts
Database elements/objects
Database design

Table Relationships

Analysing and establishing table relationships
Creating table relationships in the relationships window
Referential integrity
Enforcing referential integrity and setting cascade update related fields.
Deleting an existing relationship

 

Parameters and Expressions

Parameter queries
Wildcards in parameter queries
Parameter queries with multiple criteria
Expressions in queries
The expression builder
The FORMAT function
The DATEDIF function
The IIF function
Totals and grouping in queries

Queries by Form and Crosstab Queries

Queries by form
Crosstab queries
Customising the crosstab query design

Action Queries

Action queries
Make-table action query
Delete action query
Append action query
Update action query

Customising Reports

Creating a report using the report wizard
Report and control properties
The field list
Sorting reports
Grouping reports
Group on, group interval and keep together group properties
Functions in reports

Customising Forms

Creating a main/subform using the form wizard
Form controls and properties
Command button controls
Tab control
Form properties
Tab order

Expressions in Forms

Calculations in expressions
Expressions referring to controls or control properties
Expressions referring to the column property of a list box or combo box
Eexpressions combining text and field values

Macros

Creating macros
Macro groups
Creating macros in a macro group
Running macros
Conditional macros
Validating data macros

This Course Suits: 

This course will suit you if you need to fine-tune queries and reports to extract very specific information from your databases and insert calculations in forms, create charts and write macros and VBA code to perform routine tasks and procedures

Prerequisites: 

Successful completion of TP3 Access 2007 Introduction course or equivalent knowledge and skills.

The Learning Process: 
Preparing to learn
Get the most out of your course by preparing before you attend. TP3 provide pre-course materials that enable you to reflect on and align your learning outcomes with the course content.
After the course
TP3's online Learning Resources contains additional tools and resources to help you consolidate and continue your learning. For more details, click here.
Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon