Access Ch 5-8 Multiple Choice

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

Which of the following is NOT used when laying out forms and reports?

Changing the Allow Edits property to No

A ___ is a set of constraints or rules that help control how data is entered into a field

Data Validation

Which of the following is NOT a rule for appending queries?

Data field types do not have to be the same

Which data validation method enables you to execute programming tasks whenever data in a table is changed?

Data macro

___ is similar to a validation rule except the logic is more complex and the actions taken are more powerful when table data is changed

Data macro

An access function that examines a date and returns a portion of the date is

DatePart function

Assuming hire date of 7/31/2016, which of the following would be the correct DatePart Function for the correct day of the week?

DatePart("w",[HireDate])

Assuming a hire date of February 15, 2017, which of the following data part functions would return the number of days since the beginning of the current year?

DatePart("yyyy",[HireDate])

Which data validation property specifies a value that is automatically entered into a field?

Default Value

A ___ helps to reduce editing time when there is a common value in a field

Default value

What do you do if you make a mistake when running a Find Unmatched query?

Delete the query and start over, then reverse the order of the tables

Which view do you use to modify lines or rectangles?

Design View

Which view gives a designer a higher level of control when creating forms and/or reports?

Design View

Where would you go to change tab order in a form?

Design view - Tab order in Tools group

Which sections display on forms and reports by default?

Detail and form/report header and footer

Which query identifies multiple instances of the same information in a table?

Find duplicates

What appears below the Page Footer section in a report or form?

Form Footer or Report Footer

Which of the following appears at the top/bottom of each form or report?

Form or Report Header/Footer

Which of the following appears once at the top/bottom of each page in a form or report?

Form or Report Header/Footer

___ affects the display of the date without affecting the underlying value

Formatting

To test an update query before running the query, what should you do first?

From Design view, click View in the Results group and click Datasheet view

How would you add grouping to a report?

Group & Sort button

The ___ appears after adding a grouping to a form or report

Group Header

The ___ function an expression and displays one value when the expression is true and another when the expression is false.

IIF

Which data validation method forces users to conform to a specific data-entry format for a given field?

Input Mask

Which of the following forces you to enter the phone number in a consistent manner in the database table?

Input mask

Which of the following function checks to see if a field has no value?

IsNull

___ function checks to see if a field does not contain a value

IsNull

Which of the following file types increases the database size byte for byte when attached in access?

JPEG and other photo formats

Where does a Group Footer appear?

Just below the Detail section

A ___ describes the data associated with a text box

Label control

Which of the following displays when you insert a text box?

Label control

Which two views make it easy to edit the design of a form?

Layout view and Design view

When you use the ___ operator, each criterion must be true for the compound criterion to be true

Like

What are two options for adding emphasis to your form or report?

Line or rectangle control

Which type of query automatically creates a new table from data that already exists in a database?

Make Table

What is the default software application associated with a CSV file?

Microsoft Excel

When two functions are not sufficient to evaluate an expression, you may need to use a

Nested Function

___ functions refers to using one formula within another one.

Nesting

How often does a Form/Report Header appear?

Once

The ___ file format was created by Adobe Systems for document exchange independent of software application and operating system environment

PDF

The ____ file format does not allow you to edit the exported documents

PDF

___ documents cannot be edited after being exported

PDF or XPS

What type of break is used to cause each group to print on a separate page?

Page

How is an attachment field identified in a table?

Paperclip

Before running a delete query, what should you do?

Preview the data sheet to verify that the records are those that you intend to delete

Before running a make table query, what should you do?

Preview the data sheet to verify that the records are those that you intend to insert into the table

What type of file does access create when exporting to word?

RTF

___ is a useful format for basic formatted text documents such as instruction manuals, resumes, letters, and other docs

RTF

Which of the following displays one time at the bottom of a report?

Report footer

Which data validation method forces data entry into a field?

Required

How do you switch on or off sections of a report or form?

Right click a blank area

___ is the correct syntax for the Round function

Round(expression, precision)

___ is the first method for controlling data input in a field of a table

Selecting an appropriate data type

What must you do once a text box has been converted to a combo box?

Set a source for the combo box

The objects you select to export from Access to Word should have which of the following types of layout?

Tabular

After adding grouping, a ___ appears just above the Detail section in Design view, along with the name of the field by which you are grouping

group header

A ___ enables you to quickly link to any file on your computer or to any Web page on the internet

hyperlink

A ___ forces users to conform to a specific data entry format for a given field

input mask

What is the purpose of a ScreenTip?

it displays when you point your mouse over the hyperlink text

A ___ is text not tied to a specific field

label

Which of the following controls can you use to add emphasis to your form or report?

line control and rectangle control

___ allows you to connect to a table without having to import the table data into your database

linking

A field with a number of repeated values may be better suited as what kind of field?

lookup field

The data validation method that causes fields to be limited to predefined list of values is a

lookup list

The ___ creates a menu of finite values by asking you questions and using your answers to create the options list

lookup wizard

Before linking to a spreadsheet, you must first

make sure the data is organized

A ___ query can be use to archive older records that need to be stored outside of the current table

make table

A ____ accepts two or more options in a lookup field.

multiple-value field

Before exporting a table to another database, what must be done first?

A database must be created

Which fields in a table are required fields by definition?

A field with a primary key

Why should you backup your database before running an action query?

Action queries are irreversible

Why should you backup your database before testing an action query?

Action queries change data in your database that cannot be reversed

Which of the following is an alternative to a comber box?

Add a data validation rule

To avoid a mistake when using an update query that includes making calculations on a field, what is one thing you can do to prevent losing the original information?

Add an additional field with the original figures

A ___ performs calculations on an entire column of data and returns a single value

Aggregate function

Sum, Min, Max, and Average are examples or which kind of functions?

Aggregate functions

Where do the row headings display in a cross tab query?

Along the left side of a cross tab query

Where do the column headings display in a cross tab query?

Along the top of a cross tab query

A ___ is a form that enables users to view but not change data

read-only form

A ____ sets the property of a field to force data entry

required

A field that cannot be left blank when you create a new record is a

required field

Which of the following marks the top boundary of a section in a form or report?

section bar

To test an update query before running it, you can

switch to datasheet view

The ___ is the sequential advancing in a form from one field to the next

tab order

___ are common methods of exchanging information between two computer systems

text files

What happens when you export a form with a subform to excel?

the form exports but the subform does not

When running an append query, what happens if a record violates the primary key rule for the destination table?

the record is rejected

What happens to the size of an access database when a table is linked to an excel spreadsheet?

the size of the database remains the same

Which of the following generally refers to decorative elements such as the title or a report?

unbound control

A ___ query is used to update or change data automatically based on criteria that you specify

update

A ___ can be used when records with missing data have been found

update query

A ___ would be used to replace null values with zeros?

update query

A ___ rule limits the type of data a user can enter into a field

validation

What is the main reason for exporting data to excel instead of word?

you are not able to analyze the data as you can in excel

What is one reason to import an Excel worksheet into access instead of linking it?

you have more control over the imported data

___ uses a comma to separate one column from the next, enabling the receiving software to distinguish one set of field values from the next

CSV text files

Which of the following fields is an example of a field that would not require a tab stop?

Calculated field

Calculated controls begin with a

equal sign (=)

What does access do when you link a table to another access database?

creates a new table called a linked table

A ___ query removes from a table based on criteria that you specify

delete

Duplicate values in a table can prevent you from

enforcing referential integrity

What do you do if you only want to export part of a table to excel?

filter the table first

___ allocate a certain number of characters for each field

fixed-length text files

Moving records from one table to another can be accomplished with the combination of what two types of queries?

Append and delete

The process of creating a make table query is very similar to which other typer of query?

Append query

Where is the Group Header located?

At the start of each new group

Which of the following fields enables you to add multiple files of different types of a table?

Attachment

What should be the first step taken before creating an update query?

Back up the database

After becoming familiar with the data in a database, what should be the first step when creating an action query?

Backup the database

What differentiates a hyperlink from text?

Blue underline

When creating a parameter query, the text phrase should be enclosed in which of the following?

Brackets [ ]

How do you hide details in a report?

Click Hide details in the Grouping & Totals group on the Design tab

To move a text box label, what action must you take?

Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected.

On a form, what type of control provides a drop-down menu displaying a list of options from which the user can choose a single value?

Combo box

Which type of control does a lookup field become in a form?

Combo box control

What should be done before converting a text box to a combo box?

Create a new table and enter the values for the option list

What is the first step in creating an append query?

Create a select query

What summarizes a data source into a grid of rows and columns?

Crosstab query

Which type of query calculates data using a sum, average, or other function and groups the results by two sets of values?

Crosstab query

Which of the following enables you to create mathematical functions in Access?

Expression builder

When exporting to a PDF, what should you check for when the objects are exported?

The number of pages

If you run a make table query again at a later time, what happens?

The table is replaced with the new up-to-date table

What is the purpose of a find unmatched query?

To compare records in two related tables and display the records found in one table and not the other

Where is the Page Header located?

Top of each page

What is the group footer used for?

Totaling the data at the end of each group

What must be present for a find unmatched query to work?

Two tables share a common field

A ___ is the location of a web site or web page on the internet

URL

Which of the following controls contains to decorative elements, such as the title of the report?

Unbound

Once records with missing data are found, what type of query can you use to add the needed information?

Update

What is the reason for making a form read-only?

Users can lookup information but not modify the data

What data validation method is designed to restrict the data values entered into a field?

Validation Rule

Which data validation method provides an error message when a validation rule has been broken?

Validation Text

When would a calculated field need to be added to a form or report?

When a formula is needed in the form or report

When are subforms created?

When the main form displays records from a related table

What does the type of data displayed in a cross tab query depend on?

Which aggregate function used when the query was created

When you double click on a document with a RTF file extension, which of the following programs does Windows open by default?

Word

What type of files are compressed by access when you attach them?

Word and excel files

The ___ file format is considered an alternative to PDF

XPS

How is a cross tab query different from other queries?

You can only reference one object (table or query) as the data source

Which application allows you to view XPS documents if the XPS viewer has not been installed?

Your browser

What happens when you double click an attachment in a table?

a dialog box opens with options

What happens each time you open an attachment file in access?

access creates a temporary file on your computers hard drive

What happens when you click a hyperlink field value while in Datasheet view?

access launches the program required to display the file or web page

Access is not able to ____ an attachment

analyze the data within

A ___ query can be used for adding records to an existing table

append

What can you do if a comparable table already exists when you import a spreadsheet?

append a copy of the excel records to the table

A ___ appears next to a linked table name in the Navigation Pane

arrow

In access, what is a reference to an external file called?

attachment

Which of the following allows you to manage attached files in forms and reports?

attachment control

A ___ is a control that is connected to a field in a table or query

bound control

A ___ contains an expression that generates a calculated result.

calculated control

How do you insert blank lines above a table after exporting it from access into word?

click immediately before the first value in the first cell of the table and press Enter to add an additional line

An append query is a query that

copies records from one table to another

Which of the following is NOT a correct way to add a calculated control to a form or report?

create a formula in a bound control


Ensembles d'études connexes

Impact of Globalisation in the UK

View Set

Management 478 Chapter 1 Smartbook

View Set

Lisez le chapitre, puis choisissez la bonne réponse

View Set

Social Work Practice with Addictions- SWK 330

View Set

Accounting 2 - Chapter 5: FIFO and LIFO, Inventory costing methods

View Set

AP English Literature & Composition A - Unit 3: Poetry: Language, Style, and Tone (All QuickChecks, Quizzes, Practice, & Unit Test)

View Set

First assesment Exam chapters 2-5/8-13 in no particular order (10/11 still not done)

View Set