Book your Microsoft Access 2007 Advanced Training Course
This one day course is being run three times between Friday 25th May 2012 and Wednesday 30th May 2012 in Reading, London, Manchester,
Book this course with us today from as little as £217.55 + VAT and with our price guarantee you can be confident of getting great value. Our team of experienced independent booking administrators will make the joining process painless and by providing feedback on your experiences you’ll also influence the Coursebookers independent course ratings.
Expert Help
If you would like
advice, or to book, call
one of our experts on
Open: 9am - 5:30pm
Monday- Friday
Locations/dates for this course
| Date | Provider | Location | Rating | Price | ||
|---|---|---|---|---|---|---|
| Friday 25 May 2012 | Activia | Reading |  | Save £11.45 | £217.55+VAT | |
| Friday 25 May 2012 | Activia | London | | Save £11.45 | £217.55+VAT | |
| Wednesday 30 May 2012 | Activia | Manchester | | Save £11.45 | £217.55+VAT |
|
|
Book your course now with Coursebookers!
Making an enquiry to Coursebookers couldn't be easier, just fill out the form to the left or call 01920 460232 and our team will be in touch within 48 hours.
Remember:
- Not only are we great value, we can also boast no booking fees
- Human administrators make booking & coordination simple and painless
- Coursebookers is vendor neutral we can offer unbiased and independent advice
- If you have complex booking requirements we're happy to help! Call our team on 01920 460232 to discuss your needs
- We ensure all our courses meet our high standards, meaning you'll only ever see "the best of the best" on Coursebookers!
Summary:
Microsoft Access 2007™ is a powerful prgramme designed to make storing your
information safely and securely a breeze. This course will give you the lowdown on
all the useful features, shortcuts and techniques to make data retrieval easy and
accurate.
Audience:
Users with a fair understanding of Access who would like to explore the advanced
features and what's new in Access 2007™. This course is an excellent follow up for
delegates who have been on the Introduction to Microsoft Access 2007™.
Objectives:
You'll learn a wealth of new techniques for manipulating information and the
database that will make your life simpler, save you hours and enable you to do
precisely what you want with Access 2007™.
Outline:
- What's new in Access 2007™
- Creating relational databases
- Database normalising
- Adding referential integrity
- Defining data entry rules
- Using input masks
- Setting a property and validation rule
- Using advanced query features
- How to join a table in queries
- Creating a calculated field and advanced queries
- Summarise and group values
- Creating advanced form design
- Working with graphics, calculations and combo boxes
- Working with unbound controls
- Work with sub-reports
- PivotTables and PivotCharts
- Creating advanced forms and subforms
- Automating data entry
- Creating advanced macros
- Use AutoKeys and AutoExec macros
- Exploring Access SQL
- Work with hyperlink fields
- Work with data access pages
- Secure data by database replication
- Protect databases
Description:
Microsoft Access 2007™ is a powerful prgramme designed to make storing your
information safely and securely a breeze. This course will give you the lowdown on
all the useful features, shortcuts and techniques to make data retrieval easy and
accurate.
Activia
Activia Training have been in the business for more than 15 years and their reputation as specialists in Microsoft, Sage and Adobe training courses is highly regarded in the industry. The cornerstone of Activia Training’s success is that they can form friendly, supportive relationships with their clients and their commitment to provide total satisfaction at all times.