ISMG Multiple Choice

When editing a main form, pressing ________ will move the cursor to the last character in the field.

$$$Ctrl$$$ + $$$End$$$

When navigating a main form, pressing ________ will move the cursor to the last field of the current record.

$$$End$$$

When navigating a main form, pressing ________ will move the cursor from field to field within a record.

$$$Tab$$$

Which of the following is NOT true about adding pictures to a form?

A different picture can be added for each record.

Which of the following is NOT true regarding database design?

A field is an instance of an entity.

Which of the following is NOT true about applying filters to a datasheet?

A filter is a condition you apply permanently to a table or query.

A ________ query is used when you want to describe one field in terms of two or more fields in the table.

Crosstab

Which of the following is NOT true about customizing a report?

To break a report into smaller sections, grand totals or sorts may be added.

Which of the following is NOT true about form views?

To make any changes to the form you need to switch to either Layout view or Datasheet view.

Which of the following should NOT be done if Access give you a security warning about your database?

Enable the content. Nothing bad will happen, even if there is a virus embedded in the file.

A Label control is a control that contains descriptive information, typically a table name.

False

A junction table breaks down the many-to-many relationship into two one-to-many relationships.

False

A primary key is a value in a table that is the foreign key of another table.

False

A text box control represents the actual value of a field and is an unbound control.

False

Access has a Group & Sort feature that simplifies the addition of groups and totals. It can be used in Report view.

False

Access is often used as a stand-alone DBMS, meaning a DBMS used by multiple users.

False

An advantage to editing data in a table is that the number of records and/or fields in the datasheet can be overwhelming.

False

Any aspect of the report design can be changed in Layout view.

False

At the top of the table, Access provides a Navigation bar that allows you to move through the table.

False

AutoSize is a feature that can change the column width of the data to match the widest data entered in that field.

False

By default, records in a table or query are sorted by the foreign key field.

False

Data is information that has been manipulated and processed to make it meaningful.

False

Design view of a table shows the data contents within a table.

False

Design view shows all the records and fields at one time, which is one advantage to using it to update your records.

False

Design view shows how fields are defined and structured.

False

Form view is only for viewing and changing data, so to make any changes to the form you need to switch to either Print Preview or Design view.

False

If you want to delete a customer from tblCustomer when referential integrity is turned on, and that customer has appointments in tblSchedule, then the appointments for the customer have to be deleted from the tblCustomer first.

False

Input masks do not affect how data is stored.

False

Keystroke mode allows you to move from record to record and field to field using keystrokes.

False

Query results show records and fields created at recordset time, which means that the results are created each time you run the query.

False

Report view allows you to change the page layout such as from landscape to portrait view, or to change margins.

False

Reports have three views: Report view, Layout view, and Design view.

False

The Byte field size is used for integers that range from -32,768 to +32,767.

False

The Detail area shows the fields from the underlying record source. These are the unbound controls showing values.

False

The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.

False

The Long Text data type is used to store textual or character information.

False

The Navigation bar allows you to move to the top and bottom of a table or scroll to a specific record and can be an efficient tool regardless of the size of the table.

False

The Page Header contains the information printed once at the beginning of a report.

False

The Report Footer shows the calculated summary field on the left.

False

The Report Header contains the information printed at the top of every page of a report.

False

The Report tool guides you through creating a report by asking you questions. The report is created based upon your answers to the questions.

False

To find all states that are not PA you could enter "PA" for the state criteria. The is an example of a logical operator.

False

To search for a three-digit number that starts with "67" you would enter 67*.

False

To search for a word beginning with "a" and ending in "e" with any letter between "b" and "t" in between, you would enter b[a-e]t.

False

When a control is selected, the smaller orange handles are move handles.

False

When you delete records from a table and realize you made a mistake, you can undo the deletion by clicking Undo in the Quick Access toolbar.

False

When you open a table in Design view, you can type data directly into the table.

False

You can use Backstage view to modify an existing query.

False

To add a field, you add a field from the ________. This adds both the bound control and a Label control containing the field's caption.

Field List

________ give more information on how the data is stored, entered, and processed.

Field properties

A ________ query is used when you want to find records with the same specific value.

Find Duplicates

________ indicates the maximum length of a data field.

Format

In Design view, the ________ bar is labeled with the primary key of the record that the report was grouped by.

Group Header

The ________ lets you control how information is sorted and grouped in a report.

Group, Sort, and Total pane

Which of the following is NOT true about creating groups in a report?

Groups can only be created with data from individual tables.

Which of the following is NOT true about working with a report in Print Preview?

To make any changes to the report, you can work in Print Preview.

Which of the following is NOT a method used to open or switch views?

To open an object in default view, double-click it in the Navigation bar.

Which of the following is NOT true regarding businesses and databases?

Today's businesses use automated databases to store their records and have completely eliminated paper-based systems.

A calculated control is a control whose data source is a calculated expression that you create.

True

A delimiter is a character such as a tab or comma that separates the fields.

True

A disadvantage to editing data in a form is that some fields may be missing.

True

A filter is a condition you apply temporarily to a table or query.

True

A form with a subform allows you to see one record at a time from the main form and multiple records in Datasheet view from the other related table.

True

A record is all of the data pertaining to one person, place, thing, or event

True

A split form is created from one table and displays each record individually at the top of the window and then again as part of the whole table datasheet in the bottom of the window.

True

A theme is a built-in combination of colors and fonts.

True

A wildcard character is used as a placeholder for an unknown part of a value or to match a certain pattern in a value.

True

When you want to specify criteria in multiple fields, and at least one of the criteria must be true for a record to be included in the results, then the ________ logical operator is used.

OR

Which of the following is NOT true about creating a report using the Report Wizard?

Once a report is created using the wizard, it will open in Design view.

Which of the following is NOT a step in creating a many-to-many relationship?

Only add the keys to the junction table.

The default information contained in the ________ is the column headers, which are taken from the captions from the table design.

Page Header

Which of the following views is NOT available for mailing labels?

PivotTable

________ shows how the report would look on the printed page and allows you to change the page layout.

Print Preview

The Navigation Pane allows for all of the following views EXCEPT ________.

Queries and Related Views

________ is a database concept that ensures that relationships between tables remain consistent.

Referential integrity

The ________ Wizard starts similarly to the Query Wizard in selecting fields for the report.

Report

If you add a logo or date and time, they appear in the ________.

Report Header

________ allows you to filter data or copy parts of the report to the Clipboard.

Report view

________ shows how the report would look in a continuous page layout.

Report view

An example of a report with subtotals and totals could include customer orders by first showing the customer and then grouping all of the customer's orders together.

True

Which of the following is NOT true about saving a report as a PDF file?

The correct terminology for saving a report as a PDF file format is to "repurpose" the report.

Which of the following is NOT true about databases?

The information in databases is summarized and classified to make data available to the decision makers.

Changes to data are saved automatically, but can be undone while the table or form is open by using the Undo button.

True

Conditional formatting formats a control based on one or more comparisons to a set rule set.

True

Datasheet view shows all the fields and records at one time, which provides all the information you need to update your data, unlike in a form or query, where some of the fields or records may not be in view.

True

Datasheet view shows the values of the data within the table.

True

Datasheets are used to view all records in a table at one time.

True

Deleting records in a table is permanent.

True

Each row in an Access table is called a record.

True

Which of the following is NOT true about creating queries in Design view?

The query window in Design view allows you to specify the data you want to see by building a query by wizard.

Which of the following is NOT true about multiple-table forms?

The subform will display "one" record in the one-to-many relationship.

Which of the following is NOT true about tables?

The upper pane of Design view has four columns: Field Name, Data Type, Length, and Description.

If you select Cascade Update Related Fields when you define a relationship, then when the primary key of a record in the one side table changes, Access automatically changes the foreign keys in all related records.

True

If you want to change the fields on existing reports or add grouping, this is not possible once they are created.

True

Importing is the process of copying data from another file, such as a Word file or Excel workbook, into a separate file, such as an Access database.

True

In a split form, there are buttons on the Navigation bar to move only from record to record, and each record shown at the top is the record highlighted in the datasheet at the same time.

True

In the Report Wizard, the one-to-many grouping is the first grouping suggested to you.

True

Layout view is ideal for making changes where seeing the data as you make the change would be useful.

True

Like fields on a form, every field on a report has certain characteristics or properties about the field stored in a property sheet.

True

Normalization is the process of minimizing the duplication of information in a relational database through effective database design.

True

Null is the absence of any value and is different from blank or zero.

True

On a report, you can change the sorting and grouping options from either Layout or Design view.

True

Query results are a recordset that provide an answer to a question posed in a query

True

Query results are a recordset that provide an answer to a question posed in a query.

True

Redundancy is a database concept that ensures that relationships between tables remain consistent.

True

Redundancy occurs when data is repeated several times in a database.

True

Reports are designed for printing. You can use them to provide an easy-to-understand output for a client or manager. You can create mailing labels and other specialized printable formats.

True

Reports are used for providing professional-looking printed output from a database.

True

Reports can be created in four different ways: with the Report tool, with the Report Design tool, with the Blank Report tool, and with the Report Wizard.

True

Reports provide ways to report on data by groups, such as by each customer or product.

True

The Blank Report tool creates a blank report in Layout view. You can insert fields or other controls while you see the data.

True

The Format property tells Access how data is to be displayed.

True

The Group, Sort, and Total pane lets you control how information is sorted and grouped in a report.

True

The Query Wizard uses a question-and-answer dialog box to create a query.

True

The Shutter Bar Open/Close button at the top of the Navigation Pane and opens and closes the pane.

True

The Single field size is used for large numbers with up to seven significant digits.

True

The default title is the name of the report.

True

The field size indicates the maximum length of a data field.

True

The power of a database system comes with the ability to link tables together.

True

The query window in Design view allows you to specify the data you want to see by building a query by example.

True

To use subtotals, you need grouping.

True

When Access runs a query, it puts the results in a default order based on how the table is defined.

True

When a control is selected, the control in outlined in orange.

True

When navigating forms with a subform, the Navigation bar buttons at the bottom of the main window are used to navigate the records in the main form, and a second Navigation bar at the bottom of the subform datasheet is used to navigate the records in the subform.

True

When using the Find Duplicates Query Wizard, you select the fields that you think may include duplicate information, and the wizard creates the query to find records matching your criteria.

True

When you enter data in a form, it is stored in the form and not the table.

True

When you filter by selection, you select a value in a record and Access filters the records that contain only the values that match what you have selected.

True

With multiple criteria, it is good practice to add one criteria, run the query to make sure you are getting the correct results, and then continue adding criteria one at a time.

True

You can add and delete fields in either Layout view or Design view.

True

Which of the following is NOT a step in creating a one-to-many relationship?

Use the foreign key from the one side, and add it as a primary key in the many side table.

Which of the following is NOT true when changing the data type in an existing field?

You can change the size of a field in Datasheet view and Design view.

Which of the following is NOT true about enhancing a report with grouping and sorting?

You can change the sorting and grouping options from either Layout or Report view.

Which of the following is NOT true about sorting query results on multiple fields?

You can have one field sorted in ascending order and another in descending order.

Which of the following is NOT true regarding split forms?

You can highlight a different record in the form part and the datasheet part at the same time.

Access is a(n) ________ DBMS.

relational

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

script

Access has a ________ report that can be used for mailing labels, name tags, or other types of labels.

specialized

A ________ is a form created from one table, but it has a Form view and a Datasheet view in the same window.

split form

Illustrating some of the basic principles of database design, notice that a person's name is split into two fields and the address is ________.

split into two fields

When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the main form and the second table you select becomes the ________.

subform

The Report Wizard ________ functions can be helpful to create simple calculations on a report, but sometimes they do not or cannot complete the calculations the way you want.

summary

A ________ is a structure of a database with tables, fields, forms, queries, and reports.

template

A ________ is a built-in combination of colors and fonts.

theme

There are ________ major kinds of form controls.

three

The ________ row of the query design grid is the Field name.

top

If you need to see a quick snapshot of statistics for a table or query, you can use the ________.

total row

There are ________ options for compacting a database.

two

A(n) ________ can be helpful as an input tool for parameter reports.

unbound form

________ is an example of the General Date format.

11/9/2015 10:10:10 PM

Which of the following is NOT true about reports based on queries?

A macro should be created to run a query and then a report.

When you want to specify multiple criteria, and all criteria must be true for a record to be included in the results, then the ________ logical operator is used.

AND

Which of the following is NOT a reason to use Access?

Access is often used by multiple users at the same time.

Which of the following is NOT true regarding a one-to-many relationship?

Access uses the tilde and infinity symbols to indicate a one-to-many relationship.

Data stored as a(n) ________ file cannot be imported into a table in Access.

Adobe PDF

________ is a feature that can change the column width of the data to match the widest data entered in that field.

AutoFit

Which of the following is NOT true about printing a report?

Before you print, it is always a good idea to view the report in Layout view to make sure it looks the way you want.

Which of the following is true when breaking compound fields into smaller parts?

Break names into first name and last name fields.

If you select ________, Access automatically compacts your database anytime you close it.

Compact on Close

________ rearrange(s) objects to use disk space more efficiently, thus releasing the now unused space to be used again.

Compacting

________ compare the values in a table or another query to the criteria value you set up in a query.

Comparison operators

A ________ is a value that can be changed each time you run the query.

parameter

________ is/are facts about people, events, things, or ideas.

Data

________ define the kind of data that can be entered into a field, such as numbers, text, or dates.

Data types

The ________ shows the fields from the underlying record source.

Detail area

Which of the following is NOT one of the three steps in database design?

Determine the queries you want to create.

Which of the following is NOT true regarding tables and relational databases?

Do not use special characters, such as an underscore, in table names.

Which of the following is NOT true about editing, adding, and deleting records?

If the table is part of a relationship, referential integrity has been enforced, and the cascade delete option has been chosen, a record cannot be deleted if there are related records in another table until those records have also been deleted.

Which of the following is NOT true when copying and pasting data from Excel into Access?

If you have any doubt about the data being compatible, use the Append feature to add the data to the table.

Which of the following is NOT true regarding reports with subtotals and totals?

In Layout view, you can build more complex formulas.

Which of the following is NOT true regarding previewing your reports before you print?

In Print Preview, the labels may not look the way they will look when you print them.

Which of the following is NOT true regarding input masks?

Input masks do not affect how data is stored.

In a query, you can select any records that have no value in a field using the ________ criteria.

Is Null

________ perform arithmetic operations, such as calculating averages and totals, on records displayed in a table or query.

Is Null criteria

Which of the following is NOT a problem that can be caused by using Excel to store data?

Lack of functionality

________ allows you to modify the report while seeing the data.

Layout view

A(n) ________ is the file extension for an Access 2002-2003 database file.

MDB

In a query, if you wanted to display the largest value from the selected records, you would use the ________ aggregate function.

Maximum

When you open a database, Access displays the ________ on the left side.

Navigation Pane

Which of the following is NOT used as a comparison operator?

No answer text provided.

________ is the process of minimizing the duplication of information in a relational database through effective database design.

Normalization

The duplicate values can be hidden using the ________.

property sheet

The ________ Bar Open/Close button at the top of the pane opens and closes the pane.

Shutter

Which of the following is NOT a method used to add fields to a query design grid?

Single-click field name

Which of the following is NOT true about using special operators?

Special operators are used to compare text values using Find & Replace along with the AND operator.

Which of the following is NOT true regarding foreign keys?

The AutoNumber data type is typically used for foreign key fields.

Which of the following is NOT true about conditional formatting?

The Conditional Formatting Rules Manager dialog box can be accessed in Layout or Datasheet view.

Which of the following is NOT true regarding the Find Unmatched query?

The Find Unmatched Query Wizard is designed to find records in a table or query that have no related records in the same table or query.

Which of the following is NOT true regarding a backup database?

The backup copy is as current as your real database, and saves you from having to recreate your database.

Which of the following is NOT true when resizing and managing controls?

When you click a control in Form view, an orange border appears around the control.

Which of the following is NOT true regarding primary keys?

When you define a primary key for a table, the field can be left blank until you have the opportunity to enter the data.

Which of the following is NOT true regarding redundancy?

When you normalize a database, you eliminate redundancy.

Which of the following is NOT true when entering data manually?

When you open a table in Design view, you can type data directly into the table.

Which of the following is NOT true about creating totals on reports?

When you report on textual data, you have the option to ask Access to calculate sums, averages, minimums, and maximums of the data.

Which of the following is NOT true when determining the field size?

Whenever you use a Text data type, you should determine the minimum number of text characters that can exist in the field.

A ________ is used to ask questions about your data.

query

Which of the following is NOT true about creating new databases?

You can use a template; however, you need to create your own forms and reports.

Which of the following is NOT true about navigating forms?

You navigate records in a form the same way you navigate a table, using buttons on the Arrow bar to move from record to record.

Text filters allow you to create a custom filter to match ________ the text in a field that you specify.

all or part of

To search for a word that starts with "ar" you would enter ________.

ar*

A(n) ________ control is a control whose data source is a field in the table such as the customer name.

bound

Two fields needed to uniquely identify a record are called a ________ key.

composite

A DBMS is a ________.

database management system

A ________ is a character such as a tab or comma that separates the fields.

delimiter

When you ________, you select a value in a record and Access filters the records that contain only the values that match what you have selected.

filter by selection

A ________ provides another interface beyond the table in Datasheet view.

form

You are reading a report that shows Company A generated $2,000 last week. This would be ________.

information

A(n) ________ control is a control that contains descriptive information, typically a field name.

label

Access allows you to import a smaller portion of a worksheet, known as a ________, into a table.

named range

A ________ relationship is a relationship between two tables where one record in the first table corresponds to many records in the second table.

one-to-many

A ________ relationship is a relationship between tables where a record in one table has only one matching record in the second table.

one-to-one

A(n) ________ is a foreign key in one table that does not have a matching value in the primary key field of a related table.

orphan