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 2002/3 - Creating Databases

in Laidlaw & Constable (England)

Classes Course

Place:

London

Price:

£440 + VAT

Duration:

1 Day

Start:

14/12/2008 calendar
See course programme

Requirements:

To fully benefit from this course, attendees are expected to be familiar with Windows and use of the ... see more

Request free information

Course objectives:

This hands-on course will provide delegates with a basic understanding of some of the major features and functions within Access and the advantages of using a relational database. On completion of the course delegates will be able to create working database tables, forms, queries and reports which will enable them to go on and produce their own database application.

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
Laidlaw & Constable
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 in London where
Suitability New or inexperienced users of Microsoft Access, those upgrading from a previous version of Access or migration from another relational database package wanting to create their own database applications
Course objectives This hands-on course will provide delegates with a basic understanding of some of the major features and functions within Access and the advantages of using a relational database. On completion of the course delegates will be able to create working database tables, forms, queries and reports which will enable them to go on and produce their own database application.
Requirements
To fully benefit from this course, attendees are expected to be familiar with Windows and use of the keyboard and mouse. Knowledge of a previous relational database package would be useful, although not essential. Attendees are expected to be confident users of Access and be familiar with the topics covered in the Access Queries & Reports course.
Price £440 + VAT
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

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

Course programme

Access 2002/3 - Creating Databases
Access 2002/3 Creating Databases
On completion of the course, delegates will be able to:

· Understand some elementary database theory
· Design and create a new database file in Access
· Design relational databases
· Create tables in a relational database
· Set table relationships in a database
· Create simple queries using more than one table
· Add calculated fields to queries
· Add parameters to queries to capture criteria data
· Use action queries to make tables, update, append and delete data
· Create and customise forms for data entry or data viewing in Access
· Create and customise reports
· Use the Switchboard Manager to create a menu system
· Export/import data between Access/Word/Excel
Database Theory & Design
Understanding Databases · How Access Stores Data · Database Planning/Design  · Documentation and Testing  · Create a New Database
Table Design
Field Names and Data Types  · Field Size  · Use Field Properties to Support Quality Data Entry · Use the Lookup Wizard  · Understand Primary Keys  · Use Indexing · Design Considerations for Linked Tables
Relationships
Types of Relationship  · The Relationship Window  · Define/Edit a Relationship  · Referential Integrity and Cascade Options  · Printing Relationships
Forms
Use the Form Wizard  · Add Labels/Lines/Boxes to Forms  · Arrange Form Objects  · Format Forms · Use Conditional Formatting  · Add Text Boxes for Calculated/LookedUp Information · Define a Form/SubForm Structure  · Create a Tabbed Form  · Form and Form Object Properties
Relational Queries
Define Multi-Table Select Queries  · Add/Modify Joins  · Adjust Join Properties  · Use Sorts/Filters · Include Calculations  · Create Parameter Queries  · Nested Queries  · Summary Queries · Hiding Query Fields  · Concatenate Data Strings
Reports
Reports Based on Tables and Queries · Report Sections  · Report Formatting · Grouped Reports  · Sorting & Grouping Properties  · Create Totals and Subtotals on Reports · Page Break Options
Action Queries
Make Table Queries · Update Queries · Append Queries · Delete Queries · Using Parameters in Expressions
Printing
Previewing Records/Forms/Reports · Changing Report Orientation/Paper Size · Printing the Entire Table/Form Records · Printing Query Output · Printing A Report/Specific Report Pages
Switchboard
Create a Switchboard  · Create Additional Menus  · Modifying the Startup Options
Export/Import Data
Export Data to Excel  · Import Data from Excel  · Import From Another Access Database
see the full course programme

on request

get more information on the programme directly from Laidlaw & Constable.

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

Venues and dates



Where London, Suite 501, Albany House, 324-326 Regent Street
When Start: 14/12/2008 Finish: 14/12/2008 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 Laidlaw & Constable

Provider description
About Laidlaw & Constable

In today's competitive global market place, the need for skilled people has become increasingly acute as companies seek to add value within the knowledge economy. As a company, we are committed to working with our clients to help harness and develop the personal skills of their staff. Our aim is to encourage individuals to fulfil their potential and maximise their efficiency.
Laidlaw & Constable's Mission Statement

Our Purpose
Laidlaw & Constable Ltd is a private limited company committed to providing high value training and consultancy services to organisations within the private, public and non-profit sectors. Our purpose is simple: it is to deliver practical, innovative training solutions and consultancy services designed to add value for our clients by helping develop one of their most important assets - their people.

Our Ethos
At Laidlaw & Constable a culture exists that encourages and promotes openness, originality and independent thought. Internally we strive to be an energetic and enthusiastic team that thrives on providing a high quality professional and flexible service. We endeavour to find innovative ways to meet our clients' requirements and put originality before traditional thought. We aim to work openly and honestly with all stakeholders to ensure the organisation and team work in a seamless and efficient manner - "together making it happen".

Our Vision
Our long-term vision is to:

* Raise our company profile to become a quality focused market leading provider in the training & consultancy sector.
* Create an environment, which is focused on continual improvement, engaged in evaluating and implementing best practice methods, business excellence and quality of service provision.
* Continually strive towards a culture of openness, creativity, honesty and integrity amongst all stakeholders.
* Create a professional working environment with training consultants confident to help our clients make positive lasting and substantial improvements to their company's performance.
* Build a great company that is able to attract, develop, excite and retain exceptional people.

Our Values
We will achieve our purpose by working in accordance with the following core values:

* Being Professional - we will listen to our clients and make every endeavour to understand, achieve and exceed their expectations. We will respond immediately and will always look for ways to improve what we do.
* Being Innovative and Creative - by encouraging fresh ideas, following them through and not being afraid to try something new.
* Adopting an Open and Sharing Culture - by being open and honest with all stakeholders and adopting an open-book approach to business. And by sharing information to create efficiency and developing effective business relationships
* Employing the Right People - by ensuring our team has the right skills and experience to say with confidence 'we know what we're doing'. By a commitment to training and developing our people.

All courses

by Laidlaw & Constable on emagister.

See list of courses

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

Training related to Access

More related courses
Access XP Fundamentals £450 + VAT London
Access 2007 Training £195 + VAT Multimedia
Advanced MS Access £395 + VAT London
MS Access Introduction £450 + VAT London
 
International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

Words related to the courses viewed: database design

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