Question 1

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

Accepted Answer

The answer of There are two ways to move vertically...

Question 2

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

Accepted Answer

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

Question 3

Match between columns
                        Premises: The Access 2016 view that shows the number of pages that will be printed.

Accepted Answer

The Answer of primary key and field value and Print is...

Question 4

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Accepted Answer

A) primary key field 
B) field value 
C) foreign key field 
D) common field 
A) primary key field 
B) field value 
C) foreign key field 
D) common field

Question 5

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

Accepted Answer

A) wide fit 
B) best fit 
C) column adjustment fit 
D) trim fit 
A) wide fit 
B) best fit 
C) column adjustment fit 
D) trim fit

Question 6

A question asked about the data stored in a database is called a primary key.  _________________________

Accepted Answer

A) True 
 B)False

Question 7

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

Accepted Answer

A) 255 
B) 36 
C) 64 
D) 146 
A) 255 
B) 36 
C) 64 
D) 146

Question 8

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

Accepted Answer

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

Question 9

A single characteristic or attribute of a person, place, object, event, or idea is a  table .  _________________________

Accepted Answer

A) True 
 B)False

Question 10

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet.  _________________________

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The answer of Data can be presented in customized and...

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

The default primary key for an Access database is the ID field.  _________________________

Accepted Answer

A) True 
 B)False

Question 15

A database or a relational database is a collection of related tables.  _________________________

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

The specific content of a field is referred to as the ____.

Accepted Answer

A) field content 
B) field value 
C) table value 
D) column value 
A) field content 
B) field value 
C) table value 
D) column value

Question 18

What is the purpose of the primary key?

Accepted Answer

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

Question 19

What are the five primary functions of a Database Management System (DBMS)?

Accepted Answer

1. A DBMS allows the creation of databas

Question 20

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Accepted Answer

The answer of The process of decreasing the file size...

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

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

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

A question asked about the data stored in a database is called a primary key. _________________________

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

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 single characteristic or attribute of a person, place, object, event, or idea is a table . _________________________

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. _________________________

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

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

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

The default primary key for an Access database is the ID field. _________________________

A database or a relational database is a collection of related tables. _________________________

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

The specific content of a field is referred to as the ____.

What is the purpose of the primary key?

What are the five primary functions of a Database Management System (DBMS)?

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 1: Access-Module 1: Creating a Database

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

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

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

A question asked about the data stored in a database is called a primary key. _________________________

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

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 single characteristic or attribute of a person, place, object, event, or idea is a table . _________________________

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a data sheet. _________________________

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

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

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

The default primary key for an Access database is the ID field. _________________________

A database or a relational database is a collection of related tables. _________________________

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

The specific content of a field is referred to as the ____.

What is the purpose of the primary key?

What are the five primary functions of a Database Management System (DBMS)?

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters