Which of the following are ways to add records to an existing table? Select all the options that apply.

A) Enter records in Query Design View.
B) Import records from an Excel workbook.
C) Enter records directly in the datasheet.
D) Run an Append query to add records from another table.

Question

Nirmini Ravichandran · Accepted Answer

Final Answer : B, C, D, Explanation :  C is the most straightforward and direct way to add records to an existing table - simply enter the data directly in the datasheet.B is another option that allows you to import records from an Excel workbook. This can be useful if you have a large amount of data that you want to add to the table, or if you want to copy and paste data from another source.D involves running an Append query, which adds records from another table to your existing table. This can be useful if you have a source of data that you want to merge with your existing table.Option A, entering records in Query Design View, is not a practical way to add records to an existing table. Query Design View is used to create queries that retrieve data from tables - adding records is not the main function of this view.

Which of the following are ways to add records to an existing table? Select all the options that apply.

A) Enter records in Query Design View.
B) Import records from an Excel workbook.
C) Enter records directly in the datasheet.
D) Run an Append query to add records from another table.

Definitions

Learning Objectives

Learning Objectives

Related questions

Which of the following are ways to add records to an existing table? Select all the options that apply.A) Enter records in Query Design View.B) Import records from an Excel workbook.C) Enter records directly in the datasheet.D) Run an Append query to add records from another table.

Definitions

Learning Objectives

Learning Objectives

Related questions

Which of the following are ways to add records to an existing table? Select all the options that apply.

A) Enter records in Query Design View.
B) Import records from an Excel workbook.
C) Enter records directly in the datasheet.
D) Run an Append query to add records from another table.