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 database design 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 its 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 database. Brainstorm about the questions youd like the database to answer. Sketch out the reports youd like it to produce. Gather the forms you currently use to record your data. Examine well-designed databases similar to the one you are designing.
Determining the tables can be the......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 411
Approximate Pages: 2 (260 words per double-spaced page) |