|
Provided by: Pitman Training Centre London Access Training CourseAccess |
 |
Training
Provided by Pitman Training Centre London
Study at the Microsoft IT Academy that won the silver award for "Best Learning Centre" at the National IT Training Awards.
Aimed at complete beginners to Access and individuals who already have some experience, but who wish to increase their skills on the latest version of this effective database application.
Available at our High Holborn and Notting Hill training centres.
Visit www.holborntraining.co.uk for more information.
|
|
||||||||||||||||
Access Training Course
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 a database containing related tables and recognise relationships between tables. Use the Office Assistant. 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. 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. 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. 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.
About The Training Provider: Pitman Training Centre London
Pitman Training Centre London - We are Pitman Training London (High Holborn and Notting Hill), silver award winners of the "Best Learning Centre" category in the National IT Training Awards. We're also a Microsoft IT Academy We provide executive pa courses, legal secretarial courses, medical secretary training, secretarial skills, touch typing, shorthand, bookkeeping and Sage courses, payroll training, courses in Word,...
