Advertisements

Build tables and format data types

Note: Before you build tables, it’s helpful to understand Access database objects.

When you launch a fresh, blank database, Access instantly produces an empty table. To customise that table, start assigning your fields and input data.

Rename a table in a desktop database

Table1 is the automatic name of the initial table in an original desktop database. It’s recommended to give the table a clearly defined name.

  1. Click Save on the Quick Access Toolbar.
  1. Type a purposeful name in the Table name box.

Add a table to a desktop database

Feel free to include more tables if required, considering if you started working with a template.

  1. On the Create tab, click Table. Access creates a new table with the name Table<#>, where <#> is the following sequential, spare number.
  1. Rename the table applying the procedure in Rename a table in a desktop database, previously in this tutorial.

Save a table

Before exiting your database, make sure you save your table to present losing your completed work. If you attempt to close the database, Access notifies you to save it if you haven’t already saved your data on a table. Or, at any time, select the save button.

Add a field by typing data

  1. In the Datasheet, type data in the Click to Add column of the datasheet. This prompts Access to form a new field.
Screen snippet of ID in Supplier table
  1. Enter a new name for the field within the column heading.
Screen snippet of Supplier table showing two rows with ID
Advertisements

Leave a Reply

%d bloggers like this: