OUTCOMES

By the end of this training course, participants will:

• Use advanced table tasks
• Use advanced form tasks
• Use advanced reporting tasks
• Understand database relationships
• Use advanced query tasks
• Work with SQL
• Link data
• Import data
• Export data
• Use advanced database tools

Course Length:

1-day

OUTLINE

Microsoft Access 2007 Advanced Training Outline

Download a Course Outline 

Foreword:

This workshop is designed to teach you a deeper understanding of Access 2007 in a practical way. You will learn how to use the advanced features of Access to help you better manage your database. This workshop incorporates a hands-on approach to learning. You will get both teaching and a chance to practice some of the advanced features right on a computer.

This workshop is meant to provide a safe learning environment where you can practice and learn Access 2007 advanced functions without worrying about making mistakes. Making mistakes is a part of learning and is expected in this workshop. Taking the time to learn the advanced features of Access 2007 will increase your knowledge on how databases work and make creating and managing an Access 2007 database easier for you.

Who Should Attend?

Anyone that wants to quickly learn to build and manage databases in Microsoft Access.

• Workshop Objectives

• Using the Property Sheet
• Adding, Moving & Removing Controls
• Formatting Controls
• Setting the Primary Key

• Creating a Subform
• Creating a split-form
• Creating a Modal Dialog
• Creating a Pivot Table

• Using Report Sections
• Grouping and Sorting Data
• Adding Calculated Controls
• Creating Labels

• Types of Relationships
• Viewing Relationships
• Editing Relationships
• About Referential Integrity
• Establishing Referential Integrity

• Sorting & Filtering a Query
• Adding Calculated Fields
• Using the Expression Builder
• Using Logical Functions

• What is SQL?
• Understanding SQL Statements
• Basic SQL Syntax
• Uses for SQL in Access

• Linking to an Excel Spreadsheet
• Linking to an Access Database
• Linking to a Sharepoint List
• Linking to a Text or XML File
• Other Types of Links

• Importing from an Excel Spreadsheet
• Importing from an Access Database
• Importing from a Sharepoint List
• Importing from a Text or XML File
• Other Types of Imports

• Saving an Object as PDF
• Exporting to an Excel Spreadsheet
• Exporting to a Word Document or Text File
• Other Types of Exports

• Using the Database Documenter
• Analysing Table Performance
• Analysing Database Performance
• Compact & Repair a Database

• Words From the Wise

Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.

'your place or ours'

In-House training benefits:

• tailored to your needs and goals
• cost effective - from $140 per person (full day)
• you choose the day, place and time
• greatest impact in the shortest time
• tailoring ensures practical tools directly applicable to your workplace
• great team building opportunity
• more convenient, people don't need to go off-site

Ph: 1300 121 400

Tailored Delivery - standard

We will always tailor the delivery of your In-House Training course to ensure it is relevant to your team, and targeted at your learning goals. We can incorporate your company's examples and terminology to ensure you the training can be directly related back to your workplace. This is standard, and included in the price.

Your delivery options

We offer a range of different class types to suit your operational needs.

	The "1-hour Motivator" training sessions These 60-90 minute sessions are highly motivating and thought provoking - ideal for those people who need to fit training in around a busy work schedule - great as an early morning kick-start or lunch time boost! Read more...
	The "3-hour Power" sessions 3-hour power sessions – are a great solution when you have very specific outcomes you are targeting, or scheduling the team to be off the job for a whole day is proving to be a challenge Read more...
	Full-day short courses 1-2 day short courses delivered with a unique focus on 80% activities 20% content – just the way learning should be! Read more...
	Conferences and workshops Do you want your conference to be memorable, fun, interactive and have a real highlight? pdtraining's dynamic trainers can add that flair, excitement and much much more! Read more...

Q: Who else uses Professional Development Training?

A: Take a look at some of our recent clients

Q: Are they Happy?

A: This is what they say about us testimonials

Questions?

Email:  This e-mail address is being protected from spambots. You need JavaScript enabled to view it  or

Phone: 1300 121 400

Scheduled Access 2007 Advanced Training Courses
Classes fill up fast - click a date to enrol now!

Questions?

Email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it  or
Phone: 1300 121 400