Filters
Question type

Study Flashcards

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

A) True
B) False

Correct Answer

verifed

verified

 The default ____________________ provided by Access is the ID field.

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A)  tables
B)  forms 
C)  reports
D) both a. and b.

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

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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


A)  Datasheet view
B)  Design view 
C)  Backstage view
D)  Form view

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

Correct Answer

verifed

verified

 What is the purpose of the primary key? 


A)  to uniquely identify each record in a table 
B)  to uniquely identify each table in a database 
C)  to create a relationship between two tables in a database 
D)  to create a relationship for queries in a database

E) B) and C)
F) A) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

 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

verifed

verified

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


A)  Navigation Bar
B)  Record 
C)  Shutter Bar Open/Close
D)  Table View

E) None of the above
F) A) and D)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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


A)  data, fields, and table relationships
B)  numbers, tables, and fields 
C)  symbols, numbers, and tables
D)  fields, tables, and table relationships

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

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


A)  a query
B)  a record 
C)  a field
D)  a data type

E) A) and B)
F) All of the above

Correct Answer

verifed

verified

 Another term used for the column selector feature is ____. 


A)  row selector
B)  record selector 
C)  name selector
D)  field selector

E) A) and B)
F) B) and C)

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

 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 ____. 


A)  creating reports using Access
B)  related databases 
C)  programming tasks
D)  queries

E) C) and D)
F) B) and D)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

 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) A) and B)
F) B) and D)

Correct Answer

verifed

verified

Showing 41 - 60 of 75

Related Exams

Show Answer