FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Creating a Database

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

 What function does compacting an Access database perform other than reducing the file size? 

A)  sorting the database
B)  querying the database 
C)  saving the database
D)  repairing the database

E) All of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

 A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). _________________________ 

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

 Which button is used to open and close the Navigation Pane? 

 Which Access 2016 view contains commands used to manage Access files and options? 

 A relationship between two tables in a database is formed using a Backstage field. _________________________

 Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

 A table is a predesigned database that includes professionally designed database objects. _________________________ 

 Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

 Access report printing options may be changed using theNavigation dialog box._________________________

Identify the letter of the choice that best matches the phrase or definition. - A question that is asked about the data stored in a database. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

 Another term used for the column selector feature is ____. 

Identify the letter of the choice that best matches the phrase or definition. - The Access Ribbon tab that offers the option for the user to compact and repair a database. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

 What is the purpose of the primary key? 

 The default ____________________ provided by Access is the ID field.

 Which Access database object(s) might be used to enter,edit,and view records in a database? 

 A formatted printout (or screen display) of the contents of one or more tables or queries is a form. _________________________

 Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____. 

 In a relational DBMS,a user may create a database structure that contains which of the following? 

 Each row in an Access table datasheet displays which of the following? 

 Each record in a table is uniquely identified by a foreign key. _________________________