Microsoft Access 2007_Basics_v2

Microsoft Access 2007_Basics_v2 - M icrosoft Access 2007...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Click to edit Master subtitle style 4/8/11 February 15, 2011 Microsoft Access 2007
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Build a database I: Design “Relational” Means Multiple Tables A relational data structure divides your information into logical pieces , and places each piece in a separate table. For example, a sales database typically puts information about customers — their names, addresses, and other key facts — in one table, and information about what those customers buy (orders) in another table. Organizing your data that way can make it quite powerful.
Background image of page 2
The Advantages of Relating A relational structure has several advantages. It lets you answer important business questions, such as who bought the most (or least) of your product last week. Using separate tables can make your data easier to manage, because each table holds just part of your information . Finally, a relational structure helps keep your information
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

Microsoft Access 2007_Basics_v2 - M icrosoft Access 2007...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online