|
||
|
Creating Tables in Access In the Database Window:
You have 3 choices for creating a table. · Design view · using the wizard · simply entering data
A Table
is made up of rows and columns. The rows are records of data and the
columns are the types of fields in each record. Using the Design view:
1.
Create table in Design view
will be already selected. In the Database Window, click on the New
2. In the Table window: a. enter a field name, press TAB,
b.
choose the type of data this field will be from the drop-down c. enter a description, if you wish, press TAB d. and you are ready for your next field. 3.
Click on Save Using the wizard:
1. In
the Database Window, click on the New 2. Choose what category type (Business or Personal), then choose a sample table from the list. The fields for that table will appear in the Sample Fields list. Double click on each field you wish to use. They should appear in the Fields in my new table list. Click Next. 3. Name your table. You can have Access choose your Primary Key* or you can choose this later. Click Next. *Primary Key: A field that uniquely identifies each record in a table. In the same way a license plate number identifies a car, a primary key identifies a record.
4.
In the last step, you can choose to modify the table design (primary
key, field names, field type, and field length), start entering data in
the table, or use a form to enter data in the table. Click Finish.
You can enter data in the table or form by using the TAB key to get
around. Using the Datasheet View:
1. In
the Database Window, click on the New
2. If
you choose not to use the default Field names, you can rename them: a. Click in the column to be renamed. b. Click Format, Rename Column. c. Rename the column. Then click into the next column or press Enter. OR a. Simply double click on the column name to be changed. b. Rename the column. Then click into the next column or press Enter. 3. To enter data in the table, click in a cell and type your data. Press TAB to jump to the next cell in that record. 4.
Click on Save Using the Datasheet View to Add Rows (Records) or Columns (Fields) in your table: · To add a row or record, click Insert, New Record and begin entering data. This will enter your data in the last row of your table. · To add a column, click on the column to the right of where the new column will be inserted. Click Insert, Column. …To Delete Rows (Records) or Columns (Fields) in your table: · To delete a column, click in that column. Click Edit, Delete Column. Click Yes. · To delete a row or record, click in that row or record. Click Edit, Delete Record. Click Yes. Using the Design View to Add Columns (Fields) in your table: 1.
Click on the table you wish to add columns to. Click on the
Design 2. Click in the next available cell under the Field Name column. Enter your field name. 3. Press TAB and choose a Data Type. Save your change. …To Delete Columns (Fields) in your table: 1.
Click on the table you want to add columns to. Click on the
Design 2. Click in the field you want to delete. Click Edit, Delete Row. Click Yes. Save your change. Sorting Records While viewing a table, you
can sort the records alphabetically by click in the column you want to
sort by. Then on the toolbar, click Filtering Records While viewing the table,
select a value in your table that you want to base the filter on. Click
the Filter By Selection Rearranging Columns in a table 1. Click on a column heading or the Field name of a column. The column will be highlighted. 2. Click and drag the Field name to the left or right of another column.
|
button,
select Design View in the New Table window, then OK.
and
give the table a name.
button.
for
Ascending or 
for
Descending. 
button
on the toolbar. This will filter out the records according to what you
selected. 
button.