The correct answer is: D. All of the above
A database is a collection of data that is organized so that it can be easily accessed, managed, and updated. A table is a structure that stores data in a database. To create a table in Access, you must first create a database. Once you have created a database, you can create a table by using the Table Wizard or by creating a blank table.
If you use the Table Wizard, you will be asked to select a table template. A table template is a pre-defined table that includes fields and relationships. You can also create a blank table, which means that you will need to create the fields and relationships yourself.
Once you have created a table, you can add data to it by entering data into the fields. You can also add records to a table by using the Datasheet view.
To create a primary key in a table, you must select one or more fields that will uniquely identify each record in the table. The primary key must be a unique identifier for each record in the table.
Here is a brief explanation of each option:
- A. Database should be created before create table
A database is a collection of data that is organized so that it can be easily accessed, managed, and updated. A table is a structure that stores data in a database. To create a table in Access, you must first create a database.
- B. Table can be created using Table Templates
A table template is a pre-defined table that includes fields and relationships. You can also create a blank table, which means that you will need to create the fields and relationships yourself.
- C. There must be at least one Primary key in a table
The primary key must be a unique identifier for each record in the table.
I hope this helps!