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

Microsoft Access: Database Design

in Media Training (England)

Classes Course

Place:

London

Price:

Duration:

On request

Start:

consult dates and times
See course programme

Request free information

Course objectives:

This practical two day course is designed for those who need to create relational databases using Microsoft Access. The course covers how to plan, design and create a database to a detailed brief. You will learn to create different layouts, summarise information and produce reports. This course is run as a private course in order to tailor the content to your exact...

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
Media 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 Course Duration On request
Method / place Contact course provider Classes in London where
Course objectives This practical two day course is designed for those who need to create relational databases using Microsoft Access. The course covers how to plan, design and create a database to a detailed brief. You will learn to create different layouts, summarise information and produce reports. This course is run as a private course in order to tailor the content to your exact...
Price Ask
the
course provider
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Access Database Design 1
Pass training
London - £220 + VAT
 
Advanced Microsoft Access
Reed Learning
London - £275 + VAT
 
Access VBA
Nobleprog Limited
London - £840 + VAT
 
Access 2003 Specialised
2e2 Training
London - £450 + VAT
 
Access Introduction
Major Training Ltd
London - £220 + VAT
Compare the selected courses

Course programme

Microsoft Access: Database Design
Course Overview

This practical two day course is designed for those who need to create relational databases using Microsoft Access.

The course covers how to plan, design and create a database to a detailed brief. You will learn to create different layouts, summarise information and produce reports. This course is run as a private course in order to tailor the content to your exact requirements.

Feel free to build a new database during the course or work on an existing database if you wish.

Course content

Database design concepts
· Planning a database
· Drawing up a database design
· Checking function meets need

Building components
· Using tables
· Relationships
· Meeting normal forms' rules
· Using forms

Designing Queries
· Parameter queries
· Action queries
· Query joins
· Crosstab queries

Advanced form techniques
· Organising field placement
· Using functions to control data entry
· Adding an option group
· Using a form as a user interface
· Creating a sub-form

Creating macros to use with forms
· Macro introduction
· Attaching a macro to a command button
· Editing a macro
Macros that add user interaction and automation
· Macros to automatically enter data
· AutoKeys and AutoExec macros

Reporting
· Designing reports
· Editing reports
· Adding functionality to reports

Switchboards
· Creating a switchboard
· Controlling database startup properties

Creating a splash screen
· Using a form as a splash screen
· Automating the splash screen

Database security
· End-user level security
· Password security

Questions and answers
see the full course programme

on request

get more information on the programme directly from Media Training.

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

Venues and dates



Where London, Studio 14, Aberdeen Studios, 22 Highbury Grove see map
When Start: Ask the course provider
 
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...

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