Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
  Most popular search | Share this page  
open My list: 0 courses
autocad 2007   office management course   office management courses   nvq 3 health and social care   office manager course   itq level 3   nvq level 3 courses   itq level 2   office manager courses   nvq level 3 health and social care
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › Access Courses

Microsoft Office Access 2007 Level 3

in PTR Associates Ltd (England)

Classes Course

Price:

£250 + VAT

Duration:

1 Day

Start:

consult dates and times
See course programme

Requirements:

Studenets should have attended or have equivalent knowledge of the following courses: Microsoft ... see more

Request free information

Course objectives:

In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. This course is for the individual whose job responsibilities include working with related ta...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 1 Day
Method / place Contact course provider Classes
Course objectives In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. This course is for the individual whose job responsibilities include working with related ta...
Requirements
Studenets should have attended or have equivalent knowledge of the following courses: Microsoft Office Access 2007 Level 1 Microsoft Office Access 2007 Level 2.
Price £250 + VAT
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Access Intermediate
CTS - Computer Training Solutions
Berkshire - £250 + VAT
 
Microsoft Access 2003 - Proficient Level to Expert User
focus4training
Online - £24 + VAT
 
Access 2007 Training
UK Open Learning Ltd
Multimedia - £195 + VAT
 
Microsoft Access 2007 Level 2
WWP Training Limited
Berkshire - £450 + VAT
 
Introduction to Microsoft Access
DS Data Training
Berkshire - Price: On request
Compare the selected courses
+ access Courses + Access Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

Microsoft Office Access 2007 Level 3
Course objectives:
In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

This course is for the individual whose job responsibilities include working with related tables, creating advanced queries, forms, and reports, writing macros to automate common tasks, and performing general database maintenance. It is also designed as one in a series of courses for students pursuing the Microsoft Office Specialist Certification for Microsoft Office Access 2007, and it is a prerequisite to take more advanced courses in Microsoft Office Access 2007.

On completion of the course students will be able to:
  • restructure the data into appropriate tables to ensure data dependency and minimize redundancy.
  • write advanced queries to analyze and summarize data.
  • create and revise Access macros.
  • display data more effectively in a form.
  • customize reports by using various Access features, thus making them more effective.
  • maintain your database using tools provided by Access.


    Course content:
    Structuring Existing Data
  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure
    Writing Advanced Queries
  • Create Subqueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
    Simplifying Tasks with Macros
  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
    Making Effective Use of Forms
  • Display a Calendar on a Form
  • Organize Information with Tab Pages
  • Display a Summary of Data in a Form
    Making Reports More Effective
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Create a Report Snapshot
    Maintaining an Access Database
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database
    Appendix A: Microsoft Office Specialist Program
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...

    Training related to Access

    More related courses
    Microsoft Access Introduction £300 + VAT Distance
    Access 2002 £75 + VAT Online
    + access Courses + Access Courses in Berkshire + PTR Associates Ltd Courses
     

    Most searched for in Access

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses Access | Courses Database Design | Courses Database training | Courses Microsoft Access XP | Courses Microsoft Office
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: microsoft office database design microsoft office specialist
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights