Microsoft Office Tutorials and References
In Depth Information
Creating a Table in Datasheet View
Refer back to the Session 1.1 Visual Overview and spend some time becoming
familiar with the components of the Access window.
Creating a Table in Datasheet View
Tables contain all the data in a database and are the fundamental objects for your work
in Access. There are different ways to create a table in Access, including entering the
fi elds and records for a table directly in Datasheet view.
Creating a Table in Datasheet View
• Click the Create tab on the Ribbon.
• In the Tables group, click the Table button.
• Accept the default ID primary key field with the AutoNumber data type, or rename
the field and change its data type, if necessary.
• In the Add & Delete group on the Fields tab, click the button for the type of field you
want to add to the table (for example, click the Text button), and then type the field
name. Repeat this step to add all the necessary fields to the table.
or
In the table datasheet, click the Click to Add column heading, click the type of field
you want to add from the list that opens, type the field name, and then press the Tab
or Enter key to move to the next column in the datasheet. Repeat this step to add all
the necessary fields to the table.
• In the first row below the field names, enter the value for each field in the first record,
pressing the Tab or Enter key to move to the next field.
• After entering the value for the last field in the first record, press the Tab or Enter key
to move to the next row, and then enter the values for the next record. Continue this
process until you have entered all the records for the table.
• Click the Save button on the Quick Access Toolbar, enter a name for the table, and
then click the OK button.
For Belmont Landscapes, Oren needs to track information about the company’s
contracts with its customers. He asks you to create the Contract table according to the plan
shown in Figure 1-5.
Figure 1-5
Plan for the Contract table
Field
ContractNum
CustomerID
Purpose
Unique number assigned to each contract; will serve as the table’s primary key
Unique number assigned to each customer; common field that will be a foreign
key to connect to the Customer table
Dollar amount for the full contract
Date on which the customer signed the contract
Brief description of the contract
ContractAmt
SigningDate
ContractType
As shown in Oren’s plan, he wants to store data about contracts in fi ve fi elds,
including fi elds to contain the amount of each contract, when it was signed, and the contract
type. These are the most important aspects of a contract and, therefore, must be tracked.
Also, notice that the ContractNum fi eld will be the primary key for the table; each
contract at Belmont Landscapes has a unique contract number, so this fi eld is the logical
Search JabSto ::




Custom Search