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

Question 1

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

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

Answer 1

A

Question 2

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.

Answer 2

B

Question 3

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.

Answer 3

B

Question 4

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

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

Question 5

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 6

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

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

Question 7

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 8

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 9

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 10

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

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

Question 11

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

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

Question 12

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

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

Question 13

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

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

Question 14

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 15

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 16

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 17

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 18

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 19

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

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

Question 20

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

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

Question 21

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

Question 22

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 23

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 24

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 25

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

Question 26

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 27

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 28

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 29

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

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

Question 30

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

Question 31

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 32

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

Question 33

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

Question 34

People use databases to store collections of data.

Question 35

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 36

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 37

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 38

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 39

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

Question 40

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

Question 41

Access is preferred over Excel in managing mostly numeric data.

Question 42

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

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

Filter by Form uses the AND and OR logical operators.

Question 50

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

Question 51

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

Question 52

Access can sort records by more than one field.

Question 53

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

Question 54

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

Question 55

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

Question 56

SharePoint is an add-on program for Access.

Question 57

Access can create relationships between two tables; Excel cannot.

Question 58

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

Question 59

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

Question 60

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

Question 61

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 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

________ view is a grid containing fields and records.

Question 69

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

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

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 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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