Create a Table

Task: Create a Table		No	E1
No	Steps	Yes	No
01	Open the software Package Package Start àrunàMSAccessàok
02	Create new database
03	Close empty table
04	Create new table
05	Type field name
06	Select data type The Data Type property uses the following settings. Setting Type of data Size Text (Default) Text or combinations of text and numbers, Up to 255 characters Memo Lengthy text or combinations of text and numbers. Up to 63,999 characters. Number Numeric data used in mathematical calculations 1, 2, 4, or 8 bytes Date/Time Date and time values 8 bytes. Currency Currency values 8 bytes. AutoNumber A unique sequential (incremented by 1) 4 bytes Yes/No Yes and No values (Yes/No, True/False, or On/Off). 1 bit. OLE Object An object Up to 1 gigabyte (limited by disk space) Hyperlink Text or combinations of text and numbers stored as text and used as a Data type can contain up to 2048 characters. Attachment Any supported type of file You can attach images, Lookup Wizard Creates a field that allows you to choose a value from another table or from a list of values by using a list box or combo box. The same size as the primary key
07	Type a "Description' if necessary
08	Select and type suitable field properties
09	Select primary key field
10	Apply primary key
11	Save the table
12	Close table
13	Repeat the steps from 4 to 12 to create all tables in the database

Adding More Tables to the Database

By default, Access 2007 starts out with one table. To add more tables to the database, click on the Create tab on the Ribbon.

Then, select Table from the Tables command group. A new table will open in the active database object

window. You must name your table using the Save command from Microsoft Office menu.

Adding Fields to a Table

Access 2007 allows you to add fields to tables when you are:

1.       working in Datasheet View, which looks like a spreadsheet

2.       working in Design View, where you are able to set more controls for your fields.

Either way, you need to know how to switch between the two views.

Switching Views

To switch views, select the Views command group from either the Home tab (seen below) or the Datasheet tab on the Ribbon. Select the view option you would like from the menu.

Moving Fields

If you want to rearrange the order in which your fields appear in a table, Access 2007 lets you easily move them around. To move a field in Datasheet View, drag and drop the field to the location you want. To do this:

1.       Click on the field header for the field you wish to move.

2.       Move the mouse in the area of the header.

3.       When the cross with arrows appears, hold down your left mouse button.

4.       With the left mouse button still held down, move the cursor to where you would like the field to appear.

5.       Release the mouse button and the field appears in its new location.

Setting the Data Type for a Field

Access 2007 lets you control how data can be entered in each table field within your database. This is done using Data Type. The default Data Type is text for every field after the ID field, which was set to auto number. You can change the Data Type setting:

1.       from the Data Type & Formatting command group on the Ribbon

2.       from the Data Type column in Design View