How To Create A Table in Access 2007
Table Views
You can use two ways to create,view and insert data in a table.
Design View and Datasheet View.
With Design View you can view all the fields with the data types and descriptions.
Note: The record of information cannot be viewed if you use this feature.
To go to Design View:
- Click the down arrow on the View button at the left side of the Ribbon.
- Click Design View
In Datasheet View you can display the records in a table, where one row is one record. The column headers are the fields you have defined for the database.
To go to Datasheet View:
- Click the down arrow on the View button
- Click Datasheet View
How to Add New Fields
you can use several ways to add new fields in your database. You can either use Datasheet View or in the Design View.
You can also use two ways to add a new field in Datasheet View: you can either Add A New Field or the New Field Button.
To add a New Field within the Datasheet:
- Click the Add New Field column
For you to add a New field by using the New Field Button
- Click the Datasheet tab on the Ribbon
- Click the New Field Button
- Choose the type of field you wish to add from the Field Templates window
How To add a new field in Design View:
- Click the Design View button on the view tab
- Click on the next available field
- Type in the Name of the field
Data Types
when you type you field name, the type of data you will enter appears under the auto number.
There are many types a data that a field can be predefined to hold. When you create a new field in a database you should closely match the data type to what will be entered into the field.
Text: This field can only hold text and numbers
Memo: Can contain texts and numbers
Numbers: Can contain numbers only
Date / Time: Allows date and time only
Currency: Allows currency written up to 4 decimal places
Auto Number: Creates a unique number for each record.
Yes or No: Stores 1 for Yes and 0 for No
OLE Objects: For images, graphs and documents
Hyperlink: For web Addresses
Attachment: Allows for attaching images, chats, document or spreadsheets.
How to Edit Data Types in Fields
When you are creating a table, it’s recommended that you define the data types of each table to match the type of data that you will be entering in the field.
To edit the Data Type in Datasheet View:
- Click the field you wish to define
- Click the Datasheet tab on the Ribbon
- Click the down arrow next to Data Type
- Choose the type of data that will be entered into the field
How To Format the Data Type in the Design View:
- Click Design View
- Click the field name you wish to define or create a new field
- Click the Data Type
- Choose the appropriate Data Type
- Format the field in the Field Properties Dialog box
