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.
- Click Save on the Quick Access Toolbar.
- 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.
- On the Create tab, click Table. Access creates a new table with the name Table<#>, where <#> is the following sequential, spare number.
- 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
- In the Datasheet, type data in the Click to Add column of the datasheet. This prompts Access to form a new field.
- Enter a new name for the field within the column heading.