Question 1

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

Accepted Answer

1. A DBMS allows the creation of databas

Question 2

MATCHING
-A question that is asked about the data stored in a database.

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

-Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Accepted Answer

A)  Find group, Go To button 
B)  Records group, Save button 
C)  Records group, New button 
D)  Sort & Filter group, Advanced button 
A)  Find group, Go To button 
B)  Records group, Save button 
C)  Records group, New button 
D)  Sort & Filter group, Advanced button

Question 6

Which Ribbon group allows you to add fields to an Access table with defined data types?

Accepted Answer

A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete 
A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete

Question 7

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 8

-In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

Accepted Answer

A)  FirstName 
B)  PatientID 
C)  VisitID 
D)  VisitDate 
A)  FirstName 
B)  PatientID 
C)  VisitID 
D)  VisitDate

Question 9

Access reports are based on a selected ____________________ or ____________________.

Accepted Answer

The answer of Access reports are based on a selected...

Question 10

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

Accepted Answer

A)  scroll the vertical scroll bar 
B)  scroll the horizontal scroll bar 
C)  cllick on the Navigation Pane 
D)  right click 
A)  scroll the vertical scroll bar 
B)  scroll the horizontal scroll bar 
C)  cllick on the Navigation Pane 
D)  right click

Question 11

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 12

Which data type allows field values to contain letters, digits, and other characters?

Accepted Answer

A)  Short Text 
B)  AutoNumber 
C)  Currency 
D)  Date/Time 
A)  Short Text 
B)  AutoNumber 
C)  Currency 
D)  Date/Time

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

Main Street Catering has created a database with one table containing customer information. When creating the table, Marissa did not follow recommendations for naming fields in a table. There are a number of changes that would make the field names more useful and follow field naming recommendations. Using the accompanying figure, answer the following questions about the CustomerTable.
-Which field name follows the recommendation of capitalizing the first letter of each word and also follows the no spaces recommendation?

Accepted Answer

The answer of   
Main Street Catering has created...

Question 15

This icon   represents which Access 2013 object?

Accepted Answer

A)  form 
B)  table 
C)  query 
D)  report 
A)  form 
B)  table 
C)  query 
D)  report

Question 16

Another term used for the column selector feature is ____.

Accepted Answer

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

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

-Which Access feature provides information about Access commands and features and instructions about how to use them?

Accepted Answer

A)  Query Wizard 
B)  Access Help 
C)  Form Wizard 
D)  Report Wizard 
A)  Query Wizard 
B)  Access Help 
C)  Form Wizard 
D)  Report Wizard

Question 19

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

Accepted Answer

A)  Write 
B)  Touch 
C)  Tap 
D)  Tablet 
A)  Write 
B)  Touch 
C)  Tap 
D)  Tablet

Question 20

Field names may have up to 64 characters. However, one of the recommendations is to use concise field names. Which field names could be changed to be more concise?

Accepted Answer

All fields except Cu

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

MATCHING -A question that is asked about the data stored in a database.

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

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

-Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Which Ribbon group allows you to add fields to an Access table with defined data types?

What is the purpose of the primary key?

-In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

Access reports are based on a selected or .

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

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

Which data type allows field values to contain letters, digits, and other characters?

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

This icon represents which Access 2013 object?

Another term used for the column selector feature is ____.

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

-Which Access feature provides information about Access commands and features and instructions about how to use them?

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

Field names may have up to 64 characters. However, one of the recommendations is to use concise field names. Which field names could be changed to be more concise?

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Exam 1: Creating a Database

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

MATCHING -A question that is asked about the data stored in a database.

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

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

-Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Which Ribbon group allows you to add fields to an Access table with defined data types?

What is the purpose of the primary key?

-In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

Access reports are based on a selected ____________________ or ____________________.

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

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

Which data type allows field values to contain letters, digits, and other characters?

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

This icon represents which Access 2013 object?

Another term used for the column selector feature is ____.

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

-Which Access feature provides information about Access commands and features and instructions about how to use them?

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

Field names may have up to 64 characters. However, one of the recommendations is to use concise field names. Which field names could be changed to be more concise?

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Essential Computer Concepts

Getting Started With Excel

Formatting Workbook Text and Data

Calculating Data With Formulas and Functions

Analyzing and Charting Financial Data

Exploring the Basics of Windows 8

Integrating Word, Excel, Access, and Powerpoint

Internet Basics and Information Literacy

Introduction to Cloud Computing

Managing Your Files

Creating a Presentation

Adding Media and Special Effects

Creating and Editing a Document

Navigating and Formatting a Document

Creating Tables and a Multipage Report

Enhancing Page Layout and Design

Filters

Access reports are based on a selected or .