|
Provided by: 2e2 Microsoft Access FundamentalsMicrosoft Office |
 |
Training
Provided by 2e2
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 in order to be more efficient in data management including complex forms, reports with charts and action queries for bulk data processing.
|
|
||||||||||||
Microsoft Access Fundamentals
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
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
About The Training Provider: 2e2
2e2 - 2e2 is a training provider focussing on the end-user, providing courses in the following areas:
Desktop Applications training (e. g. Microsoft Office)
Unified Communications training (e. g. IP Telephony)
Service Management (including ITIL)
Web Development
Training Room Hire
We deliver public courses in London, Leeds and Birmingham and...
