Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Access 2007 Fundamentals (2-days)

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

Sponsored links

Objectives: By the end of this course you will be able to create 1:1 and 1:many relational databases. You will be able to construct tables, implement forms, design and use simple and complex queries, and produce reports based on your data. Prerequisites: This course requires that you have a good working knowledge of Microsoft Windows and should also be able to use a mouse and keyboard. Target Audience: The course is aimed at those who will be designing, supporting and creating databases. Delegates will learn how to use the more advanced and powerful features of Access 2000 in order to be more efficient in data management including complex forms, reports with charts and action queries for bulk data processing.

Regions:
  • All Areas
Delivery:
  • In House
  • Public
  • Computer Based
Category:
Difficulty:
  • Introductory

Further Details

Course Content: Getting started Database concepts and terminology Exploring the program environment Getting help Closing databases Databases and tables Planning and designing databases Exploring tables Creating tables Fields and records Changing the design of a table Finding and editing records Organizing records Data entry rules Setting field properties Working with input masks Setting validation rules Using indexes Simple queries Creating and using queries Modifying query results and queries Performing operations in queries Using forms Creating forms Using the Form Wizard Using Design view Finding, sorting, and filtering records Creating reports Creating reports Modifying and printing reports Relational databases Database normalization Relating tables Implementing referential integrity Working with related tables Using the Lookup Wizard Modifying Lookup fields Adding data to related table

Guide price

£450 per person (public course)

 

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