Book your Access 2007 Level 2 Training Course
This one day course is being run ten times between Friday 9th March 2012 and Wednesday 8th August 2012 in London, Glasgow, Birmingham, Manchester, Leeds,
Book this course with us today from as little as £220.50 + 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.
See all courses provided by QAExpert 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 | Location | Rating | Price | ||
|---|---|---|---|---|---|
| Friday 09 March 2012 | London |  | Save £24.50 | £220.50+VAT | |
| Monday 19 March 2012 | Glasgow | | Save £24.50 | £220.50+VAT | |
| Wednesday 04 April 2012 | Birmingham | | Save £24.50 | £220.50+VAT | |
| Wednesday 25 April 2012 | Manchester | | Save £24.50 | £220.50+VAT | |
| Monday 14 May 2012 | London | | Save £24.50 | £220.50+VAT | |
| Friday 06 July 2012 | Leeds | | Save £24.50 | £220.50+VAT | |
| Monday 09 July 2012 | Glasgow | | Save £24.50 | £220.50+VAT | |
| Monday 16 July 2012 | London | | Save £24.50 | £220.50+VAT | |
| Thursday 19 July 2012 | Birmingham | | Save £24.50 | £220.50+VAT | |
| Wednesday 08 August 2012 | Manchester | | Save £24.50 | £220.50+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!
Download Course OutlineSummary:
In this course, you will consider how to maintain data consistency, how to customise database components, and how to share Access data with other applications. You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications.
PreRequisites:
To ensure the successful completion of Microsoft Office Access 2007: Level 2, the completion of the Microsoft Office Access 2007: Level 1 course or equivalent knowledge is recommended.
Audience:
Microsoft Office Access 2007: Level 2 is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program.
Objectives:
Upon successful completion of this course, students will be able to:
- modify the design and field properties of a table to streamline data entry and maintain data integrity.
- retrieve data from tables using joins.
- create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.
- enhance the capabilities of a form.
- customize reports to organize the displayed information and produce specific print layouts.
- share Access data across other applications.
Lesson 1: Controlling Data Entry
- Topic 1A: Restrict Data Entry Using Field Properties
- Topic 1B: Establish a Pattern for Entering Field Values
- Topic 1C: Create a List of Values for a Field
Lesson 2: Joining Tables
- Topic 2A: Create Query Joins
- Topic 2B: Join Unrelated Tables
- Topic 2C: Relate Data Within a Table
Lesson 3: Creating Flexible Queries
- Topic 3A: Set Select Query Properties
- Topic 3B: Create Parameter Queries
- Topic 3C: Create Action Queries
Lesson 4: Improving Forms
- Topic 4A: Design a Form Layout
- Topic 4B: Enhance the Appearance of a Form
- Topic 4C: Restrict Data Entry in Forms
- Topic 4D: Add a Command Button to a Form
- Topic 4E: Create a Subform
Lesson 5: Customising Reports
- Topic 5A: Organise Report Information
- Topic 5B: Format the Report
- Topic 5C: Set Report Control Properties
- Topic 5D: Control Report Pagination
- Topic 5E: Summarise Report Information
- Topic 5F: Add a Subreport to an Existing Report
- Topic 5G: Create a Mailing Label Report
Lesson 6: Sharing Data Across Applications
- Topic 6A: Import Data into Access
- Topic 6B: Export Data
- Topic 6C: Analyse Access Data in Excel
- Topic 6D: Export Data to a Text Filr
- Topic 6E: Merge Access Data with a Word Document
Description:
In this course, you will consider how to maintain data consistency, how to customise database components, and how to share Access data with other applications. You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2007 with other applications.
QA
QA training has over 25 years of experience of supplying high standard training courses in many Business, Management and IT Technical areas. Since 1983 the company has grown to have 25 training centres across the UK offering businesses routes to advance on a local and national level.
QA have a dedicated team of permanent instructors and teaching consultants who constantly improve the courses to ensure the highest possible standard of training is available.
Want to leave your own testimonial? click Here
No Testimonials have been left for this course.