Write step to "Create a Table" in design view.
Answers
Open your database document.
Click on the Tables icon in the left column (labeled Database).
Click on Create Table in Design View... icon in the Tasks section
For each field:
type a field name
once a field name is chosen, Neo enters Text[VARCHAR] as the field type; if this is not the correct field type, click on this field type (in the same row as the field name); a drop-down menu appears; choose the correct field type
Make the necessary adjustments in the Field Properties section below the fields list.
be sure that you have provided sufficient length for your fields; this cannot be changed later.
You can specify that the field must have an entry (necessary for primary key fields).
You can specify a Default Value for those cases when a field will usually (but not always) have a specific value. For example, you could enter your own state abbreviation in the State field of the Locations table.
For those tables where the primary key will be an ID field, the field type should be Integer, and AutoValue should be set to Yes
Select the row with the field that is to be the primary key. A green triangle will appear in the left hand column.
Control-click or right-click on the green triangle and choose Primary Key from the contextual menu. A key icon appears in the far left column. Remember that each record of your database must have a unique entry in the primary key field.
Click on the disk drive icon on the toolbar at the top of the window; this saves your changes.
Close the window and return to the main database document window
Answer:
steps create a table in design view
- open your database document
- on the table icon in the left column (labelled database)
- click on create table in design view icon in the task section
- for each field-:
- type a field name
- once a field name is chosen Neo enter text (VARCHAR) as the field type if this is not the correct field click on this file type (in the same row as the field name) a drop down menu appears to the correct field type
- make the necessary adjustments in the field properties section below the field list
- the row with the field that is to be the primary key of a green triangle will appear in the left hand column
- control click or right click on the green triangle and choose primary key from the textual menu-icon appears in the for left column remember that each record of your database must have a unique entry in the primary key field
- on the disc drive icon on the toolbar at the top of the window this saves your changes
- the window and return to the main database document window