Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
Courses    
  Most popular search | Share this page  
open My list: 0 courses
Homepage IT, Computing, Telecommunications Courses Database Administration Courses Access Courses

Access Database Design 1

in Pass training (England)

Classes Training

Place:

London

Price:

£220 + VAT Special offers 

Duration:

1 Day

Start:

20/01/2009 other dates
See course programme

Requirements:

Familiarity with the basic features of Access is required, gained either by previous experience or ... see more

Request free information
Pass trainingPass trainingPass training
training room Chalk Farm
More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
Pass training
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 Training Duration 1 Day
Method / place Contact course provider Classes in London where
Suitability This course is suitable for existing users of Access who want to get to grips with some of the more advanced features of this package as quickly as possible.
Course objectives To give users additional skills and knowledge on using the many features and functions of Access to make them more efficient and effective when processing data. Delegates will gain experience in producing database applications and the ability to create a variety of data views, queries and reports.
Requirements
Familiarity with the basic features of Access is required, gained either by previous experience or by attendance on an "Access Data Processing" course.
Price £220 + VAT
Special offer + Support + Price details
Request this special offer here
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Microsoft Access: Database Design
Media Training
London - Price: On request
 
Access Intermediate
Major Training Ltd
London - £220 + VAT
 
Access XP Fundamentals
2e2 Training
London - £450 + VAT
 
Introduction to Microsoft Access
Reed Learning
London - £495 + VAT
 
Microsoft Access 2007 Level 1
WWP Training Limited
London - £450 + VAT
Compare the selected courses

Course programme

Access Database Design 1
Access – database design
(Part 1- intermediate/advanced)
 Course outlines
Database Design
   What is a Relational Database?
   Primary and Foreign Keys  

Relationships
Database Normalisation 
Theory Of Normal Forms
De-Normalisation
Naming Conventions
Designing Table Structures
 Table Design - Hints And Tips
Creating Tables
Switching between views
Saving Tables
Field Properties
Field Size Property
Format And Input Mask Properties
Caption Property
Allow Zero Length Property
Indexed Property 
Using Field Properties For Protection 
Objectives
Required
Default Value
Input Mask
Validation Rule And Validation Text
Lookups
Table Relationships
What Is A Relationship?
Relationship Types
Creating And Editing Relationships
Using Lookups For Referential Integrity
Multi-Table Datasheet View
       Price £220+VAT
 Queries 
Multi-Table Queries
Calculated Fields
Adding A Calculated Field To A Query
The Expression Builder
Calculating Summary Information
Crosstab Queries
General Query Properties
Checking Referential Integrity
Advanced Queries
Parameter Queries
Formatting Query Output
Query Join Types
Self Joins And Aliases
Cross Joins
Action Queries
What Is An Action Query?
Planning An Action Query
Make Table Queries
Append Queries
Delete Queries
Update Queries
Importing, Exporting, And Linking Data
Importing From Other Data Sources
Linking Data
Exporting Data
Database Management Tools
Database Administration
Documenting The Database Structure
Backing Up And Restoring A Database
Compacting And Repairing
A DatabaseSetting A Database Password
Encrypting And Decrypting A Database
 
 
 
 
 
 
 
 
 
see the full course programme

on request

get more information on the programme directly from Pass training.

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

Venues and dates



Where London, 100a Chalk Farm Road
When Start: 20/01/2009 Finish: 20/01/2009 See calendar
 
Where London, 100a Chalk Farm Road
When Start: 18/02/2009 Finish: 18/02/2009 See calendar
 
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 Pass training

Provider description
Pass training have been providing excellence in training for over 21 years. From Computer training to Personal Development and CPD for Accountants, pass training covers a wide range of courses. IT Training computer courses are all fully Microsoft certified to a gold standard and last between one and two days per skill level. They are aimed at teaching delegates features relevant to their jobs to enhance knowledge of the software and to maximise efficiency in the workplace. With no fewer then 37 different Computer courses you are almost guaranteed to find what you are looking for.Personal Development courses cover a variety of essential core skills.With over 80 courses to choose from you are spoilt for choice.From Appraisal interviewing to Stress; Thrive under pressure, pass training offers a wide variety of practical courses aimed at developing individuals and teams. All courses also incorporate their own discount structure based upon fees and quantity of bookings. Why not book today?
Advantages of studying with Pass training
Microsoft Certified certificate of attendance on Microsoft courses, &also get training manuals& a USB stick to record the days training to be recalled at home or back in the office. Regarding the CPD candidates, they will receive CPD points for computer courses as well as CPD courses to count towards their end of year total.Pass training have experienced&reliable trainers,constantly learning more so that you are at the fore front of each technical area. Pass also benefit from trainers that have real life experience,&so can truly go into great depth & detail to which you wish to know, even if it is not on the course syllabus. Trainers are carefully selected so we can ensure that they are not only great trainers, but approachable&easy to talk to also. Within this process we can supply professional,affordable,practical,intelligent, relevant training that will really help individuals&teams develop & grow as separate entities & also team entities for the greater good of all concerned.
Course provider history
Pass training have been established for over 21 years, and training in IT Computing, Personal Development and CPD. Pass training was set up as the training division for what is now Vantis Plc, and originally trained in the CPD for accountants with updates and topical courses. Pass training's computer training has its own established training rooms, with top of the range computers to enhance the learning experience. Whilst the Personal Development is headed by dynamic and charismatic team of individuals who inspire confidence and a well balanced learning environment by not only lecturing technique, but allowing active participation and practical situations to put what you are learning into immediate practise. Across the board Pass training are well known for interactive, dynamic and cost effective training, with a ruthless reputation for efficiency and customer satisfaction. This is why we are the correct and logical choice for so many, and are dedicated to encouraging you to join too.
Specialises in
Pass training specialise in Accountancy Software training, as well as Microsoft Office courses such as Excel and Word. We also have the benefit of expert lecturers who know how to interact and bring the best out of our PD courses, whilst boasting experienced up to date presenters for our CPD course both in updates and topical courses. It is by combining these fields with the best of experience and knowledge that we can bring you the very best learning experience to affect your working life in a positive way, and keep customers returning for this unique and refreshing training experience.

All courses

by Pass training on emagister.

See list of courses

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

Training related to Access

 
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