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
Courses related: intermediate life support | intermediate construction award | access courses london | access training plumbing | microsoft access course objectives | intermediate life support manchester | access 2007 training | microsoft office specialist distance learning | microsoft office courses | apm introductory certificate
Homepage IT, Computing, Telecommunications Courses Database Administration Courses Access Courses

Microsoft Access Introductory / Intermediate

in ITEC Integrations (Scotland)

Classes Course

Place:

Blantyre

Price:

Duration:

1 Day

Start:

consult dates and times
See course programme

Request free information

Course objectives:

This course is designed for delegates wishing to introduce a relational database system, or for those users who wish to enhance their knowledge of a Windows based database system. By the end of this course, delegates will be able to build a simple relational database.

ITEC Integrations

ITEC Integrations offer a wide ranging menu of Information Technology tailored training and support services, promoting the efficient use of desk-top PCs as office productivity tools. We provide a ...

see more

Contact course provider

 

Request information

Contact directly and with no obligation with
ITEC Integrations
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 Blantyre where
Suitability Delegates attending this course should be already working with an Access database and wish to expand their knowledge, or should be about to commence the development of a database. This course is unsuitable for those delegates who will only be performing data entry into a database.
Course objectives This course is designed for delegates wishing to introduce a relational database system, or for those users who wish to enhance their knowledge of a Windows based database system. By the end of this course, delegates will be able to build a simple relational database.
Price Ask
the
course provider
Get direct information on how to enrol, venues and availability...

Access courses (from other course providers)

 
Microsoft Access Specialised
Etopia Solutions
Glasgow - £450 + VAT
 
Microsoft Access Introduction
Prolog Training
Distance - £300 + VAT
 
Microsoft Access 2003 - Proficient Level to Expert User
focus4training
Online - £24 + VAT
 
Access 2002
Sales 101 Ltd
Online - £75 + VAT
 
Access 2007 Training
UK Open Learning Ltd
Multimedia - £195 + VAT
Compare the selected courses

Course programme

Microsoft Access Introductory / Intermediate
Microsoft Access Introductory / Intermediate Topics Covered:
Database design and table creation
  • Design and document your database
  • Basic design rules
  • Determine relationships
  • Creating a database
  • Using the table wizard
  • Adding fields using the table wizard
  • Creating a table without a wizard
  • Adding fields to a new table
  • Field properties
  • The input mask property
  • Setting a primary key
  • Saving a table
  • Adding records to a table datasheet
Formatting a table
  • Editing records
  • Selecting records with the mouse
  • Selecting records using the keyboard
  • Selecting fields with the mouse
  • Selecting columns using the mouse
  • Selecting using the keyboard
  • Deleting records and fields
  • Viewing or setting default values
  • Re-ordering columns within a table
  • Re-ordering fields in the table
  • Changing column width and row height
  • Hiding and un-hiding columns
  • Freezing columns
  • Formatting datasheet cells
  • Changing datasheet fonts
  • Copying and moving fields and records
  • Another look at the database window
Relationships
  • Defining relationships
  • Opening the relationships window
  • Adding tables to the relationships window
  • Making relationships
  • Referential integrity
  • Editing relationships
Locating and replacing information
  • A simple search
  • Wildcards
  • Finding specific values
  • Find and replace
  • Sorting records
  • Sorting records on more than one field
  • What is a filter?
  • Filtering records by selection
  • Filtering records by form
Creating simple queries
  • Creating queries, using the query wizard
  • Creating queries without the wizard
  • The query grid
  • Logical operators in criteria
  • Text in criteria - wildcards
  • Multiple criteria and alternative criteria
  • Calculated fields
  • Summary queries
  • Update queries
  • Append queries
  • Make-table queries
Creating calculated fields
  • Creating calculated fields
  • Using the expression builder
  • Introducing forms
    Basic form layout types
  • Creating a form
  • Different ways of viewing forms
More about creating forms
  • Creating forms without using the wizard
  • The form design view window
  • Manipulating form design
  • Types of control
  • The toolbox
  • Creating a combo box control
  • Changing form properties
  • Using forms with subforms
  • Creating a form with a subform
  • Controlling data input
  • Changing tab order
  • Adding command buttons
  • Adding page breaks
  • Switchboards
Reports
  • Creating a report using autoreports
  • Creating reports using the report wizard
  • Using the label wizard
  • Using the chart wizard
  • Grouping levels in reports
  • Creating a report without a wizard
  • Creating controls
  • Setting properties


see the full course programme

on request

get more information on the programme directly from ITEC Integrations.

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

Venues and dates



Where Blantyre, Block 2, Unit 9, First Road, Blantyre Industrial Estate
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
Get direct information on how to enrol, venues and availability...
 

On ITEC Integrations

Provider description
ITEC Integrations offer a wide ranging menu of Information Technology tailored training and support services, promoting the efficient use of desk-top PCs as office productivity tools.

We provide a valuable source of staff training now considered vital to those seeking the competitive edge necessary to compete in today's aggressive business markets.

All our IT training courses have been approved for Individual Learning Account funding in Scotland.

All courses

by ITEC Integrations on emagister.

See list of courses

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

Most searched for in Access

Information related to Access

International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina

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