Deck 1: Introduction to Access: Finding Your Way Through an Access Database

Question 1

Which of the following is NOT a main object type in an Access database?

A) Template
B) Query
C) Table
D) Module

Answer 1

A

Question 2

________ a database rearranges data and objects in a database to make its size smaller.

A) Backing up
B) Compressing
C) Compacting
D) Fragmenting

Answer 2

C

Question 3

A ________ is a question you ask about data stored in a database.

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

Answer 3

A

Question 4

Which of the following is an object that adds functionality to a database and is written using VBA?

A) Macro
B) Module
C) Query
D) Report

Question 5

Access differs from other Microsoft software because it:

A) works primarily from memory.
B) works primarily from storage.
C) does not save your work as soon as changes are made.
D) does not allow more than one user to work on a file at a time.

Question 6

You can click the ________ button on the table toolbar to sort records in alphabetical order, from A to Z.

A) Sort
B) Descending
C) Order
D) Ascending

Question 7

Which of the following is TRUE about Access' Compact and Repair feature?

A) It fragments a fragmented relational database file.
B) It defragments a fragmented database file if needed.
C) It removes objects and stores them in a secondary file.
D) You should compact your database no more than once a week due to the time required.

Question 8

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

A) Database
B) Query
C) Table
D) Report

Question 9

Which of the following is FALSE about the Undo feature in Access?

A) You can click Undo to reverse the most recent change to a single record.
B) You can use Undo to reverse multiple edits in Access.
C) In Access, the Undo feature works the same as it does in other Office programs.
D) You can click Undo to redo a change that you made previously.

Question 10

Which of the following best describes information?

A) Information is a converted into fields and records within a table in a database.
B) Information is converted into data that can be selected and sorted for business or personal use.
C) Information is what is entered into a database.
D) Information is the finished product that is produced by a database.

Question 11

Of the following, which is NOT a main object type in an Access database?

A) Report
B) Form
C) Macro
D) Record

Question 12

When you apply a multiple sort in Access, columns are sorted:

A) from right to left.
B) from left to right.
C) from top to bottom.
D) by primary field and then by secondary field.

Question 13

Access' ________ feature creates a duplicate copy of a database.

A) Back Up Database
B) RDBMA
C) Compact and Repair
D) Relationship

Question 14

Which of the following is FALSE about the navigation bar in Access 2013?

A) It is located at the bottom of the Access window.
B) It contains buttons to go to a first, previous, next, or last record of a database.
C) It enables you to find a record based on a single search word.
D) It is toggled on and off with the F11 key.

Question 15

The ________ view in Access looks similar to an Excel spreadsheet.

A) Report
B) Form
C) Datasheet
D) Design

Question 16

You can create or modify a table's field names and data types in ________ view.

A) Report
B) Form
C) Datasheet
D) Design

Question 17

When you make a change to the content of a record in an Access table, when are the changes saved?

A) When you click the Save or Save As button from the File tab or the button on the Quick Access Toolbar
B) When you press F11 or click the Save button on the Quick Access Toolbar
C) When you move the insertion point to a different record
D) When you move the insertion point to a different table, form, query, or report in the database

Question 18

Which of the following is NOT a tab in Access 2013?

A) Create
B) Home
C) Format
D) File

Question 19

An Access database can MOST accurately be described as a structured collection of:

A) tables.
B) objects.
C) records.
D) modules.

Question 20

A primary key:

A) must include letters.
B) must contain a unique value for each record within a table.
C) has the same value for all records in a relational database.
D) is a unique record within a relational database.

Question 21

Information is what is typically entered into a database. Data is the finished product of the database.

Question 22

A relationship is a connection between:

A) two tables using a field that is common to both.
B) two or more database files with a common primary field.
C) two records within the same database.
D) two or more tables using a common record.

Question 23

The Undo button does not reverse the most recent change in Access 2013.

Question 24

The process of saving in Access is nearly the same as it is in other Microsoft Office applications.

Question 25

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan's requirements. He should use the Filter by Form ________ condition.

A) query
B) sort
C) OR
D) AND

Question 26

What does a custom Web app enable you to do?

A) Create databases through Access' Web app.
B) Create relational tables that can be distributed through the Web.
C) Create a database and share with others through the Web.
D) Share and distribute database files without the need for Access to be installed on every computer.

Question 27

When you ________, you ensure that data entered into a related table first exists in the primary table.

A) create a foreign key
B) create a primary key
C) filter by selection
D) enforce referential integrity

Question 28

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

A) query
B) sort
C) OR
D) AND

Question 29

The navigation buttons in Access allow you to step through a table record by record, or to quickly go to the first or last record in the table.

Question 30

The F2 key puts you in Edit mode when in Access.

Question 31

A complete set of all fields about one person or event is called a field.

Question 32

A relational database has the ability to create relationships between two:

A) forms.
B) fields.
C) files.
D) tables.

Question 33

People use databases to store collections of data.

Question 34

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:

A) Filter by Form.
B) Filter by Selection.
C) Sort Ascending.
D) Sort Descending.

Question 35

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table.

A) referential integrity key
B) relational database
C) foreign key
D) primary2 key

Question 36

You may choose Access over Excel in all of the following situations EXCEPT when you:

A) require multiple related tables to store your data.
B) need to group data based on various parameters.
C) need to create complex charts.
D) have a large amount of data.

Question 37

Two users cannot work on the same table in a database.

Question 38

Backing up a database rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly.

Question 39

Click the File tab to begin the process of compacting and repairing a database.

Question 40

A number, phrase, or expression used to select records in a table is called:

A) a primary key.
B) a criterion.
C) a query.
D) referential integrity.

Question 41

SharePoint is an add-on program for Access.

Question 42

Enforce referential integrity is one of only two options available when setting a database relationship with another database.

Question 43

Access can create relationships between two tables; Excel cannot.

Question 44

Tables, queries, reports, and forms are all examples of ________.

Question 45

A template is a predefined database that can be used to jumpstart the creation of a database.

Question 46

A comparison operator in Access is used to evaluate the relationship between two primary keys.

Question 47

A sort can only list records in a database in a specific numeric sequence.

Question 48

Objects that are part of an Access database are available from the ________ within Access.

Question 49

Both Access and Excel contain tools that can be used to extract and analyze information.

Question 50

Filter by Form uses the AND and OR logical operators.

Question 51

Like Access, Excel can be used to manage large quantities of data.

Question 52

A(n) ________ is a collection of organized and meaningful data that can be accessed, managed, stored, queried, sorted, and reported.

Question 53

Access is preferred over Excel in managing mostly numeric data.

Question 54

Access can sort records by more than one field.

Question 55

You can create a Web app from a Web app template from the Backstage view.

Question 56

A filter and a sort always produce the same results in an Access database.

Question 57

Microsoft ________ is the database management system included in Office 20013 Professional.

Question 58

Filter by Selection displays only records that match a criterion that you select.

Question 59

Custom Web app is available in the Backstage view of Access.

Question 60

A(n) ________ system is a software system that offers tools needed to create, maintain, and use a database.

Question 61

A primary key from one table that is used to form a relationship with a second table is called a(n) ________.

Question 62

When forming relationships in a relational database, the ________ from one table must be joined to the foreign key of another table.

Question 63

Relationships in a database can be graphically represented by the ________ between the tables.

Question 64

When you are ready to sort a database, click in the field that you want to sort and click the ________ tab.

Question 65

The ________ utility of Access helps reduce the size of a database.

Question 66

The ________ Database utility in Access creates a duplicate copy of a database.

Question 67

Use ________ if you have mostly numeric data and may require complex charts and graphs.

Question 68

A(n) ________ is a collection of fields that describe something, such as a person, place, event, or idea.

Question 69

A(n) ________ is the smallest data element of a table.

Question 70

________ view is a grid containing fields and records.

Question 71

A(n) ________ is a number, phrase, or expression used to select records from a table.

Question 72

A primary key may use a(n) ________ data type--a generated primary key that is automatically incremented each time a record is added.

Question 73

The ________ displays the number of the current record as well as the total number of records in a table.

Question 74

________ sorts a list of numeric data from highest to lowest.

Question 75

Access allows you to save a database as a PDF or ________ file, which preserves the object's formatting and looks the same on most computers.

Question 76

Good database design begins with grouping data into correct tables, a practice known as ________.

Question 77

Rather than displaying records based on a question as in a query, a(n) ________ hides records that do not match a set criteria.

Question 78

In relational databases, there is a concept known as ________ that ensures that data cannot be entered into a related table unless it first exists in a primary table.

Question 79

Use ________ if you have a large amount of data and may need to group, sort, and total the data based on various parameters.

Question 80

Access is known as a(n) ________ system because it allows users to administer groups of data in tables and create relationships.