Microsoft Access 2007 Fundamentals (2-days)
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.
| Delivery: |
|
| Category: |
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
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. Contents © 1999 - 2012. All rights reserved.
