Data Management :: Microsoft Access

Microsoft penetrationBefore you use Microsoft nark to actually build the put overs, forms, and other objects that allow for make up your infobase, it is important to take time to objective 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 kickoff step in designing a Microsoft Access database is to determine the innovation of the database and how its to be used. You pack to know what information you want from the database. manikin that, you can determine what subjects you need to hive away facts about (the tables) and what facts you need to store about each subject (the fields in the tables).Talk to wad who will use the database. Brainstorm about the questions youd like the database to answer. cogitation out the reports youd like it to produce. Gather the forms you currently use to render your data. Examine well-designed databases similar to the one you are designing.D etermining the tables can be the trickiest step in the database the reports you want to print, the forms you was to use, the questions you want answered dont needfully provide clues about the structure of the tables that produce them.You dont need to design your tables using Microsoft Access. In fact, it may be better to skeleton out and rework your design on paper first. A table should not contain duplicate information, and information should not be duplicated amidst tables.After you have designed the tables, fields, and relationships you need, its time to study the design and detect any flaws that might remain. It is easier to change your database design now, rather than later 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.