Create a Table from scratch in Design view
- If you haven't already done so, switch to the Database Window You can press F11 to switch to the Database window from any other window.
Create a Table from scratch in Design view Double-Click on "Create table in Design view".
(DESIGN VIEW)
- One or more fields (columns) whose value or values uniquely identify each record in a table. A primary key does not allow Null values and must always have a unique value. A primary key is used to relate a table to foreign keys in other tables.
- NOTE: You do not have to define a primary key, but it's usually a good idea. If you don't define a primary key, Microsoft Access asks you if you would like to create one when you save the table.
- For our tutorial, make the Soc Sec # field the primary key, meaning that every student has a social security number and no 2 are the same.
Switching Views
To switch views form the datasheet (spreadsheet view) and the design view, simply click the button in the top-left hand corner of the Access program.
| Datasheet View | Design View |
 Displays the view, which allows you to enter raw data into your database table. |  Displays the view, which allows you to enter fields, data-types, and descriptions into your database table. |
0 Response to "Create a Table from scratch in Design view"
Posting Komentar