An Easy To Follow, Practical Course In Database Building With MS Access.

---

Need Help Or More Information?

020 7025 4700 Holborn

020 7792 5214 Notting Hill

l

Northumberland House
303 - 306 High Holborn London WC1V 7JZ

United House
9 Pembridge Road London W11 3JY

 

Access Training - Proficient Level 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!

To enrol or find out more, call

020 7025 4700 for High Holborn
020 7792 5214 for Notting Hill Or contact us by email.

---

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 only do we operate two award winning IT training centres, 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.

Microsoft Access training courses from CoursesPlus+