Blackboard Quizzes CS 302

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Which of the following is true about adding cell borders?

A cell border extends the width of the cell.

Template

A database ___ is a tool that you use to quickly create a new database based on a particular subject.

Imported Spreadsheet Wizard

A feature called ___ helps you copy information from Excel to Access.

Which of the following statements describe a filter? Select all the options that apply.

A filter displays a temporary subset of records in the current datasheet. A filter is not as powerful as a query. In a datasheet, a filter displays only those records that match criteria you specify.

Category Footer the list keeps going like it doesn't sum up the whole problem like ex it would be 200 + 100 + 100, etc, etc,. on top of each other Report footer section it summarizes the total

The expression = Sum ( [ Revenue ) ] is contained in a text box in both the Category Footer as well as Report Footer sections. Explain the difference between these two controls.

What happens when you apply a theme to a form?

The formatting changes in all forms and reports

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

The formula =SUM(B6:B10)

False

The merge document is the Word document that contains the standard text for each form letter.

What is the most efficient way to navigate to the last record in a table containing 100 records?

Use the Last record button on the navigation bar.

AS YOU CREATE A REPORT WHEN MIGHT YOU WANT TO WORK IN REPORT LAYOUT VIEW?

WHEN YOU WANT TO VIEW THE DATA AS YOU CHANGE THE REPORT

Conditional Formating

What allows you to change the appearance of a control on a form or report based on criteria you specify.

Report Section Properties

What are the characteristics define each section?

TourName

What field is used as the grouping field?

True

When you publish data to Word form Access, an RFT format document is created.

RTF

When you publish to Word form Access, the resulting document is in which file format?

When should you use relative cell references?

When you want to preserve the relationship to the formula location.

TourName Footer

Which Section does not contain any control?

What might you need to do after increasing the font size in a table datasheet?

Widen the columns

What might you need to do after increasing the font size in a table datasheet?

Widen the columns.

Main document

Word document that contained the standard text for each mail-merge letter/label.

SWITCH THE APPEND ONLY PROPERTY TO ____ TO ALLOW USERS TO ADD DATA TO A LONG TEXT FIELD BUT NOT CHANGE OR REMOVE EXISTING DATA

YES

VALID ENTRY FOR THE TAB STOP PROPERT OF A FROM CONTROL

YES

WHAT HAPPENS IF YU DELETE A FIELD FROM A TABLE THAT CONTAINS DATA

YOU DELETE ALL DATA IN THE FIELD

Which data type stores only one of two values?

Yes/No

What are you doing when you enter data into a subdatasheet?

You are entering records in the related table.

Mutiple

You can add _______ conditional format(s) for any combination of selected controls

Which of the following is true of the Excel spell checker?

You can change all instances of a flagged word to a selected suggestion.

True

You can enter criteria in the Enter [ Parameter ] Value box for a parameter report.

[Square Brackets]

You can enter paramer criteria in Query Design view inside of

Which of the following statements are true about subdatasheets? Select all the options that apply.

You can use a subdatasheet to enter new records. You can click the expand button to view the records in a subdatasheet. They appear for a table on the "one" side of a one-to-many relationship.

True

You can use the Format painter to format lines, labels and text boxes

How can you list the records in a query datasheet in A-Z order by CustomerName?

Descending order

True

Exporting is the opposite of importing.

To import data from Excel to Access, you would begin by clicking the ____.

External Data tab

Which of the following options should one choose to prompt Excel to calculate all open workbooks manually?

F9

A FROM CONTROL WITH ITS FOCUS STOP PROPERTY TO YES WILL RECEIVE THE FOCUS IN FORM VIEW

FALSE

A REPORT IS AN EASY TO USE DATA ENTRY AND NAVIGATION SCREEN.

FALSE

A common place to use the Input Mask property is for a FirstName field.

FALSE

ACCESS ADDS @ SIGN AROUND DATE IN DATE/TIME FIELDS

FALSE

ALTERNATE COLORS ARE A SET OF CORDINATED COLORS TO APPLY TO REPORTS AND OTHER DATABASE OBJECTS.

FALSE

After creating a report with the Report Wizard, you cannot add a sort to the report.

FALSE

IN FORM DESIGN VIEW YOU CAN MAKE DESIGN CHANGES WHILE DISPLAYING DATA

FALSE

If you change data in its original location and it is linked to an Access database, you must also update the data in the Access database.

FALSE

If you export report data as and RTF or XML file, you can open the exported file in a browser.

FALSE

If you want to remove records for discontinued products from a Products table, created an Update query

FALSE

In Table Design view, "State must be AZ or CO" is an example of integrity text.

FALSE

In a report, label controls display data from underlying fields.

FALSE

Set the Database Title property of a database to change the text displayed in the title bar.

FALSE

TO DISPLAY FIELD VALUES AS CURRENCY OR PERCENTAGE USE DATA TYPE BOX IN TABLE DATASHEET VIEW

FALSE

The only way to create a Crosstab query is to use the Crosstab Query Wizard.

FALSE

To add a heading to the Detail section of a form, you use a text box control.

FALSE

To resize a control in Report Layout view, you format an edge of the selected control.

FALSE

Use the default field property to specify that an entry is required for the field.

FALSE

WHEN YOU ENTER DATA IN A LONG TEXT FIELD ACCESS AUTOMATICALLY EXPANDS THE ROW AND COLUMN

FALSE

When you convert a macro, you break it down, step by step, to observe the effect of each action.

FALSE

When you convert an Access macro to VBA code, the VBA is stored in a standard module listed in the Navigation Pane with a name that starts with "New Macro"

FALSE

YOU SWITCH TO REPORT LAYOUT VIEW TO DISPLAY THE ENTIRE REPORT AS WILL APPEAR PRINTED.

FALSE

You can use the Chart Wizard to add a chart to a form or query.

FALSE

You write VBA code in the Visual Basic Design Pane

FALSE

an access chart displays data in rows and columns, similar to a spreadsheet

FALSE

to review a printout of a table before printing, on the ___tab, click print preview.

FILE

Which of the following statements describe Query Design view? Select all the options that apply.

Field lists appear in the upper pane of Query Design view. The query design grid provides a way to sort records. Query Design view lets you modify an existing query.

To print more than one copy of your worksheet, which tab would you go to?

File

Which of the following tabs lets you set worksheet print options?

File

On which tab and button are document properties located for editing?

File tab, Info Button

The _____ property controls how many characters can be entered into the field.

Filed Size

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Fill handle

To filter for comparative data, use the _____ feature

Filter By Form

To filter for comparative data, use the _____ feature.

Filter By Form

The easiest way to filter the records for an exact match is to use the _____ feature.

Filter By Selection

A customer has moved to a new address in the same city. What Access feature can you use to quickly change the customer's address in a table datasheet that contains hundreds of records?

Find and Replace

If you want the State field to display "Iowa" in each new form record, you set the Control Value property for the State field.

False

In Access, you create a macro by recording a series of steps you want the Marco to perform.

False

In Form Design view, you can make design changes while displaying the data.

False

In Report Layout view, you use the Format Painter to change the theme of a report.

False

In Table Datasheet view, you must use a property sheet to increase the decimal places in a Number field.

False

In a datasheet, you can find data, but not replace it.

False

Press ESC to remove editing changes you made to the previous record.

False

Query for zero-length values by entering Is Null as the criterion.

False

Sorting a table datasheet temporarily displays only those records that match given criteria.

False

The Alternate Background Color command changes the background color of alternate records in a selected section.

False

To navigate to the first record in a form, first switch to Form Design view.

False

To rename a form, open the form, and then use the Rename command on the Home tab.

False

Use Query Design view to display the results of a query.

False

Use a Number field to store values that represent money.

False

Use the New (blank) record button to move the focus to the first record in a table.

False

Use the New (blank) record button to move the focus to the first record in the table.

False

When you double-click an Access database icon, you have the choice of opening a database or creating a new one.

False

When you import Excel data into an existing Access table, you relate the data to the table.

False

When you import Excel data, you create a link to the data in the Access database.

False

When you import data from Excel, you use the link option to add the Excel data to an existing Access Table.

False

When you start Access, the first screen that appears is one showing a blank database.

False

You add the Calculation row to the query design grid to specify how you want to group records and perform calculations on them.

False

You can use the Chart Wizard to add a chart to a form or query.

False

You cannot modify the Field Size property of a Short Text field.

False

You use a subdatasheet to modify a field's properties.

False

A category of data such as a customer's name, city, state, or phone number is called a _____.

Field

Which two properties are required for every field?

Field Name and Data Type

which two properties are required for every field?

Field Name and Data Type

For a State field that stores two-letter state abbreviations, you can set the _____ property for the field in Table Datasheet view.

Field Size

The _____ property controls how many characters can be entered into the field.

Field Size

False

Importing is a process to quickly link to, but not copy data from an external source to an Access database.

True

In Access parameter reports, you can shorten date criteria by entering only two digits for the year instead of four.

Group & Sort button

In Report Design View, if you want to view the grouping and sorting fields, click the

True

In Report Design View, lines can be difficult to find when they are against the edge of a section of the edge of another control

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Page Layout

To see a preview of how a pasted value will look, which of the following would you use?

Paste List arrow

Theme

Predefined format that you can apply to all objects in the database

When editing a record using a form, how can you move from field to field in the same record?

Press TAB

Where can you see a preview of how your worksheet will look when printed, including headers?

Print tab in Backstage view

To print your worksheet at its actual size, which of the following would you select?

No scaling

As you create a report, when might you want to work in Report Layout view?

Not: When you want to view the report without any formatting

What are you doing when you enter data into a subdatasheet?

Not: You are enforcing referential integrity.

The two types of control layouts Access provides for forms are stacked and _____.

Not: subform

Which of the following are Access data types? Select all the options that apply.

Number Currency Date/Time

BEFORE DELETING A QUERY YOU CAN VIEW ITS _____________ TO DETERMINE IF ANY OTHER QUERIES, FORMS, REPORTS DEPEND ON THAT QUERY

OBJECT DEPENDECIES

Open Database Connectivity

ODBC stands for ___.

IF YOU SET THE CAPTION PROPERTY OF A FROM, WHERE DOES THE CAPTION TEXT APPEAR?

ON THE FORM TAB IN FORM VIEW

TO SET A VALIDATION RULE FOR AN ENTIRE TABLE YOU

OPEN THE PROPERTY SHEET FOR THE TABLE

true

The report that contains the subreport control is called the [ main ] report.

Record Source

The report's _________ property determines what table or query provides the fields and records for a report.

True

Themes can include font, color, and alignment choices

IF THE FOCUS MOVES IN A FROM FROM TOP TO BOTTOM CHANGE THE

TAB ORDER

A TYPICAL REPORT IN LANDSCAPE ORIENTATION IS 11 INCHES WIDE AND 8.5 INCHES TALL

TRUE

A function created in a standard module can be used in any query in the database.

TRUE

Before you can edit actions in Macro Design View, you might need to click the Expand All button on the Macro tools Design tab to display all the actions.

TRUE

CAN YOU USE THE ARROW KEYS TO MOVE A SELECTED CONTROL IN REPORT DESIGN VIEW

TRUE

Entering an expression such as =[Price]*[Quantity] in a text box creates a calculated control.

TRUE

FORM WIZARD PROMPTS YOU FOR INFO IT NEEDS TO CREATE A FROM, SUCH AS THE FIELDS, LAYOUT, AND TITLE FOR FORM

TRUE

IF YOU CHOSE FIELDS FROM 2 RELATED TABLES IN FORM WIZARD YOU CAN CREATE A MAIN FORM WITH A SUBFORM

TRUE

IN DATA SHEET VIEW AN ATTACHMENT FIELD APPEARS AS A PAPER CLIP RATHER THEN FIELD NAME

TRUE

IN FORM DESIGN VIEW YOU CAN ALIGN CONTROLS AND THEIR CONTENTS

TRUE

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

TRUE

In Form Design view, you can align control and their contents.

TRUE

In the criterion 8/*/2021, the asterisk (*) is called a wildcard.

TRUE

ONE WAY TO GROUP OBJECTS IN THE NAVIGATION PANE IS BE OBJECT TYPE

TRUE

One way to group objects in the Navigation Pane is by object type.

TRUE

Report Design view gives you full control of all aspects of a report.

TRUE

TO ADD TOTALS TO A REPORT COLUMN IN REPORT DESIGN VIEW YOU CREATE A CALCULATE CONTROL

TRUE

TO VIEW A LIST OF THE DATABASE OBJEST THAT DEPEND ON SELECTED OBJECT OPEN OBJECT DEPENDECIES PAGE

TRUE

The lower pane of a spit form displays a(n) data sheet view.

TRUE

The text you specify for the Application Title property appears in the title bar instead of the database filename.

TRUE

To delete an action from a macro, point to the action in Macro Design View, and then click the Delete button

TRUE

To display the VBA code for a form, click the Build button in one of the form's event properties.

TRUE

Use the Align button on the Arrange tab to align the edges of the controls.

TRUE

WHEN YOU DELETE A CONTROL FROM A FORM YOU ASLO DELETE THE DATA IT CONTAINS

TRUE

YOU CAN ADD A LINE TO A REPORT TO INDICATE A SUBTOTAL

TRUE

YOU CAN USE THE OLE OBJECT DATA TYPE OR THE ATTACHEMENT DATA TYPE TO STORE A PICTURE

TRUE

YOU USE CONDITIONAL FORMATTING TO HIGHLIGHT IMPORTANT DATA IN A REPORT

TRUE

YOU USE THE FIELD LIST TO ADD FIELDS TO A FORM, IN FORM DESIGN VIEW

TRUE

You can collapse all actions in a macro to hide its details.

TRUE

You can use a function created in a standard module in any query in the database.

TRUE

before using the chart wizard, you should plan which fields you want the chart to display.

TRUE

in a CSV text file, a comma often separates each field value from another field value.

TRUE

YOU USE REPORT TOOL TO QUICKLY CREATE A REPORT BASED ON THE SELECTED TABLE.

TURE

The upper pane of _____ view shows field names and data types.

Table Design

_____ view provides the most options for defining fields

Table Design

_____ view provides the most options for defining fields.

Table Design

_______ view provides the most options for defining fields

Table Design

Email

To export a report as an email attachment, click the ___ button in the Export group of the tab on the Ribbon.

Which of the following is a difference between Table Design view and Table Datasheet view?

Table Design view does not display data.

_____ is the default name for a new table in an Access database.

Table1

1) For a Comments field that contains many words, set a Long data type.

True

1) In Query Design view, the query grid shows the names of the fields and tables involved in the query.

True

1) The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

True

1) To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

True

1) To add, delete, or change fields in a query, you use Query Design view.

True

1) To enter data in a table, open it in Table Datasheet view.

True

1) To move a field in Query Design view, you drag the field by its field selector.

True

1) Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

True

1) You can create a table in Table Datasheet view or Table Design view.

True

1) You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

True

A new blank desktop database includes one table named Table1

True

A new blank desktop database includes one table named Table1.

True

After you hide a field in a datasheet, you can redisplay the hidden field using a shortcut menu.

True

If a City field displays the value "Chicago" for a new record, that means the Default Value property for the City field has been set.

True

The Import Spreadsheet Wizard can help you import data from Excel into a new Access table.

True

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

True

To add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

True

To add, delete, or change fields in a query, you use Query Design view.

True

To create a report in Report Layout view, click the Blank Report button on the Create tab.

True

To learn more about a data type, you can enter the name of the data type in the Tell Me box.

True

To move a field in Query Design view, you drag the field by its field selector.

True

To rename a table, you must use the Navigation Pane.

True

Using "CA" as the criterion in a Short Text field is the same as using "ca" or "Ca" as the criterion.

True

When a record from one table is related to several records in another table, the tables have a one-to-many relationship.

True

When you delete a column from a table in Table Datasheet view, you delete the field and all of its data.

True

When you import data from Excel, you can create a new table or add the records to an existing table.

True

You can add a Total row to a query datasheet to calculate statistics such as Sum, Average, or Count.

True

You can assign most but not all data types to a field in Table Datasheet view.

True

You can create a table in Table Datasheet view or Table Design view.

True

You can set the Field Size property for a field with a Short Text data type.

True

You use the Report tool to quickly create a report based on the selected table.

True

To align currency symbols and decimal points in a column of numbers, you can apply the ____ number format.

Accounting

"many" table

Cascade Delete Related Records automatically deletes all records in the ___ if the record with the matching field key in a "one" table is deleted.

False

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

How can you display the title of a report in green?

Change the font color of the label in the Report Header.

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?

Change the page orientation to landscape.

Conditional Formatting

Changes the way a control looks on a form or report based on criteria you specify

What should you do before applying a new filter to a datasheet?

Clear all previous filters

what should you do before applying a new filter to a data sheet?

Clear all previous filters

What should you do before applying a new filter to a datasheet?

Clear all previous filters.

What property do you use to set the Graduated text box in a form to display "Yes" in each new record?

Default Value

Which of the following are properties you can set for a Currency field? Select all the options that apply.

Default Value Format Decimal Places

How do you display the records in a subdatasheet?

You click the expand button in the datasheet

How do you display the records in a subdatasheet?

You click the expand button in the datasheet.

Record source

You create a parameter report based on a parameter query by setting the report's ________ property

What happens if you delete a field from a table that contains data?

You delete all the data in the field.

false force

You modify the [ set ] New Page property of a section to force each section to start printing at the top of a new page.

Adobe Reader

You read PDF document with ___ software.

True

You use conditional formatting to highlight important data in a report

false conditional

[ Parameter ] formatting allows you to change the appearance of a control on a form or report

which of the following keys will help you delete unwanted data in edit mode?

[Backspace]

which keystroke combination moves focus to the last field of the last record?

[Ctrl][End]

which editing keystroke deletes on character to the right of the intersection point?

[Delete]

in the navigation mode, press [Tab] or ___ to move to the next field within the same record.

[Enter]

which shortcut key moves focus to the previous field of the current record?

[Shift][Tab]

which shortcut key moves focus to the first field for the current record?

[home]

what happens when you run a query from Query Design view?

access displays a data sheet containing the query results

when you edit a record, pressing ESC once removers the changes to the field. What happens if you press it a second time?

access removes all changes to the record

OpenReport is an Access macro

action

when you double-click a field in a field list in query design view, it is ___.

added to the next available position in the query grid

When can you rename a table?

after you close the table

you can add a command button to a form using the command button wizard, one of many ______ wizrds access offers.

control

You use Query Design view to add _____ to limit the number of records shown in the resulting datasheet.

criteria

__ are tests or limiting conditions you set to determine which records will be selected in a filter or query

criteria

you use query design view add __ to limit the umber of records shown in the resulting data sheet

criteria

A ______ query in a real estate database could list property types as row headings, number of bedrooms as column headings, and the count of each property type as values.

crosstab

access saves ___ automatically as you move from record to record

data

The _____ key field is the linking field on the "many" side of the relationship.

foreign

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

form highest to lowest Price

in large data sheets, you can _____ certain fields so that they remain on the screen at all times.

freeze

in large dottiest, you may want to ___ certain fields so that they remain on the screen at all times.

freeze

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the datasheet list records if you add a descending sort to the Price field?

from highest to lowest Price

If the query design grid contains three fields named ProductName, Price, and DateOrdered, how does the data sheet list records if you add a descending sort to the Price field?

from highest to lowest price

Which of the following is a built-in formula that helps you perform complex calculations?

function

the button in the accompanying figure ____.

helps you navigate to the first, previous, next, last or new record

Because it can be dangerous to leave action queries in the Navigation Pane, you can _____ an action query you want to run again.

hide

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

hide

Which of the following is an appropriate entry for the Hyperlink Address property of a form control?

http://www.cengage.com

Which data type stores web addresses?

hyperlink

which data type stores web addresses

hyperlink

which data type stores web addresses?

hyperlink

you can use the ____ to copy data from excel to access

import spreadsheet wizard

Which process is most like copying and pasting?

importing

You use the Insert Rows button on the Query Tools Design tab to _____.

insert a row in the query design grid

Using the Report Wizard, you can select the _____ for the report.

layout

What does the criterion <=200 mean?

less than or equal to 200

A join line is also called a _____ line.

link

a join line also called a(n) ___ line.

link

in the accompanying figure, the item with the infinity sign at one end and the number 1 at the other is called a(n) __ line.

link

Query Design view presents the fields you can use for a query in small windows called field _____

lists

query design view presents the fields you can use for the query in small windows called field ___.

lists

a query datasheet is sometimes called ___ of the data.

logical view

When you are finished creating a report with the Report Wizard, you can choose to preview the report or

make changes/edit it

When you finish creating a report with the Report Wizard, you can choose to preview the report or _____.

modify the report's design

when you finish creating a report with the Report Wizard, you can choose to preview the report or

modify the report's design

When you select a control in Form Design view and then press an arrow key, you _____ the control.

move

If you want to manage lists of data about customers and the products they order, use _____ software.

relational database

while editing a record, pressing[Esc] twice ___/

removes all the changes made to the record you are currently editing

Besides reducing file size, what other benefit does compacting an Access database provide?

repairing the database

besides reducing file size, what other benefits does compacting an Access database provide?

repairing the database

When you select a control in Form Design view, you can use ______ to resize the control.

resizing handles

to close a report in report design view while keeping the database open, you

right click the report tab and then click close

to close a form in Form Design view and keep accessing running, you _____

right-click the form tab, then click Close on the shortcut menu

The Crosstab Query Wizard asks you to select fields for the _____, column headings, and values.

row headings

When you single step a macro, you

run the macro one action at a time

To delete a field in Table Datasheet view, you click _____.

the column heading for the field

to delete a field in Table Datasheet view, you click

the column heading for the field

to learn more about a data type, you can enter the name of the data type in the Tell Me box.

true

to perform calculations on field values in the Table Datasheet view, you click the Totals button in the Records group on the Home Tab

true

using "CA" as the criterion in a Short Text field is the same thing as using "ca" or Ca"

true

when using the Report Wizard, you can click the back button to review previous dialog boxes.

true

you can use the Compact and Repair database button on the Database Tools tab to reduce the size of the database

true

you might delete and employee record if the employee no longer works for the company

true

To reverse the last action you took in a database, click the _____ button

undo

what is the most efficient way to navigate to the last record in a table containing 100 records?

use the Last Record button on the navigation bar

Before you close a query datasheet, you must save your changes to the data.

False

Compacting a database has the same result as backing up a database.

False

Database templates create tables and queries, but not forms and reports.

False

Hiding a column in Table Datasheet view is that same as freezing the column.

False

You can use the _____ to copy data from Excel to Access.

Import Spreadsheet Wizard

____ makes a duplicate copy of the data in the Access database

Importing

____ makes a duplicate copy of the data in the Access database.

Importing

All of the above

Item 2 helps you

Add controls to the report that are not currently visible

Item 5 helps you

add controls

Items 5 helps you

CORRECT SYNTAX FOR DATE/TIME

#

which of the following criteria uses the correct syntax for a date/time field in a query?

##

Which of the following criteria uses the correct syntax for a Date/Time field in a query?

#5/7/2021#

Which startup command-line option opens the database for exclusive access?

'/excl

How many actions does the Undo button let you reverse?

100

What Field Size should you set for a State field that stores two-character state abbreviations?

2

If you set the Decimal Places property to 0 for a Price field, and then enter 750.25 in the field, what does Access display in the datasheet?

750

Which of the following are examples of correct criteria syntax? Select all the options that apply.

<= 33.50 >= #1/1/2021# < "Anderson"

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

=COUNT(B1:B20)

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

=COUNTA(B1:B20)

What criterion would you use to find numbers greater than or equal to 100?

>=100

Excel

A Microsoft application that allows the user to create spreadsheets.

Delimited

A ___ text file typically contains one record on each line, with the field values separated by a common character.

RTF

A ____ file contains field values separated by a common character; this could be a comma, tab, dash, or other character.

Report

A ______ gives you more control over how data is printed than forms and datasheets

Parameter Report

A ______ prompts you for criteria to determine the records to use for the report.

What is the difference between entering a record using a form and entering a record using a datasheet?

A form presents records one at a time, while a datasheet lists all records.

Which of the following import options means data is not copied from Excel to Access, but stored in the original workbook?

A. Link

____ view provides the most options for defining fields.

A. table design

IF YOU WANT TO CREATE A TOP-TO-BOTTOM AND LET-TO-RIGHT TABLE ORDER CLICK ________IN THE TAB ORDER DIALOG BOX

AUTO ORDER

Which of the following functions would you use to calculate the arithmetic mean of a price list?

AVERAGE

Which of the following are advantages of using Microsoft Access to manage data? Select all the options that apply.

Access allows more than one user to enter data at the same time. Access provides data-entry forms. Access minimizes duplicate data.

What happens when you run a query from Query Design view?

Access displays a datasheet containing the query results.

When you edit a record, pressing ESC once removes the changes to the field. What happens if you press ESC a second time?

Access removes all changes to the record.

What could you do to clarify that the MonthyRent feld in a report contains dollar amounts?

Apply the currency format

To list values in a Number field in order from lowest to highest, you use the _____ button.

Ascending

When you double-click a cell's right column border, which of the following occurs?

AutoFit resizes the column to the widest cell entry.

Which data type is used for sequential integers controlled by Access?

AutoNumber

Which of the following inserts a function into a cell?

AutoSum button

which access object provides an easy-to-use data entry screen?

B. form

which of the following is NOT a data type?

B. formula

which of the following is NOT available to you as you start access?

B. recalibrating an existing database

To back up a database, you use the _____ command

Back Up Database

To back up a database, you use the _____ command.

Back Up Database

What should you do if you want to make a copy of a database in a secure location?

Back up the database.

Which of the following templates lets you create a database from scratch?

Blank desktop database

When you cut or copy a cell, it is cut or copied to which of the following?

Both the Windows and Office Clipboard

microsoft access can best be described as ____ software.

C. database

which is NOT true about access?

C. reporting is limited to 20 saved reports

which access object contains all of the raw data within the database?

C. table

HOW CAN YOU DISPLAY TITLE O REPORT IN GREEN?

CHANGE FONT COLOT OF THE LABEL IN REPORT HEADER

a control on a from in Form view it meas yes or true

CHECK BOX

TO DELETE A FIELD IN TABLE DATASHEET VIEW YOU CLICK

COLUMN HEADING FOR THE FIELD

HOW CAN YOU HIGHLIGHT REPORT RECORDS THAT INCLUDE VALUES GREATER THAN 500$ IN THE ORDER AMOUNT FIELD?

CONDITIONAL FORMATTING

A CONTROL LAYOUT IN AN ACCESS REPORT IS A

CONNECTED SET OF REPORT CONTROLS

What Access tool can you use to enter dates in a Date/Time field?

Calendar Picker

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.

How can you list the records in a query datasheet in A-Z order by CustomerName?

Click a value in the CustomerName field, and then click the Ascending button

Subreport

Click item 5 to add a ____ to a report.

How can you quickly add the date and time to a report in Report Design view?

Click the Date and Time button on the Design tab

In Form view, how can you navigate to the previous record in the form?

Click the Previous record button on the navigation bar.

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

Clipboard

Use the _____ to exit Access.

Close button

What should you do when you are finished working a database?

Close the database

What should you do when you are finished working a database?

Close the database.

Merge fields

Codes that are replaced with values in a field during a mail merge process are called ___.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

Color

Reports

Compared to forms and datasheets, _________ gives you more control over how data is printed and greater flexibility in presenting summary information.

True

Conditional Formatting allows you to compare the values of one column to another with small data bars

Format Painter

Copies formatting properties from one control to another

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Copy pointer

Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options thatapply.

Count Sum Average

What data type is most appropriate for a field named PaymentAmt?

Currency

What data type should you assign to a WeeklySalary field?

Currency

You typically increase the decimal places from 1 to 2 for a(n) _____ field.

Currency

You can right-click the status bar to display the _____.

Customize Status Bar shortcut menu

which data type is use for sequential integers controlled by access?

D. autonumber

which is NOT a feature of access reports?

D. easy-to-use data entry screen

WHAT IS THE RESULT OF SELECTING A TEXT BOX IN REPORT DESIGN VIEW AND THEN CLICKING THE CENTER BUTTON ON THE HOME TAB?

DATA ENTERED IN TEXTBOT

When editing a record, what key can you use to navigate to the next record?

DOWN ARROW

Mail Merge

Data from an Access object is combined with a Word label or letter.

False

Database templates create sample tables and queries, but not forms and reports.

True

Databases created by templates can be modified for your specific needs.

In an Employees table, what is the appropriate data type for a field that shows the hiring date?

Date/Time

Changing the _____ property for a field does not change the actual data stored in the field.

Decimal Places

If a field named Price displays values with three decimal places, what should you do to display the values accurately?

Decrease the number of decimal places.

8 inches

Default Margins are often 0.25 inches in Report Design View. For a report printed in portrait orientation on a8.5x11 paper this means that the report can be no wider than ___________.

What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?

DiscountPrice: [Price]-10

1. You might want each new group header to print at top of a page. 2. To format that section with a background color

Discuss 2 reasons you might want to modify section properties in a report

Which of the following lets you edit the contents of a cell?

Double-click the cell or click in the formula bar.

Which of the following is the fastest way to open an Access database?

Double-click the database icon

Which of the following is the fastest way to open an Access database?

Double-click the database icon.

How do you display the results of a query listed in the Navigation Pane?

Double-click the query

Which of the following are ways to run a query? Select all the options that apply.

Double-click the query in the Navigation Pane. Click the View button in Query Design view. Click the Run button in Query Design view.

How do you display the results of a query listed in the Navigation Pane?

Double-click the query.

False

Double-clicking the Format Painter button formats all controls in that section with the formatting characteristics of the currently selected control.

It summarizes the info for that report

Doug builds the report shown in the accompanying figure, How did Doug group the records and why might he have the TourName Footer section open even though there are no controls in that section.

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

Edit the conditional formatting rule.

In an IF statement, the _____ statement is executed when all IF and ElseIF statements evaluate to false.

Else

IN A SALE DATE FIELD YOU CAN DISPLAY DATES AS 03-JAN-21 BY SELECTING MEDIUM DATE AS THE _____ PROPERTY

FORMAT

WHAT HAPPENS WHEN YOU APPLY A THEME TO A FORM

FORMATTING CHANGES IN ALL FORMS AND REPORT

1) A field with the Currency data type contains values such as quantities, measurements, and scores.

False

1) A form selects a subset of fields & records from one or more tables, & then presents selected data as a single datasheet.

False

1) A query is a temporary view of the data that is removed when you close the query in Query Design view.

False

1) After you create a table, you must save the entire database so you do not lose the new table.

False

1) Before you can rename a field, you must change its data type.

False

1) Before you close a query datasheet, you must save your changes to the data.

False

1) Compacting a database has the same result as backing up a database.

False

1) In a datasheet, you can find data, but not replace it.

False

1) Of all the database objects, a table provides the most formatting, layout, and summary options.

False

1) Press ESC to remove editing changes you made to the previous record.

False

1) Sorting a table datasheet temporarily displays only those records that match given criteria.

False

1) Sorting records in ascending order based on a Short Text field arranges them in alphabetic order from Z to A.

False

1) Table Design view shows how each table relates to other tables in the database.

False

1) To delete a field from a query, drag the field out of its field list.

False

1) To display data, it needs to be in Table Design.

False

1) To navigate to a record in a table, switch to Table Design view.

False

1) To rename a form, open the form, and then use the Rename command on the Home tab.

False

1) When you add a field to a table in Table Design view, entering the field name is optional.

False

1) When you double-click an Access database icon, you have the choice of opening a database or creating a new one.

False

1) When you enter a record in a table, you are working in navigation mode.

False

1) When you import Excel data into an existing Access table, you relate the data to the table.

False

1) You can enter, edit, and navigate data in a query datasheet just like a report datasheet.

False

A form selects a subset of fields and records from one or more tables, and then presents the selected data as a single datasheet.

False

A report is an easy-to-use data entry and navigation screen.

False

A subdatasheet shows the records on the "one" side of a one-to-many relationship.

False

Access adds @ signs around date criteria in Date/Time fields.

False

Access provides a single database template for creating a blank database.

False

After you create a table, you must save the entire database so you do not lose the new table.

False

Alternate colors are a set of coordinated colors to apply to reports and other database objects.

False

Before closing a form in Form view, you must save changes you made to the data.

False

Before you can rename a field, you must change its data type.

False

Before you close a database, you must save any changes you made to the data.

False

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

Flash fill

A _______ refers to a collection of characters with a similar, specific design.

Font

To change the color of cell content, you use the ________ color list arrow.

Font

To align the edges of multiple controls in Form Design view, you use the Align button on the _____ tab.

Form Design Tools Arrange

Which of the following properties can you apply to a Number field in Report Design view? Select all the options that apply.

Format = Currency Decimal Places = 0 Decimal Places = 1

What should be chosen as X in the given series of clicks to calculate formulas automatically except for data tables: File < Options < X < Automatic?

Formulas

What would you choose as X in the given series of clicks to calculate formulas automatically: File < Options < X < Automatic?

Formulas

Which of the following should be selected as X in the given series of clicks to set formulas for manual calculation: File < Options < X < Manual?

Formulas

to add a sort to a report in Report Design view you must use the _____ button.

GROUP & SORT

Mail Merge Task Pane

Helps you step through the process form Access with a Word label or letter.

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

Hidden

To highlight information or enhance its clarity

How are lines used in a typical Access report?

Which data type stores web addresses?

Hyperlink

in the relationship window which symbol identifies the field on the many side of the relationship

INFINITY SYMBOL

HOW CAN EXAMINING OBJECT DEPENDENCIES HELP YOU WHEN DEVELOPING A DATABASE

IT CAN PREVENT YOUR FROM DELETING A QUERY USED BY ANOTHER OBJECT

Access 194 and 198

Identify at least to major ways you can improve report formatting productivity

Prevents the creation of orphan records

If referential integrity is applied to a one-to-many relationship, what happens?

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

Ignore All

False

In a report, label controls display data from underlying fields

False

In the Accompanying figure, click the button identified as item 1 to change the Force New Page property.

2

In the accompanying figure, how many controls are in the Category header section?

Category

In the accompanying figure, what is the grouping field?

If a field contains the value 1.204 but displays the value 1.2, what can you do to show the entire value?

Increase the number of decimal places.

Where can you see a brief description of a selected function?

Insert Function dialog box

Which of the following lets you search for a function or select one from a category?

Insert Function dialog box

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?

Insert Pie or Doughnut Chart

Merge Field

Is replaced with the value in the field that the code represents.

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations.

False

It is necessary for each report to have at least one control in the Detail section

False

It is necessary for every report to have Report Header and Report Footer sections

False

It is necessary to keep all of the report sections the same height in order for the report to display properly

It actually lets me know the information like everything its describing

Jim builds the report shown in the accompanying figure how has jim grouped the records and what does that tell you about the information he is trying to emphasize in this report?

Group footer/ Report footer Calculate summary statistics on group records

Kelsey uses access to track the sales by category for each tour. Referring to the accompanying figure, what is the name of the field she should use in an expression to total the sales?

IN _______ VIEW, YOU CAN MAKE SOME DESIGN CHANGES TO A REPORT WHILE YOU ARE DISPLAYING DATA

LAYOUT

USING THE REPORT WIZARD YOU CAN SELECT THE ________ FOR THE REPORT

LAYOUT

YOU CAN ADD FIELDS TO A FORM IN DESIGN VIEW OR

LAYOUT VIEW

You can add fields to a form in Design view or _____

Layout view

False

Linked tables cannot be related to other tables in an Access database.

A RPORT WITH _______ IS A GOOD CANDIDATE FOR MULTICOLUMN REPORT

MANY FIELDS

YOU CAN ____ THE COLUMNS TO CREATE A SINGLE COLUMN

MERGE

To have Excel enter the lowest price from a range of prices, which of the following would you use?

MIN function

WHEN YOU SELECT A CONTROL IN FORM DESIGN VIEW AND THEN PRESS AN ARROW KEY YOU ________ THE CONTROL

MOVE

IF YOU MOVE A TEXT BOX IN FORM DESIGN VIEW YOU

MOVE LABEL ASSOCIATED WITH TEXT BOX

To replace "coffee" with "beverage" in any part of a field, you click the ____ in the Find and Replace dialog box.

Match arrow

True

Merge fields are codes that are replaced with the field values when the mail merge is processed.

True

Microsoft often changes and updates online templates.

When working in Table Datasheet view, which button on the Table Tools Fields tab can you use to change the expression in a calculated field?

Modify Expression

The ______ is the wildcard character that stands for any single character in criteria

NOT * (?)

What must you do before renaming a table in the Navigation Pane?

NOT C

The easiest way to filter the records for an exact match

NOT filter by form or advanced filter filter by selection?

In the _____, Access lists each object in the open database.

Navigation Pane

In what part of the Access window do you rename a form?

Navigation Pane

True

One use of a database created by a database template is to help you learn more about Access.

You can import Access table data from which of the following Office apps? Select all the options that apply.

Outlook Access Excel

WHERE DO YOU SPECIFY THE NUMBER OF COLUMNS FOR A REPORT

PAGE SET UP DIALOG BOX

HOW DO YOU SELECT A ROW IN A CONTROL LAYOUT IN REPORT LAYOUT VIEW

PRES AND HOLD SHIFT KEY AND THEN CLICK A CONTROL IN ROW

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Page Break Preview

Parameter report

Prompts the use for criteria to select records for a report

WHEN USING THE FORM WIZARD YOU CAN SELECT FIELDS FROM TABLE AND __________ IN THE DATABASE

QUERIES

You can create an Access report by selecting fields from one or more tables or _____.

Queries

determines the underlying table or query for a form

RECORD SOURCE

DELETING A TEXTBOOK IN FORM LAYOUT VIEW

REMOVES THE TEXT BOX FROM THE FORM

if you create a blank form, you must set the ____ property to display date on the form.

Record Source

In a datasheet, what do you click to select a record for deletion?

Record selector button

_____ is a set of Access rules that governs data entry and helps ensure data accuracy.

Referential integrity

In the formula =A8*$A$1, which of the following describes A8?

Relative cell reference

Besides reducing file size, what other benefit does compacting an Access database provide?

Repairing the database

Which of the following views provides the most options for creating and modifying a report?

Report Design View

True

Report Design View gives you full control of all aspects of a report.

When you click the Blank Report button on the Create tab, Access opens a blank report in _____.

Report Layout view

Which Access tool guides you through the steps of creating a report?

Report Wizard

false can

Report section properties [ cannot ] be modified to improve report printouts

True

Report sections have properties

Which of the following are Access objects?

Reports Forms Queries

How do you rename a table?

Right-click the table in the Navigation Pane, and then click Rename.

IF YOU ________________ FROM RELATED TABLES IN THE FORM WIZARD, YOU CAN CREATE FORM WITH SUBFORM

SELECT FIELDS FROM RELATED TABLES

Which of the following tools can you use to create a query?

Simple Query Wizard

Which of the following are views you can use to display a query? Select all the options that apply.

SQL view Query Datasheet view Query Design view

allows you to work with records related to the record in the main form

SUBFORM

What data type should you assign to a WeeklySalary field?

Salary

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

Save the table

Suppose you rename a field in Table Design view. What must you do before you can view the data in the table?

Save the table.

Run the steps in a saved export using the _____ button on the External Data tab.

Saved Exports

Which of the following are tasks you perform when creating tables? Select all the options that apply.

Select a data type for each field. Define the fields in the table. Name the table.

In a database with Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

Select query with an outer join

Which of the following is a best practice when you are creating a table containing employee names?

Separate the first and last names into two fields.

What data type should you assign to a field that stores postal codes?

Short Text

grand totals

Short double lines under the calculations in the Report Footer section Indicate ______

What button do you use on the Query Tools Design tab to add a field list to a query?

Show Table button

Summary Report

Shows statistics on groups of records

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Shutter Bar Open/Close button

When you use the _____, Access asks you for the information it needs to create a query.

Simple Query Wizard

Online

Some templates are ___ which means they are available to download from the Microsoft Office Online Wed site.

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

Startup

Which of the following will you select as X in the following series of clicks to change the chart style: Chart > Chart Style > X > Any Chart Style?

Style

a [ Theme ] displays a report within another report

Subreport

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____

Sum

To total the values in a SalesPrice field in Table Datasheet view, you click the Total cell in the SalesPrice column, click the arrow, and then click _____.

Sum

Which of the following statistics can you calculate in the Total row for a Currency field in Table Datasheet view? Select all the options that apply.

Sum Average Count

Detail

Summary reports typically have no controls in which section?

False

Swipe and drop is a technique to copy Access data to another application.

What can you use to find information about Access commands and features and instructions about how to use them?

Tell Me box

detail

Text boxes are positioned in the _____ section

What happens if you hide the Bonus column in the Employees table in Table Datasheet view?

The Bonus column no longer appears in the datasheet, but is still part of the Employees table.

Which of the following statements is true about COUNT functions?

The COUNT function returns the number of calls in a range that contain numeric data

True

The Group, Sort, and Total panes allows you to open group header and footer sections

False

The RTF can be opened and edited in Microsoft Word.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

The Undo button on the Quick Access toolbar

What happens when you close a module?

The Visual Basic window closes.

false format

The [ Theme ] painter is a tool you use to copy multiple formatting properties from one control to another.

Detail

To create a report that shows only group summary information delete all of the controls in the _________ section.

Detail

To create a summary report, you should delete all of the controls in the _______ section of the report.

True

To move a control from one report section to another, use cut and pase

To apply the last filter you selected to a datasheet, you click the _____ button.

Toggle Filter

What can you add to a query datasheet to display statistics for a group of records?

Total row

Force New Page Property

What helps you start printing a section at the top of the new page?

Themes

What is predefined formats that you apply to the database to set all of the formatting enhancements such as font, color, and alignment.

Combo box

What type of control is NOT found in the Page Header section?

Double lines

What type of line under a value indicates grand totals?

Report Design view

What view allows you to work with a complete range of report, section, and control properties.

SubReport

Which control is used to add a report to another report?

Name a form Startup

Which is NOT a way to set up a startup form?

[Shift]

Which key do you press and hold to create a perfectly horizontal line?

Changing the value of the control

Which of the following is NOT an option in the Conditional Formatting Rules Manager dialog box?

Field values

Which of the following is NOT changed within a theme

Print

Which of the following is not a category tab in the Property SHeet?

Parameter report

Which of the following reports would be the most logical choice for a Vice president who is interested in high level, aggregated totals, and not individual details?

Import the source data into a new table in the current database

Which option would you choose to copy data into a new table in the existing database?

Importing

Which process is most like copying and pasting?

Word

Which program would be best suited to entering, editing, and managing larger paragraphs of texts?

Page Header

Which report section is most commonly used for titles, dates, and page numbers?

Group Footer

Which report section is most commonly used to calculate a summary statistic on a group of records?

Detail

Which report section prints once for every record?

Group header

Which report section would be the most logical choice to display the grouping field value?

Report header

Which report section would be the most logical choice to use for the report title or logo?

Report Header

Which section prints at the top of the first page of the report?

desktop database

Which type of template creates a traditional Access database?

To remove a report layout

Why might the controls in the Report Header section be selected?

To connect 2 reports together

Why you might want to use a subreport control?

Linking

___ connects an Access database to data in an external file, such as another Access database, Excel spreadsheet, or SQL Server database, but does not copy the data into the database.

Importing

___ is a process to quickly copy data from an external file into an Access database.

Exporting

___ is a way to copy information to another database, spreadsheet, or file format.

Importing

___ makes a duplicate copy of the data in the Access database.

When you underline cell content, you are using _____.

a font style

An aggregate function is _____.

a function that calculates a statistic such as a subtotal or average

An aggregate function is

a function that calculates a statistic such as subtotal or average

Main

a report that contains a subreport is called the ____ report.

Each item on a form is called a _____.

control

You can import table data from _____.

another Access database

Which action query would you use if you wanted to add records from one table to a backup table?

append query

the wildcard character that stand for nay number of character is the ___.

asterisk (*)

which data type links files created in other programs such as pictures or documents?

b. attachement

tables, queries, and forms are examples of access ____.

b. objects

to back up a database, you use the ______ command

back up database

Which of the following can you change when formatting a table?

background color

image that fills the entire form appearing behind the other controls

background image

Which of the following templates lets you create a database from scratch?

blank desktop database

which data type stores only one of two allies?

c. Yes/No

Before you change the Hidden property for a hidden object in the Navigation Pane, you must

change the Navigation Options to show hidden objects

how can you display the title of a report in green?

change the font color of the label in the report header

how can you list the records in a query data sheet in A-Z order by Customer Name?

click a value in the CustomerName field, and then click the Ascending button

To export query data to Excel, you _____.

click the External Data tab, and then click the Excel button in the Export group

what can you do when a report has balck pages in print preview

click the margins button on the print preview tab to change the report margins.

what should you do when you are finished working in a database?

close the database

To rename a field in Table Datasheet view, you change the text in the _____.

column heading

to rename a field in Table Datasheet view, you change the text in the _____

column heading

To relate two fields in a one-to-many relationship, you connect them using a _____.

common field

to relate two fields in a one-to-many relationship, you connect them using a

common field

When you _____ a database, you reduce the size of the database by up to 75 percent.

compact and repair

when you ______ a database, you reduce the size by up to 75%

compact and repair

To format a range so that all values greater than $500 appear in red, which of the following can you use?

conditional formatting

Microsoft Access 2016 can best be described as ____ software.

database

A _____ is a grid that displays fields as columns and records as rows.

datasheet

in an employee table, what is the appropriate data type for a field that shows the hiring date?

date/time

You use the _____ property of a query to document the purpose or author of the query.

description

the accompanying figure shows the database in ___ view.

design

If a form displays data from the Clients table, you could change the form's record sure property to ____ to display different data

different table

When you delete a record containing an AutoNumber field, Access discards the value in the AutoNumber field and _____.

does not reuse the value

To resize a control in Report Design view, you select the control and then ________

drag a border or selection handle

To move a field in Table Datasheet view, you select the column and then _____.

drag it to a new location

To move a field in the table Datasheet View, you select the column and then

drag it to a new location

in a datasheet, which mode issues that you are trying to change the value of a particular field?

edit mode

when you use the combo box wizard, you can have the combo box list the values from a table or query you can ____;.

enter the values for the combo box

The _____ Building helps you create a calculated field

expression

to import data from excel to access, you would begin by clicking the

external data tab

Access provides a single database template for creating a blank database

false

Access sets the number of decimal places in a Number field, and you cannot change it.

false

Add a Number field to a table to store values that represent money.

false

Before you can rename a field, you must change its data type.

false

Compacting a database has the same result as backing up a database.

false

Database templates create tables and queries, but not forms and reports.

false

One way to format a form is to set the alternate record color of the form in Form Layout view.

false

To navigate to a record in a table, switch to Table Design view.

false

Use Query Design view to display the results of a query.

false

Use the New (blank) record button to move the focus to the first record in a table.

false

When you add a field to a table in Table Design view, entering the field name is optional.

false

You can enter, edit, and navigate data in a query datasheet just like in a report datasheet.

false

before you close a query data sheet, you must save your changes to the data

false

in Form Design view, you can make changes while displaying the data

false

in a datasheet, you can find data, but not replace it

false

press ESC to remove editing changes you made to the previous record

false

sorting a table data sheet temporarily displays only those records that match given criteria

false

to navigate a record in a table, switch to Table Design View

false

use query design view to display the results of a query?

false

when you enter a record in a table, you are working in navigation mode

false

you can use a report to enter a record into the database

false

A category of data such as a customer's name, city, state, or phone number is called a _____.

field

To link the data from one table to another in an Access relational database, a(n) ____ must be common to each table.

field

a category of such data such as a customer's name, city, state, or phone number is called a

field

a specific category of data such as a customers name, city, state, or phone number is called a(n)____.

field

in the accompanying figure, "statesman" and "state abbreviation" appear in the states ___ list.

field

in the accompanying figure, the "statename" and "price" are __ names.

field

to link the data from one table to another in Access relational database, a(n) _______ must be common to each table

field

which two properties are required for every field?

field name and data type

To delete a field from a query in Query Design view, click the _____ for the field, and then press DELETE.

field selector

To move a field in the query design grid, click its_____, and then drag it left or right.

field selector

to move a field in the query design grid, click it's ___, and the drag it left or right.

field selector

A(n) ___ is temporary view of the data that is removed when you close the data sheet

filter

the __ button provides a list of values in the selected field that can be used to customize a filter.

filter

a customer has moved to a new address in the same city. what feature can you use to quickly change the customer's address in a table that contains hundreds of records?

find and replace

The _____ refers to the data you would edit if you started typing

focus

The _____ refers to the data you would edit if you started typing.

focus

Which of the following are features of Access reports? Select all the options that apply.

footers headers calculations on groups of records

The ____ key is the linking field on the "many" side of the relationship.

foreign

To navigate records in Form view, you use the buttons on the _____.

navigation bar

in the _______, Access lists each object in the open database.

navigation pane

Tables, queries, and forms are examples of Access ____.

objects

tables, queries, and forms are examples of Access

objects

which control works best to display three choices 1,2, or 3 for a rating field

option group

When you create a(n) _____ query, the value the user enters in the dialog box determines which records the query displays in the results.

parameter

When you create a(n) _______ query, the value the user enters in the dialog box determines which records the query displays in the results.

parameter

Which Access tool studies the structure and size of a database and recommends how it improve its speed?

performance analyzer

which field is always on the "one" side of the one-to-many relationship?

primary key

Which field is always on the "one" side of a one-to-many relationship between two tables?

primary key field

Characteristics, such as Field Name and Data Type, are_____ that define a field.

properties

When using the Form Wizard, you can select fields from tables and _____ in the database.

queries

You can create an Access report by selecting fields from one or more tables or _____.

queries

you can create and Access report by selecting fields from one or more tables or

queries

A(n) ___ is a saved object within the data sheet.

query

In Query Design view, the _____ shows you the field names, sort orders, and criteria used with a query.

query design grid

In Query Design view, the ______ shows you the field names, sort orders, and criteria used with a query.

query design grid

A _____ is a saved object within the database, whereas a _____ is temporary.

query; filter

the wildcard character that stands for any single character is the ___.

question mark (?)

A cell border extends the width of the cell.

record

A delimited text file such as CSV file stores one ____ on each line

record

A group of related fields, such as all the demographic information for one customer, is called a _____.

record

Each row in a table datasheet displays a _____.

record

a group of related fields, such as all the demographic information for on customer, is called a(an) ___.

record

In a datasheet, what do you click to select a record for deletion?

record selector button

which of the following form controls would you use to display a border around other controls

rectangle

The goal of building one-to-many relationships between tables is to minimize _____ data.

redundant

___ integrity refers to a set of access rules that govern data entry and helps to ensure data accuracy.

referential

use the __ command to save the current object with a new name.

save as

suppose you rename a field in Table Design view. what must you do before you can view the data in the table?

save the table

The first step in the Form Wizard is to _____.

select the fields to include in the form

the __ button filters records that equal, do not equal, or are otherwise compared with the current value.

selection

To create a banded rows effect in a report, you _____

set the alternate row color of a report section

SQL stands for ___/

structured query language

In Table Datasheet view, a(n) _____ shows the records on the "many" side of a one-to-many relationship.

subdatasheet

To create a _____, you add the Total row to the query design grid to specify how to group and perform calculations on the records.

summary query

criteria __ are rules that specify how to enter criteria in a query.

syntax

If the focus in a form moves from left t right and you want the focus to move from top to bottom, change the

tab order

In which object can you rename a field?

table

Which Access object contains all of the data in the database?

table

A relational database can best be described as a collection of related _____ designed to minimize redundant data.

tables

a relational database can be best described as a collection of related _____ designed to minimize redundant data

tables

a relational database can best be described as a collection of related ____ designed to minimize redundant data.

tables

To arrange form controls in a layout of rows and columns like a spreadsheet, select the controls to group together, and then click the ____ button on the Form Layout Tools arrange tab

tabular

If you move the City column in a table datasheet, _____.

the City field also moves in Table Design view

What happens when you click the Build button for a property on the Event tab of a form's Property Sheet?

the Visual Basic window opens

false format

the [ Theme ] painter is a tool you use to copy multiple formatting properties from one control to another.

. In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

the positions offered by each employer

In a Jobs database that contains an Employers table related to a Positions table, what do you expect to find in the subdatasheets of the Employers table?

the positions offered by each employer

What happens when you run a query with the Is Null criterion in the Product Type value?

the results include only records with no Product Type value

What are you saving when you click the Save button to save a table object?

the table design

If you select 25 in the Top Values list, Access displays _____ in the query results.

the top 25 records

What do you change when you drag the right border of a form in Form design view?

the width of the form

False Query

to create a parameter report you base it on a parameter [ table ].

what is the main purpose of a form?

to provide an easy-to-use format for entering and editing records

If you want to sort records in the query results first by City and then by LastName, where should you insert the LastName field in the query design grid?

to the right of the City field

to apply the last filter you selected to a data sheet, you click the _________ button

toggle filter

A new blank desktop database includes one table named Table1.

true

For a Comments field that contains many words, set a Long data type.

true

The Import Spreadsheet Wizard helps you import Excel data into Access.

true

YOU CAN SET THE DECIMAL PLACES PROPERTY FOR FIELDS WITH A CURRENCY DATA TYPE.

true

You can create a mail merge in Word using name and address data stored in Access.

true

You can use the Compact and Repair Database button on the Database Tools tab to reduce the size of the database.

true

You might delete an employee record if the employee no longer works for the company.

true

the Import Spreadsheet Wizard helps you import Excel data into Access

true

the import spreadsheet Wizard helps you import excel data into access?

true

to add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane

true

to add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.

true

to add, delete, or change fields in a query, you use the Query Design view.

true

After you export report data to an HTML document, you can ____ the data in a browser.

view

After you export report data to an HTML document, you can _____ the data in a browser.

view

Summary reports

what are reports that show statistics on groups of records rather than detailed information

The Format Painter

what tool is used to copy formatting properties from one control to another.

they would delete?

what will happen to the controls that are shown in the Page Header section if the TourName Footer section properties specify that a new report page should be at the start of the page.?

When does Access save changes you make to a record?

when you move to a different record

As you create a report, when might you want to work in Report layout view?

when you want to view the data as you change the report

Which data type stores only one of two values?

yes/no

which type of data stores only one of two values?

yes/no

what are you doing when you enter data into a subdatasheet?

you are entering records in the related table

True

you can use a [ subreport ] control to change the order of in which information prints.

what happens if you delete a field from a table that contains data?

you delete all the data in the field


संबंधित स्टडी सेट्स

Chapter 12 Patterns of Inheritance

View Set

AP European History Elizabeth 1 outline

View Set

Ch. 28 - The Child with Cerebral Dysfunction

View Set

chapter 17 anatomy and physiology

View Set

T/F and Multiple Choice (Final MGMT 466)

View Set

Solving Equations (ALL ONE SIDE)

View Set