Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Go to homepage The smart course guide
Courses    
Most popular search | Share this page  
open My list: 0 courses
Courses related: advanced excel course london advanced illustrator course btec advanced diploma msp advanced practitioner course btec advanced diploma in construction & surveying btec advanced diploma in surveying & estimating msp advanced practitioner access training plumbing btec advanced diploma in construction and surveying paramedic access course birmingham
Homepage > IT, Computing, Telecommunications > Database Administration > Access

Access Advanced

in CTS - Computer Training Solutions (England)

Classes Course

Place:

Bristol, Solihull,...

Price:

£250 + VAT

Duration:

1 day

Start:

16/07/2008 other dates
See course programme

Requirements:

Good working knowledge of Access and databases.

Request free information

Course objectives:

This course takes an extensive look at Microsoft Access, including query language, macros, converting, customising and managing databases.

CTS - Computer Training Solutions

Do your staff struggle when using Excel, Word or PowerPoint? Would you like to have more specialist skills in-house such as Adobe Photoshop, Illustrator or Dreamweaver? Or would you like to improve th...

Contact course provider

Request information

Contact directly and with no obligation with
CTS - Computer Training Solutions
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
I would like to receive information on similar courses.
By clicking "E-mail request / Telephone" you are accepting the Terms of Use and privacy policy similarly, you give express authorisation for the course provider to let us know whether you have enrolled on the course or not. Emagister will send you courses matching your profile for a 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:
:| :) ;)
Normal Fast Very fast

Course details

Type Course Duration 1 day
Method / place Contact course provider Classes in Bristol, Solihull,... where
Suitability Experienced Access database users.
Course objectives This course takes an extensive look at Microsoft Access, including query language, macros, converting, customising and managing databases.
Requirements
Good working knowledge of Access and databases.
Price £250 + VAT
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Access 2002
Sales 101 Ltd
Online - £75 + VAT
Guaranteed response
 
Access 2007 Training
UK Open Learning Ltd
Multimedia - £175 VAT inc.
Guaranteed response
Compare the selected courses
+ access Courses + Access Courses in Avon + Courses in Avon + CTS - Computer Training Solutions Courses

Course programme

Access Advanced
STRUCTURED QUERY LANGUAGE
• Writing SQL Commands
• Writing SQL Queries
• Writing SQL Subqueries
• Writing SQL Joins
• Inserting Data
• Updating Data
• Deleting Data
• Writing SQL Queries In Access 2003

WORKING WITH MACROS
• Automating Tasks
• Introducing The Macro Design Toolbar
• Creating Macros
• Testing And Debugging Macros
• Modifying Macros
• Conditional Programming In Macros
• Adding Macros To Forms
• Adding Macros To Reports
• Filtering Data
• Documenting Macros

USING DATA ACCESS PAGES
• Creating Data Access Pages
• Modifying Data Access Pages
• Sorting Data In Data Access Pages
• Summarising Data In Data Access Pages
• Editing Data In Data Access Pages
• Protecting Data In Data Access Pages

CONVERTING ACCESS DATABASES
• Converting Databases To Access 2003
• Converting From Access 2003 To Access 97
• Converting From Access 2003 To Access 2000

CUSTOMISING ACCESS 2003
• Configuring Access 2003 Options
• Configuring Autocorrect Options
• Customising Menus And Toolbars

MANAGING & MAINTAINING DATABASES
• Optimising Databases With Table Analyzer
• Optimising Databases With Performance Analyzer
• Documenting Databases With Documenter Analyzer
• Avoiding Errors With The Object Dependencies Task Pane
see the full course programme

on request

get more information on the programme directly from CTS - Computer Training Solutions.

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

Venues and dates



Where Bristol, Aztec Centre, Aztec West,
When Start: 16/07/2008 Finish: 16/07/2008 See calendar
 
Where Solihull, Central Boulevard, Blythe Valley Business Park
When Start: 16/07/2008 Finish: 16/07/2008 See calendar
 
Where Bracknell, Venture House, Arlington Square, Downshire Way
When Start: 06/08/2008 Finish: 06/08/2008 See calendar
 
Where Solihull, Central Boulevard, Blythe Valley Business Park
When Start: 13/08/2008 Finish: 13/08/2008 See calendar
 
Where Solihull, Central Boulevard, Blythe Valley Business Park
When Start: 17/09/2008 Finish: 17/09/2008 See calendar
 
Get direct information on how to enrol, venues and availability...

Course provider details

Description
Do your staff struggle when using Excel, Word or PowerPoint? Would you like to have more specialist skills in-house such as Adobe Photoshop, Illustrator or Dreamweaver? Or would you like to improve the efficiency of your staff? Computer Training Solutions (CTS) can provide you with the solution by providing excellent quality IT training for your staff. We aim to provide a partnership with our clients by establishing long-term relationships and becoming an extension of your development team. In order to do this we provide a complimentary consultation with a training manager to put together a tailored training plan to suit your needs. We are preferred suppliers to Nokia, Mothercare, Amey, RWE, Lloyds TSB and many more. Contact us on 0800 019 6882 to talk to a training consultant today!
Get direct information on how to enrol, venues and availability...

Information related to Access

Words related to the courses viewed: sql microsoft office
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