Northumberland
House 303-306 High Holborn London WC1V 7JZ
United House
9 Pembridge Road London
W11 3JY
Pitman Training
Access Proficient Course.
This very popular Access course will equip you with all the skills
you need to build databases in Microsoft Access.
In only 20
study hours at our comfortable High Holborn or Notting Hill training centres,
you'll grow from novice to intermediate in database design.
Not only will
you receive a high quality workbook to keep for future reference, at the
end of the course, provided you pass our exam, you'll receive a handsome
Pitman Training certificate - proof of your skill level!
What Is Covered.
Lesson
1:
Understand the following terms - table, record, field, query, form,
report, common field, one-to-one relationship, one-to-many relationship,
primary key and foreign key. Understand the planning and design of an
Access database containing related tables and recognise relationships
between tables. Use the Office Assistant.
Lesson 2:
Define fields, data types and properties for three tables using design
view. Enter data into tables using datasheet view. Set primary keys
and establish relationships. Navigate records in a table. Use the Lookup
Wizard to create a field that looks up data from another table and to
establish a relationship. Use Find to locate specific entries. Sort
records. Use the Table Wizard to create a table, modify the table design
and enter data into the table. Use the Input Mask Wizard.
Lesson
3:
Edit data in form and datasheet views. Add new records. Change page
orientation. Enforce referential integrity in a relationship. Work with
controls in form design.
Lesson
4:
Import a table from an external database. Use a junction table to resolve
a many to many relationship. Add a new field to a form. Use a calculated
control on a form. Create a query. Use criteria to retrieve selected
data. Create and name a calculated field in a query.
Lesson
5:
Add a field with data validation in a table. Enter data using a Form/Sub
form combination. Perform summary calculations on a group of records
in a Query. Create and modify the design of a Report. Save a table as
a Web page. Add a hyperlink in an existing Web page.
To find out more, or to
book, just call 020 7025 4700 for High Holborn or 020 7792 5214 for Notting
Hill or contact us by
email.
Not
onlydo
we operate an award winning IT training centre, we're also a Microsoft
IT Academy.
That
means you'll not only earn a nationally recognised Pitman Training certificate
on completion of your MS Access course, you'll now get a Microsoft certificate
too!
And
it couldn't be more convenient for you to study.
We're open from
09:00-20:00 Monday to Thursday, till 16:30 on Fridays and from 10:00-16:00
on Saturdays.
We make learning
so easy!
To find out more,
or to book your training, call us on
020 7025 4700
for High Holborn, 020 7792 5214
for Notting Hill,
or contact us by email.
We're looking
forward to answering your questions.
