Blackboard Quizzes CS 302
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
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
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