Downloadable Course Outline 
|
Access 2010 Advanced Training Course
This third and final course in the Access 2010 series, really helps tie the previous two courses up and elevate Access skills to an expert level.
Topics covered in this course include, SQL statements, crosstab queries, macros, data validation, importing and database maintenance.
This dynamic training course is available now throughout Australia, including Brisbane, Sydney, Melbourne, Adelaide, Canberra and Perth.
|
|
OUTCOMES
By the end of this training course, participants will:
- Write SQL statements
- Create aliases for fields
- Attach a SQL query to a control in a form
- View a crosstab query and use the Crosstab Query Wizard
- Create single-criterion & multiple-criteria parameter queries
- Use action queries to append, delete & modify records
- Create and run macros
- Attach macros to events and command buttons in forms
- Create data validation, data entry, & user-input macros
- Use the Query Wizard & Design view to create joins
- Export & import XML documents
- Link database objects
|
- Analyse database performance
- Split a database
- Compact, repair & backup a database
- Assign & remove passwords & encryption
- Open a database in exclusive mode
- Configure Access options
- Populate database file properties
Course Length:
1-day
|
Why our clients choose us:
- Receive practical tools to take away with you.
- Be involved all day. There are about 20 activities each day (10 lessons with 1-3 activities per lesson).
- Realistic and relevant. We take the time to learn about you, then tailor the training to your needs.
Looking for death by Powerpoint? You will need to call another training company!
|
|
View the scheduled classes tab for a class near you or
Call now to discuss a cost-effective, tailored class at your workplace.
1300 121 400
|
|
|
OUTLINE
Microsoft Access 2010 Advanced Training Outline
Downloadable Course Outline
Foreword:
This Access 2010 Advanced training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2010: Intermediate.
Participants will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimise, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.
This course will help participants prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Access 2010.
Prerequisites:
Access 2010: Intermediate or equivalent experience.
|
Access 2010 Advanced Training Course - Lesson 1
Querying with SQL
- SQL and Access
- Writing SQL statements
- Attaching SQL queries to controls
|
Access 2010 Advanced Training Course - Lesson 2
Advanced queries
- Creating crosstab queries
- Creating parameter queries
- Using action queries
|
Access 2010 Advanced Training Course - Lesson 3
Macros
- Creating, running, and modifying macros
- Attaching macros to the events of database objects
|
Access 2010 Advanced Training Course - Lesson 4
Advanced macros
- Creating macros to provide user input
- Creating macros that require user input
- Creating the AutoKeys and AutoExec macros
- Creating macros for data transfer
|
Access 2010 Advanced Training Course - Lesson 5
Importing, exporting, and linking objects
- Importing objects
- Exporting objects
- Working with the XML documents
- Linking Access objects
- Using hyperlink fields
|
Access 2010 Advanced Training Course - Lesson 6
Database management
- Optimising resources
- Protecting databases
- Setting options and properties
|
|
Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.
|
| IN-HOUSE TRAINING |
|
|
'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
You'll be surprised at the price - check now! |
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...
|
|
1. We really listen
We take the time to understand your needs and goals
|
2. Flexible delivery
We always tailor the course to suit your needs
|
3. The best trainers
We only provide the best trainers and the best courseware
|
|
Most importantly the participants 'love' pdtraining courses because our courses are:
- Practical - 20% theory:80% practical - everyone will be constantly involved and engaged.
- Very interactive - our trainers facilitate people sharing and learning from each other's experience
- Applicable on the job - we are all about skills and techniques you can actually use!
- Fun - we help people enjoy learning because courses should be fun! Also people are more likely to implement what they learn if they enjoyed the learning experience.
- Delivered by a fantastic trainer - we only use the best, engaging expert trainers
We believe you learn more when you're having fun!
|
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
|
 |
The top 5 reasons participants 'love' pdtraining
- 20% theory:80% practical - everyone will be constantly involved and engaged.
- Lots of collaboration - our trainers facilitate people sharing and learning from each other's experience
- Applicable on the job - we are all about skills and techniques you can actually use!
- Fun - we help people enjoy learning because courses should be fun! Also people are more likely to implement what they learn if they enjoyed the learning experience.
- Delivered by a fantastic trainer - we only use the best, engaging expert trainers
Yes! this is the right choice for me! 
|
Don't take our word for it: testimonials
Cost:
$413 inc gst per person
Length
1 - day high-energy class
Course venues:
Sydney
Level 1
111 Harrington Street
Sydney
NSW 2000
View Map
|
Melbourne
123 Queen Street
Melbourne
VIC 3000
View Map
|
Brisbane
Unit 11
121 Newmarket Road
Windsor Brisbane
QLD 4030
View Map
|
Adelaide
International Visualisation Centre
19 Young Street
Adelaide
SA 5000
View Map
|
Perth
Perron House
61 Kitchener Avenue
Victoria Park Perth
WA 6000
View Map
|
Canberra
Manuka Oval
Manuka Circle
Canberra
ACT 2603
View Map
|
 Times
Public classes start at 9.00am and finish around 4.30pm.
Class Size
Public classes will be a small relaxed group of between 4 and 12 people.
The small group helps ensure that everyone will gets a chance to ask questions and learn at their own pace.
What is provided?
All participants will be provided with morning tea, afternoon tea, printed bound courseware to keep and an Access 2010 Advanced Certificate of Completion. Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.
|
|
Access 2010 Advanced Training Courses are delivered by pdtraining's Access 2010 Advanced Training specialists and counsellors in Brisbane, Sydney, Canberra, Melbourne, Adelaide, Perth and Australia wide.
|
|
