Creating tables in design view gives you the greatest control over how the fields and properties are set, but it also involves more work than other techniques. Each field in the table design has a set of properties that you can safely leave at the default values. You can change these properties as you gain a deeper understanding of the product’s features.
A fantastic feature of Access is that the design view can always be used to modify an existing table structure, regardless of which technique you use to create the table.
Create a table:- Click the Create tab.
- Click Table Design.
- Type a name in the Field Name column for each field you want—for example, CustomerName.
- In the Data Type drop-down list, select a data type for each field—for example, Short Text. (At the end of this exercise, a table describes the data types that are available.)
- Click Save.
- Provide a name for the table, and click OK.
- If you have not created a primary key, you will be prompted to add a key. Click Yes to add a primary key.
- After saving your table, the new ID primary key is added to the table.
- The table now appears in the navigation pane.
TIP: Designers sometimes begin table names with a prefix, such as tbl—for example, tblCustomers—to distinguish tables from queries (which are prefixed with qry) when both appear in one list. Having a naming convention is a good idea when you’re creating complex databases.
TIP: Because there are several different choices here for numbers, you might find it easiest to use a Long Integer for whole numbers and use a Double for numbers with decimal places.
TIP: If you know which field(s) would make a good choice for a unique primary key, select the fields and click the primary key button. A primary key must be unique for each record in the table and cannot be null (blank). You can use more than one field to create a composite primary key, where each field doesn’t contain unique values, but the combination of fields will always be unique.
No comments:
Post a Comment