A simple database like say a Christmas card list, will most likely only use one table in Access. Once you create a new database, your creation is a new filet hat lives on on your computer and acts as a container for all of the objects in your database, including your tables.
You can create a table by creating a new database. You do this by inserting a table into an existing database, or by importing or linking to a table from another data source — such as a Excel workbook, a Word document, a text file, or another database.
When you create a new, empty database, a new, empty table will be automatically inserted . You can then enter data in the table to start defining your fields.
Follow the steps below to learn how:
- Click File | New.
- Select Blank desktop database.
- In File Name, key in an intuitive name for your new database.
- To browse to a different location and save your database, click the folder icon.
- Click Create.
Your new database will open, and a new table named Table1 will opens in Datasheet view.