Home, sweet home
View when our computer courses are being run
See what each computer course entails
See what Computer Solutions s.c. can do for you
Need a website? Let Computer Solutions s.c. design one for you
See where Computer Solutions s.c. likes to surf
Click here to tickle your funny bone
See our Computer newsletter
Send the Webmaster some email

 

Database Development

Course Outlines

Course Schedule

Course Description

This course is designed to inform the students as to the process that can be followed when designing a database. The course goes through the two basic types of databases, flat-file and relational, and shows the pros and cons of each. The student is led through the creation of a database application, including the implementation of the finished product. Planning the database objects, such as forms, tables, and queries, are accentuated. This is a  course designed to help people who may be asked to design a database application for others to use.

 

Course Objectives

Ø      Differentiate between flat-file and relational databases

Ø      Planning the database

Ø     Planning the layout of the tables

Ø     Deciding on how the tables relate to one another

Ø     Deciding which queries are needed and how to implement them

Ø     Planning which types of forms to use in certain situations

Ø      The creation of a switchboard form

Ø    Designing reports

Ø      Using macros to automate tasks

Ø      Administering, repairing, and compacting a database

 

Duration

The duration of the course is one day. This day begins at 8:30 am and ends at 4:30 pm.

Table of Contents

I What Is a Database?
A. Flat File Vs. Relational
II  Planning a Relational Database
III  Deciding on an Object Plan
A. The Attached Table Plan
B. The Singular Database Plan
IV Planning your tables
A. Creation of Fields
B. Customizing Input to These Fields
C. Creating a Primary Key and Indexes
V Planning Relationships between the Tables
A. One to One Relationships
B. One to Many Relationships
VI Queries
A. Deciding Which Queries to Create
B. Parameter Queries
C. Action Queries
D. Deciding on Sorting Order
VII Planning input forms  
A. Controls to Ease Input
B. Multiple Table Forms
C. Overall Look & Feel
D. Specifying Tab Order
E. Creating a Switchboard
VIII

Reports
A. Design Concepts
IX Macros
A. Introduction
B. When to Use Them
C. Automation
D. Autoexec Macro
X Administration
A. Compacting the Database
B. Repairing the Database
 

 

Relevant Links
MS Access Level 1
MS Access Level 2
Our Services