3

Question 1

What is a database that retrieves specific data from one or more databases?

Answer 1

Query

Question 2

What is an organized collection of data?

Answer 2

Database

Question 3

When saving in access database, the file extension should be labeled as what?

Answer 3

.accdb

Question 4

What’s the maximum amount of decimal points in currency mode?

Answer 4

4

Question 5

When appending or creating a new table from an import, the file Being imported is called what?

Answer 5

The source file

Question 6

What can a user use to view how a table will print before committing?

Answer 6

Print preview

Question 7

There are two page layouts in access, portrait has a vertical orientation what is the second layout ?

Answer 7

Landscape with a horizontal orientation

Question 8

What is needed to establish a table relationship?

Answer 8

A primary key and a foreign key

Question 9

What is the most common type of relationship in access?

Answer 9

One to many

Question 10

To connect two or more tables with common fields a user needs to establish and define what?

Answer 10

The table relationships

Question 11

Because it is uncommon for a user to need to see all the data in table what is beneficial to a user and allows them to see all the data?

Answer 11

Queries

Question 12

What is needs to be checked off for a user to not display query results?

Answer 12

Show box

Question 13

A user can add what to the criteria for a field in the query design grid to return results where there is nothing in that field?

Answer 13

Is null

Question 14

To edit an existing relationship, a user will need to right-click on what line?

Answer 14

The join line

Question 15

The query window is broken into two parts, the table area and the what?

Answer 15

The query design grid

Question 16

Access will place what around a text string within a query criteria that will limit the results to their exact specifications?

Answer 16

Quotation marks

Question 17

What are the conditions users can set to Ina query to identify specific records they want to return?

Answer 17

Criteria

Question 18

If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as what?

Answer 18

> =500

Question 19

To get the results of a select query, the user needs to click —– what from the results group in the design tab

Answer 19

Run

Question 20

How do you rename a table?

Answer 20

Right click on the navigation pane and click rename

Question 21

To establish table relationships, a user needs to right click on relationships from the relationship group on what tab?

Answer 21

The External data tab

Question 22

What is the process of arranging data in a specific order based on the value in a field?

Answer 22

Sorting

Question 23

Users can quickly open the edit relationships dialog box from the relationships window by double-clicking what line

Answer 23

The join line

Question 24

The form does not display data in the text box control in which view?

Answer 24

In the design view

Question 25

When linking two tables in a relational database, a user will need what to create a link?

Answer 25

Common fields

Question 26

Fields that contain numbers that are not used in calculations should be set to what?

Answer 26

Short text

Question 27

To improve accuracy during user imput, a designer can limit the number of characters a user can enter by adjusting the________ from the properties tab

Answer 27

Field size

Question 28

When a user creates a form using the from tool, the form is created with field displayed from what orientation?

Answer 28

Top to bottom

Question 29

A what contains control on a form or report contained descriptive information, like a field name?

Answer 29

Label

Question 30

When users create an AND condition for their filter criteria, the results will include records where what criteria are met?

Answer 30

All criteria

Question 31

When a user makes changes to a record in a form, the record is also updated in the underlying what?

Answer 31

Table

Question 32

When a user uses the filter by form command, access opens two tabs at bottom of the form. The first is the Look for tab and the other is what?

Answer 32

Or tab.

Question 33

A report header displays information where?

Answer 33

At the top of the first page on the report

Question 34

When creating a calculated field, the new field name must be followed by a colon and each field name that will be used in the expression must be enclosed within its own part of what?

Answer 34

Brackets

Question 35

What key refers to the unique field that identifies a record?

Answer 35

I’d