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 it’s to …showed first 75 words of 405 total…

…showed last 75 words of 405 total…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 go ahead and add your existing data to the tables. You can then create any queries, forms, reports, macros, and modules that you may want.