Microsoft Office Tutorials and References
In Depth Information
Creating the First Table for Your Data
first field. The ID field automatically gives each record a unique ID
number, which is useful as you continue to build your database.
Notice that the Fields tab appears automatically on the Ribbon when
you display a datasheet.
3. Save the table by pressing Ctrl+S or by clicking the Save button near
the top-left corner of the Access window.
Access displays the Save As dialog box, allowing you to name your table.
4. Type a name for the table in the Table Name field, and press Enter.
Use a descriptive name so that you can find the table in the future. For
more information on naming database objects, see Book I, Chapter 3.
Entering data and creating fields
When you have a new, blank datasheet, start entering your data. Even if you
want to create a form to enter data, it makes sense to enter one record’s
worth of data and rename the fields to describe the data they hold. Then
you’ll have the basics of your table defined, and you can use the table to
create a form, where you can continue to enter data in a more attractive
As you enter data, Access determines the data type (Number, Date, or
Text) and defines the field accordingly. Whenever you’re ready, you can
rename the fields.
Enter data by clicking the first cell and typing.
To save some time, for the very first piece of data in each field, add the dollar
sign for currency numbers or the percent sign for a percentage, and type any
dates in a recognized format ( 1/10/14 or January 1, 2014 , for example). Then
Access knows the type of data you’re putting in the field and automatically
defines the data type, which saves you the trouble of changing it later.