Microsoft Office Tutorials and References
In Depth Information
Creating the First Table for Your Data
After you’ve displayed a table, you can easily switch between Design and
Datasheet view by clicking the View button — the first button on the Home
tab of the Ribbon.
Creating the First Table for Your Data
To get you right into the swing of working with Access, we start by showing
you how to create a table and enter data in the datasheet.
Before you create a table to hold your data, take some time to consider the
design of your database — that is, what fields and tables you need to use so
that your data is well organized and easy to analyze. (Book I, Chapter 3 has
all the information you need to know before you create your tables.)
After you figure out how to organize your data, you’re ready to sit down with
Access and create tables. If you’re importing data rather than entering it
piece by piece, see Chapter 4 of this minibook for more information.
Creating a new table using Datasheet view
The most straightforward way to create a new table is to create a datasheet
and begin entering data. A datasheet looks like a spreadsheet; if you’re
familiar with Microsoft Excel or another spreadsheet program, you’ll have no
trouble entering data in a datasheet. When you have data entered, you can
change field names and properties as needed.
In a datasheet, fields are columns, and records are rows. (If you’re confused
by this talk of fields and records, refer to Book I, Chapter 3.)
To create a table, first open the database that you want to hold the table.
If you’ve just created a brand-new database, as soon as you name the
database, you’ll see an empty table in Datasheet view, ready for you to enter
your data.
Follow these steps to create a new table in Datasheet view:
1. Open your database.
If you’re starting a new, blank database (as opposed to using a
template), Access immediately creates a new table in Datasheet view for
you. Just skip to Step 3, and start entering your data!
2. Click the Table button on the Create tab of the Ribbon (the second
button on that tab).
You see a blank datasheet in Datasheet view, as shown in Figure 1-3.
Access names it Table1. (You can change the table’s name when you
save it.) Access automatically creates an ID field; in Figure 1-3, it’s the
Search JabSto ::




Custom Search