What method can you use to add a new table to your database? A. Use Design View to create a table B. Enter data directly by using a datasheet C. Both of above D. All of the above

The correct answer is: C. Both of above

You can use either Design View or a datasheet to add a new table to your database.

Design View

In Design View, you can create a new table by specifying the table’s structure, including the field names and data types. You can also add constraints to the table, such as primary keys and foreign keys.

Datasheet

In a datasheet, you can add data to a table by entering the data directly into the cells of the datasheet. You can also add new rows and columns to the datasheet.

Explanation

A. Use Design View to create a table

In Design View, you can create a new table by specifying the table’s structure, including the field names and data types. You can also add constraints to the table, such as primary keys and foreign keys.

To create a new table in Design View, follow these steps:

1. In the Navigation Pane, right-click the database that you want to add the table to, and then click New > Table.
2. In the Table Designer window, on the Design tab, in the Tools group, click the Add Field button.
3. In the Field Name box, type a name for the field.
4. In the Data Type box, select the data type for the field.
5. Repeat steps 2-4 for each field that you want to add to the table.
6. To add a primary key to the table, on the Design tab, in the Tools group, click the Primary Key button.
7. To add a foreign key to the table, on the Design tab, in the Relationships group, click the Relationships button.
8. In the Relationships window, drag the primary key field from the first table to the foreign key field in the second table.
9. Click the Create button.

B. Enter data directly by using a datasheet

In a datasheet, you can add data to a table by entering the data directly into the cells of the datasheet. You can also add new rows and columns to the datasheet.

To add data to a table in a datasheet, follow these steps:

1. In the Navigation Pane, right-click the database that you want to add the table to, and then click New > Table.
2. In the Table window, click the Datasheet View button.
3. In the first row of the datasheet, type the field names for the table.
4. In the second row and below, type the data for the table.
5. To add a new row to the datasheet, click the Insert Rows button.
6. To add a new column to the datasheet, click the Insert Columns button.

C. Both of above

You can use either Design View or a datasheet to add a new table to your database.