Warning: Use of undefined constant referer - assumed 'referer' (this will throw an Error in a future version of PHP) in /usr/home/essaywo/public_html/essays on line 102

Warning: Use of undefined constant host - assumed 'host' (this will throw an Error in a future version of PHP) in /usr/home/essaywo/public_html/essays on line 105

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/essaywo/public_html/essays:102) in /usr/home/essaywo/public_html/essays on line 106

Warning: Cannot modify header information - headers already sent by (output started at /usr/home/essaywo/public_html/essays:102) in /usr/home/essaywo/public_html/essays on line 109
Database Design - College Paper

Database Design

Before you use Microsoft Access to actually build the tables, forms, and other objects that will make up your database, it is important to take time to design your database. A good is the keystone to creating a database that foes what you want it to do effectively, accurately, and efficiently.
The first step in designing a Microsoft Access database is to determine the purpose of the database and how it’s to be used. You need to know what information you want from the database. Form that, you can determine what subjects you need to store facts about (the tables) and what facts you need to store about each subject (the fields in the tables).
Talk to people who will use the ...

Want to read the rest of this paper?
Join Essayworld today to view this entire essay
and over 50,000 other term papers

produce them.
You don’t need to design your tables using Microsoft Access. In fact, it may be better to sketch out and rework your design on paper first. A table should not contain duplicate information, and information should not be duplicated between tables.
After you have designed the tables, fields, and relationships you need, it’s time to study the design and detect any flaws that might remain. It is easier to change your now, rather than after you have filled the tables with data. (see figure 1-2 on page 4)
Use Microsoft Access to create your tables, specify relationships between the tables, and enter a few records of data in each table. See if you can use the database to get the answers you want. Create rough drafts of your forms and reports and see if they show the data you expect. Look for unnecessary duplications of data and eliminate them.
When you are satisfied that the table structures meet the design goals described here, then it’s time to ...

Get instant access to over 50,000 essays.
Write better papers. Get better grades.

Already a member? Login

CITE THIS PAGE:

APA
MLA
Chicago
Turabian

Database Design. (2008, September 20). Retrieved February 5, 2025, from http://www.essayworld.com/essays/Database-Design/90225

"Database Design." Essayworld.com. Essayworld.com, 20 Sep. 2008. Web. 5 Feb. 2025. <http://www.essayworld.com/essays/Database-Design/90225>

"Database Design." Essayworld.com. September 20, 2008. Accessed February 5, 2025. http://www.essayworld.com/essays/Database-Design/90225.

JOIN NOW

Join today and get instant access to this and 50,000+ other essays

PAPER DETAILS

Added: 9/20/2008 09:49:55 PM
Category: Miscellaneous
Type: Premium Paper
Words: 400
Pages: 2

Save |

Report

SHARE THIS PAPER

SAVED ESSAYS

Save and find your favorite essays easier