Book your Access 2003 Level 2 Training Course
This two day course is being run 20 times between Monday 13th February 2012 and Thursday 13th September 2012 in London, Leeds, Reading, Birmingham, Milton Keynes, Edinburgh, Manchester, Glasgow,
Book this course with us today from as little as £400.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 | ||
|---|---|---|---|---|---|
| Monday 13 February 2012 | London |  | Save £44.50 | £400.50+VAT | |
| Thursday 16 February 2012 | Leeds | | Save £44.50 | £400.50+VAT | |
| Monday 12 March 2012 | London | | Save £44.50 | £400.50+VAT | |
| Monday 02 April 2012 | Reading | | Save £44.50 | £400.50+VAT | |
| Monday 02 April 2012 | Birmingham | | Save £44.50 | £400.50+VAT | |
| Tuesday 10 April 2012 | Milton Keynes | | Save £44.50 | £400.50+VAT | |
| Thursday 12 April 2012 | London | | Save £44.50 | £400.50+VAT | |
| Wednesday 18 April 2012 | Edinburgh | | Save £44.50 | £400.50+VAT | |
| Monday 23 April 2012 | Manchester | | Save £44.50 | £400.50+VAT | |
| Tuesday 08 May 2012 | Glasgow | | Save £44.50 | £400.50+VAT | |
| Tuesday 08 May 2012 | London | | Save £44.50 | £400.50+VAT | |
| Monday 18 June 2012 | Leeds | | Save £44.50 | £400.50+VAT | |
| Monday 18 June 2012 | London | | Save £44.50 | £400.50+VAT | |
| Monday 09 July 2012 | London | | Save £44.50 | £400.50+VAT | |
| Monday 16 July 2012 | Birmingham | | Save £44.50 | £400.50+VAT | |
| Wednesday 18 July 2012 | Manchester | | Save £44.50 | £400.50+VAT | |
| Monday 06 August 2012 | London | | Save £44.50 | £400.50+VAT | |
| Tuesday 14 August 2012 | Edinburgh | | Save £44.50 | £400.50+VAT | |
| Thursday 16 August 2012 | Leeds | | Save £44.50 | £400.50+VAT | |
| Thursday 13 September 2012 | Glasgow | | Save £44.50 | £400.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:
As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.
PreRequisites:
To ensure the successful completion of Microsoft Access 2003: Level 2, we recommend completion of the following courses, or equivalent knowledge (basic familiarity with Access tables, relationships, queries, forms, and reports) from another source : · Microsoft Access 2003: Level 1
A basic understanding of Microsoft® Excel and Microsoft® Word would also be helpful, but is not required.
Audience:
Microsoft® Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft® Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft® Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.
Objectives:
You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications.
Lesson 1: Planning a Database
- Topic 1A: Design a Relational Database
- Topic 1B: Identify Database Purpose
- Topic 1E Group Fields into Tables
- Topic 1F: Normalize the Data
- Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
- Topic 2A: Create a New Database
- Topic 2B: Create a Table Using a Wizard
- Topic 2C: Create Tables in Design View
- Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
- Topic 3A: Restrict Data Entry with Field Properties
- Topic 3B: Create an Input Mask
- Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
- Topic 4A: Find Data with Filters
- Topic 4B: Create Query Joins
- Topic 4C: Join Unrelated Tables
- Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
- Topic 5A: Set Select Query Properties
- Topic 5B: Create Parameter Queries
- Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
- Topic 6A: Enhance the Appearance of a Form
- Topic 6B: Restrict Data Entry in Forms
- Topic 6C: Add Command Buttons
- Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
- Topic 7A: Organize Report Information
- Topic 7B: Set Report Control Properties
- Topic 7C: Control Report Pagination
- Topic 7D: Summarize Information
- Topic 7E: Add a Subreport to an Existing Report
- Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
- Topic 8A: Publish Access Data as a Word Document
- Topic 8B: Analyze Access Data in Excel
- Topic 8C: Export Data to a Text File
- Topic 8D: Merge Access Data with a Word Document
Description:
As you begin this course, you should have the basic skills you need to work with a Microsoft® Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports.
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.