Deck 1: Creating a Database

Question 1

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

Answer 1

False
report

Question 2

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

Answer 2

False

Question 3

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

Answer 3

True

Question 4

Field values that may be entered into a field are determined by the data type of the field._________________________

Question 5

The default sort order for records in an Access table is based on the values in the primary key field._________________________

Question 6

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

Question 7

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

Question 8

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

Question 9

Compacting a database rearranges the data and objects in a database to decrease its file size._________________________

Question 10

A query is used to enter,edit,and view records in a database._________________________

Question 11

The only option available for creating tables in Access is to use the datasheet view._________________________

Question 12

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

Question 13

The query results are stored in the database in which the query has been created._________________________

Question 14

When creating a form in Access,the Layout view allows the user to make design changes to the form while it is displaying data.
_________________________

Question 15

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

Question 16

It is possible to view all Access objects in the Navigation Pane._________________________

Question 17

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

Question 18

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time.
_________________________

Question 19

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

Question 20

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

Question 21

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

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

Question 22

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

Question 23

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

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

Question 24

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

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

Question 25

Which view is used to make design changes to a form while the form is displaying data?

A)Design view
B)Table view
C)Layout view
D)Datasheet view

Question 26

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

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

Question 27

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

A)closes the current database
B)closes the current database and exits Access 2016
C)closes only the current database object
D)copies the current database and exits Access 2016

Question 28

Which Access 2016 view shows the contents of a table as a datasheet?

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

Question 29

Data organized as a collection of tables creates this type of data system.

A)database
B)database management system (DBMS)
C)primary key system
D)relational database management system

Question 30

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

Question 31

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

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

Question 32

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

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

Question 33

Another term used for the column selector feature is ____.

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

Question 34

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)wide fit
B)best fit
C)column adjustment fit
D)trim fit

Question 35

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

Question 36

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.

Question 37

To save a table in Access with a name that relates to the database (a name other than the Access default name),it is necessary to complete which process?

A)save the table object
B)save the database
C)save the record
D)save the field

Question 38

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

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

Question 39

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

Question 40

Each column in an Access table datasheet represents a ____.

A)query
B)record
C)field
D)primary key

Question 41

All of the data in a relational database are contained in ____________________.

Question 42

A table's contents are shown in rows and columns when using the ____________________ view.

Question 43

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

Question 44

Access reports are based on a selected ____________________ or ____________________.

Question 45

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

Question 46

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables;the field in the second table is called a(n)____________________.

Question 47

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

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

Question 48

Which of the following attributes of a table are saved only when the table object is saved?

A)records
B)field values
C)characteristics of the fields
D)data records

Question 49

Which of the following is the file extension used for Access 2016 database files?

A)mdb
B)acdbs
C )accdb
D)dbacc

Question 50

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

Question 51

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

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

Question 52

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

Question 53

Records in separate tables may be connected through a(n)____________________ that appears in both tables.

Question 54

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

Question 55

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

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

Question 56

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

A)Tab,Insert
B)Enter,PgDn
C)Insert,PgUp
D)Tab,Enter

Question 57

When copying and pasting records from one table to another,the records must first be copied to the ____.

A)database
B)query
C)storage device
D)clipboard

Question 58

The default ____________________ provided by Access is the ID field.

Question 59

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

Question 60

Files created with Access 2016 may be used with which previous version of Access?

A)Access 2010
B)Access 2000
C)Access 2005
D)Access 2003

Question 61

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

Question 62

Identify the letter of the choice that best matches the phrase or definition.
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
The Access 2016 view that shows the number of pages that will be printed.

Question 63

Identify the letter of the choice that best matches the phrase or definition.
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
An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

Question 64

Explain the difference between a primary key and a foreign key.

Question 65

Identify the letter of the choice that best matches the phrase or definition.
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 status box that displays the number of the current record and the total number of records in a table.

Question 66

Identify the letter of the choice that best matches the phrase or definition.
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
The Access Ribbon tab that offers the option for the user to compact and repair a database.

Question 67

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

Question 68

Identify the letter of the choice that best matches the phrase or definition.
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
The Access 2016 view that allows the user to manage files and options.

Question 69

An important reference tool available in Access 2016,which may be used to assist a user with problems that might occur,is the ____________________ system.

Question 70

Identify the letter of the choice that best matches the phrase or definition.
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 question that is asked about the data stored in a database.

Question 71

Identify the letter of the choice that best matches the phrase or definition.
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,or collection of fields,whose values are used to uniquely identify each record in a table.

Question 72

Identify the letter of the choice that best matches the phrase or definition.
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
The specific content of a field.

Question 73

Identify the letter of the choice that best matches the phrase or definition.
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
AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

Question 74

Identify the letter of the choice that best matches the phrase or definition.
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
The Access Ribbon tab that allows the user to create database objects such as tables,forms,and reports.

Question 75

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.