Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Refining Your Table in Design View
Chapter 2: Refining Your Table
in Design View
In This Chapter
✓ Creating and fine-tuning fields in Design view
✓ Choosing the correct field type
✓ Formatting a field with field properties
✓ Defining a primary key
Chapter 1 of this minibook covers how to create tables and use your
data in Datasheet view. This chapter covers creating and refining
tables in Table Design view, where you never see any actual data.
In Design view, you can access many settings for all the fields in a table just
a little more easily than you can in Datasheet view. If you’re creating a table
and won’t immediately put data in it, Design view is a good place to do that,
and if you want to change how your fields work and what data they accept,
Design view is a good place to work.
Design view may be a little intimidating to begin with, but it can make your
database work better. In Design view, you can work with field definitions
without having to look at data. You can even define fields for data to be
input later. Datasheets are similar to spreadsheets. Design view takes you
into the database realm and allows you to take control of your data by
using, for example, the data-integrity tools described in Chapter 5 of this
Creating Tables in Design View
Design view is a good place to create a table if you know a lot about the type
of data that will be in the table and you want to design the fields you create
for the data you have to put in them. If you’re creating the table but don’t
yet have any data, Design view is the perfect place to start.
You can always switch to Datasheet view by clicking the View button on the
Home or Design tab of the Ribbon or by clicking the Datasheet button near
the bottom-right corner of the Access window.