Microsoft Office Tutorials and References
In Depth Information
Chapter 1: Creating and Modifying Tables
Chapter 1: Creating and
In This Chapter
✓ Making original tables with Datasheet view
✓ Displaying existing tables
✓ Navigating a datasheet
✓ Finding and editing your data
✓ Entering and editing tricky hyperlinks
✓ Spell-checking data
✓ Using AutoCorrect to enter data
✓ Adding formatting to a table
✓ Working with subdatasheets
✓ Totaling the data in a datasheet
Tables are the basic building blocks of your database; they hold the
data that you need to save and analyze. If you have data and are using
Access, this chapter is a great place to start.
Your data may already be in Access, or it may be stored somewhere else,
either on paper or in electronic form, and you (or someone you work for)
decided that Access is the right tool for storing and analyzing this data.
You’re probably right!
If you’re getting ready to put data into Access, it’s important that you first read
Book I, Chapter 3. That chapter tells you how to gather all your data and look
at it, how to decide how many tables to create to hold your data, and which
fields to put in which tables. In that chapter, you also find out all about fields
and records (that is, columns and rows in your table). After you’ve outlined
the big picture of your database design, this chapter is the next step. Here,
we tell you how to go about creating new tables and putting your data in them.
Creating tables and entering data may not be the most glamorous things
you do with your database, but having well-designed tables and correctly
entered data makes your database as useful as possible. After you’ve created
a place to store your data in an organized way, you can put Access to work
and analyze and view your data in any way you want.