Share this Page URL

Chapter 2. The Basics of Database Design > Documenting Your Database - Pg. 68

The Basics of Database Design 68 To test the relationships in your database, create and run queries to check that you get the records you want. Create some forms and see whether you can enter and view data in the ways you ex- pected to. If you aren't experienced with queries and forms, we'll cover these database objects in detail in Part II of this book, "The Database Application." When the design and structure of your tables follow the principles outlined in this chapter, add your data to the database. In Chapter 4, you'll learn how to import data into Access from various formats, including spreadsheets and text files. In Chapter 7, you'll learn in detail how to create a data entry form. Documenting Your Database If you're creating a fairly complex database, be sure to document the decisions you make about which tables to create and the assumptions you make about what data each table will store and how tables are related. This information will come in handy as you get to work in Access to actually build more of the database objects. Database developers use tools that range from pencils and scratch paper to word processing or spreadsheet programs and even to software programs specif- ically designed for the job of modeling a database design. Whatever tool you decide to use, it's important that you keep your documentation up to date as the design and construction of your database progresses. Access also provides a tool you can use to document a database. The Documenter creates a report that describes the structure of your database--field names, relationships between tables, proper- ties, and so on. You'll probably want to run the Documenter more than once so that you can docu- ment your database at key stages in its development.