DBMS 2021

Which of the following tabs on the Ribbon contains the commands to import data from an Excel spreadsheet?

• Home

• Create

• External Data

• D. Database Tools

Which of the following groups contains the command to import a report from an Access database?

• Import & Link

• Export

• Create

• Design

Which of the following is NOT an option when importing data?

• Removing the data from the original source

• Importing the source data into a new table

• Appending a copy of the records to an existing table

• Linking to the data source by creating a linked table

Which of the following is specified during the Import Spreadsheet Wizard process?

• Font for the data text

• Gridline location in the table

• Field properties

• Color of the data text

Tables, queries, forms and reports from other Microsoft® Access databases can be imported into another database.

• True

• False

Microsoft® Access manages which the following types of files?

• Presentations

• Databases

• Texts

• Images

Which of the following tabs on the Ribbon holds the command for developing queries and tables?

• Home

• External Data

• Create

• Database Tools

Which of the following is a single piece of information related to the person, place, object, event or idea it describes?

• Field

• Table

• Database

• Record

Which of the following is a field whose value uniquely identifies each record in a table?

• Main key

• Primary key

• Element key

• Value key

Which of the following is NOT correct concerning database design?

• Identify all fields needed to produce the required information

• Organize each piece of data into its largest useful part

• Group related fields into tables

• Determine each table’s primary key