Description
This course familiarizes the students with the database fundamentals and teaches them how to perform database maintenance using MS Access. This course focuses on creation and design of databases and tables. The students will also learn the concept of querying tables.
Audience
Application Developers who implement a simple database solution using Microsoft Access 2000 database management system.
Prerequisites
The student should be familiar with MS Office 95/97. Â The user should also be familiar with using Windows 95/98.
Objective
Upon completion of this course the student will be able to:
describe databases
describe relational databases
list features of Microsoft Access
open a database in Access
design a database
create a new database
create a new table
customize a table
define relationships between tables
display sorted and filtered data
create a query using wizards
create a query from scratch
customize a query
add multiple tables to a query
Topics Include
Introduction to Microsoft Access
- Database Concepts
- Overview of Microsoft Access
Creating Databases and Tables
- Creating Databases
- Creating Tables
- Manipulating Tables
Using Access Queries
- Creating Queries
- Customizing Queries
Duration
3 hrs
Minimum Requirements
This was a test
Media
Web Based Training
|