|
Provided by: Pitman Training Centre Notting Hill Microsoft Access CourseAccess |
 |
Training
Provided by Pitman Training Centre Notting Hill
Learn how to create and manage databases using Microsoft Access in only 20 hours at our Notting Hill training centre.
This course leads to a nationally recognised Pitman Training certificate.
|
|
||||||||||
Microsoft Access Course
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.
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.
About The Training Provider: Pitman Training Centre Notting Hill
Pitman Training Centre Notting Hill - Famous for nearly 200 years for our shorthand method, Pitman Training is the longest-established private provider of secretarial, office and bookkeeping skills in the UK, offering nationally recognised qualifications.
We welcome students of all levels, from beginners to experts and many of our students are from overseas, so we're used to supporting people with English as a second or third...
