Share this Page URL

Chapter 1. The HelloWorld Database > Creating a Table - Pg. 4

The HelloWorld Database 4 Creating a Table In this section, we'll create a table --the object in a database in which your stored data resides. In creating this table, you'll be introduced to fields, which are the elements of a table that identify the bits and pieces of data the table stores, and to data types, which are the categories used to define the kind of data a particular field can contain. We'll also look at how to use table properties to control some of the behavior and characteristics of a table and the fields and data a table contains. As we mentioned, tables hold the data stored in the database, and fields identify the items of data the table will store. You can think of a field as a column in a spreadsheet, identified by its column heading. The rows of a spreadsheet are equivalent to a table's records --in other words, each row or record is made up of the data stored in the set of table fields or spreadsheet columns. Although an Access database is usually made up of more than tables alone--objects such as forms and reports are used to enter and display information--the table and its fields are the foundation of the database. See Also For more information about table design, see Chapter 2, "The Basics of Database Design," and Chapter 3, "Managing the Consistency, Format, and Integrity of Your Data." Here are the steps to create a table. Create a table 1. 2. 3. In the Database window, select Tables in the Objects list. On the Database window's toolbar, click New. In the New Table dialog box, select Design View, and then click OK. A blank Table Design window appears, as shown here: