Microsoft Office Tutorials and References
In Depth Information
Designing a Database
✦ Opening an object in Design view: The task of formulating database
tables, forms, and queries is done in Design view. If an object needs
reformulating, right-click it and choose Design View on the shortcut
✦ Finding objects: Use the Search bar (located at the top of the Navigation
pane) to search for objects.
✦ Opening and closing the Navigation pane: Click the Shutter Bar Open/
Close button on upper-right corner of the Navigation pane (or press F11)
when you want to shrink it and get it out of the way. You can also resize
this pane by clicking the far right edge and dragging it left or right.
Designing a Database
Being a database designer isn’t nearly as glamorous as being a fashion
designer, but it has its rewards. If you design your database carefully and
correctly, it can be very useful to you and others. You can enter information
accurately. When the time comes to draw information from the database,
you get precisely the information you need. These pages explain everything
you need to consider when designing a database. Pay close attention to
“Separating information into different database tables” because the hardest
part about designing a database is deciding how to distribute information
across database tables and how many database tables to have.
Deciding what information you need
The first question to ask yourself is about the kind of information you want
to get out of the database. Customer names and addresses? Sales
information? Information for inventory tracking? Interview your co-workers to find
out what information could be helpful to them. Give this matter some
serious thought. Your goal is to set up the database so that every tidbit of
information your organization needs can be recorded.
A good way to find out what kind of information matters to an organization
is to examine the forms that the organization uses to solicit or record
information. These forms show precisely what the organization deems worthy
of tracking in a database. Figure 1-6, for example, shows the paper form that
players fill out to sign up for a baseball league whose database tables appear
in Figure 1-7. Compare Figure 1-6 with Figure 1-7, and you can see that the
Players, Teams, and Divisions database tables all have fields for entering
information from this form.