Asked by Colin Glenn on Sep 29, 2024

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.

Append Query

A query in database management that adds the results of a query to an existing table, rather than displaying them.

Query Design View

A feature within database management software that offers a graphical representation for creating or adjusting queries, facilitating easier manipulation of data retrieval parameters.

Excel Workbook

A file in Microsoft Excel that contains one or more worksheets to organize, calculate, analyze, and visualize data.

  • Understand the use of action queries and their impact on database tables.