Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Access 2003 Fundamentals (2-days)

Training Courses

Would you like to see more Microsoft Access courses?

Training course summary

Sponsored links

Objectives: After completing this course, you will know how to: Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature. Plan and create a database; use Datasheet view and Design view; and create tables and work in tables. Modify a table’s design; use the Find feature and the spelling checker; and sort, filter, and delete records. Set field properties; create input masks; set validation rules; and create singleand multiple-field indexes. Create queries, and sort and filter the results; modify queries; and perform operations in queries. Create, modify, and work with forms; and use them to find, sort, and filter records. Create reports by using AutoReport, the Report Wizard, Design view, and queries; and modify and print reports. Normalize tables, set table relationships, and implement referential integrity between related tables. Create a Lookup list field, modify Lookup field properties, and use a subdatasheet to add data to related tables. 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.
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 person)

 

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