Page 2 of 11PREVNEXT

Datasheets I: Create a table by entering data

Steps for creating table in Access

Datasheet view + data = a new table.
Callout 1 After you start Access, click Blank Database.
Callout 2 Accept the default name, or enter your own, and then click Create.
Callout 3 Access opens the new database and displays the new table.

So, you've heard about Access, you've decided to try it, what do you do now? That's easy. You start Access, and on the Getting Started with Microsoft Office Access page, click the Blank Database icon. That brings up the Blank Database pane, where you can accept the file name that Access provides or enter another name and then click the Create button.

The new database opens and displays a single table that contains one row and two columns, or fields. In Access, tables are a lot like the worksheets in Excel — a grid of cells that store your data. Tables are the backbone of any database, and all databases contain at least one table and usually more.

The figure above shows the process of creating a new database and the table in that database. Remember that in a database, columns are called fields. Keep going to learn how to enter data in a table.

Page 2 of 11PREVNEXT