Find Courses Find Providers Providers - Promote Your Courses About Us

Access Course

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

Sponsored links

Now you can really get under the skin of Microsoft Access and exploit its functionality to the full. In approximately 20 hours, you'll cover the following: 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.

Regions:
  • London
Delivery:
  • Computer Based
Category:
Difficulty:
  • Introductory

Further Details

We're now a Microsoft IT Academy! That means you can qualify for internationally recognised Microsoft certificates as well as Pitman Training qualifications. We offer a self-paced training environment with award winning tutor support, so you'll always have the confidence of knowing you're being looked after. In fact, we have recently won the award for "Best Pitman Training Centre!" You can start this course at any time and create your own flexible timetable so you can study when it suits you - great if you're already working! We're open from 09:00-18:00 on Mondays, Wednesdays and Fridays, from 09:00-20:00 on Tuesdays and Thursdays and from 10:00-16:00 on Saturdays, so it's really easy to fit your studies around your other commitments. You'll enjoy lots of tutor support at our training centre which is 1 minute from Notting Hill Gate tube.

Guide price

POA

 

Sponsored links

Interested in this course?

 

 

Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net