b

Ace your homework & exams now with Quizwiz!

Next, Nina needs to add the fields FirstName, LastName, and EmailAddress to the report. She must select ____ from the DESIGN tab while in the Report Layout Tools section of the Ribbon.

Add Existing Fields

True/False: A table is a predesigned database that includes professionally designed database objects

False

True/False: Access report printing options may be changed using the Navigation dialog box.

False

True/False: All fields in a database should be contained in one table.

False

True/False: Each record in a table is uniquely identified by a foreign key.

False

True/False: Hiding a field in Datasheet view removes the field from the current table.

False

True/False: It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

False

True/False: It is not possible to create a query from more than one table.

False

True/False: Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.

False

True/False: Results of a query are narrowed by using the Or logical operator.

False

True/False: The Tabular and Justified form report layouts display the fields from multiple records at one time.

False

True/False: The contents of query datasheet are permanent.

False

True/False: The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

False

True/False: The only option available for creating tables in Access is to use the datasheet view.

False

True/False: When a form is created based on two or more tables, a relationship must be defined between queries.

False

True/False: When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option.

False

true/False: A question asked about the data stored in a database is called a primary key

False

true/False: The query results are stored in the database in which the query has been created.

False

The query results are stored in the database in which the query has been created?

False are not

A relationship between two tables in a database is formed using a(n) Backstage field?

False its Common

A single characteristic or attribute of a person, place, object, event, or idea is a(n) table?

False its a Field

A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form?

False its a report

Access report printing options may be changed using the Navigation dialog box?

False, Print

An attribute of data that describes a person, place, object, event, or idea.

Field

Each column in an Access table datasheet represents a ____.

Field

Validation Rules are entered in the ____

Field Properties Pane

In the accompanying figure, the ____ is indicated by the red brackets.

Field Properties pane

Another term used for the column selector feature is ____.

Field Selector

The specific content of a field is referred to as the ____.

Field Value

Before applying a conditional format in a report, the ____ box must be selected.

Field value

Document structure tags may be added to a(n) ____ exported from a database to add accessibility features.

PDF file

Large retail stores use _____ terminals to track purchases and inventory

POS

In the accompanying figure, how will the page number for the first page display on the report based on the Format chosen?

Page 1

In the accompanying figure, if the Format is changed to Page N of M, how will the page number be displayed for a 3 page report?

Page 1 of 3

In the accompanying figure, which tab control is active?

Page 34

After printing the report, Janise notices that there is no page number on her report. She would like to add the page number at the bottom of the report. She may add the page number to the bottom of her report in the ____ section of the report.

Page Footer

By default, the Report tool and the Report Wizard include the page number control in the ____ section

Page Footer

The ____ section appears at the bottom of each page of a report and is used for page numbers and brief explanations of symbols or abbreviations, among other elements

Page Footer

Which section contains content that will appear at the top of every page of a report?

Page Header

Options for Janise to choose when adding the page number to the bottom of her report pages may be selected from the ____, available from the Page Numbers button in the Header/Footer group on the DESIGN tab.

Page Numbers dialog box

To set a report's margins to Wide with 1" top and bottom margins and 0.75 left and right margins, click on the Margins button on the ____ tab in Report Design Tools.

Page Setup

When an Access table is exported as an HTML file, the column headings in the HTML document are determined by the ____.

Access table field names

Which Ribbon group allows you to add fields to an Access table with defined data types

Add & Delete

Which Ribbon group allows you to add fields to an Access table with defined data types?

Add & Delete

In the accompanying figure, which of the following is the falsepart of the calculated expression?

Parent & "(Parent)"

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ____ section in Design view.

Report Header Section

Page Header

Placing the report title, date, and page number on the same line in the ____ is a common report standard.

A report formatted where the page is taller than it is wide is formatted in ____.

Portrait orientation

A formatted printout (or screen display) of the contents of one or more tables (or queries) in a database.

Report

This icon represents which Access 2013 object? all green

Report

Using ____ to view a report allows the user to copy selected portions of the report to the Clipboard for use in another program.

Report view

In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

Reports

Which of the following methods should be used in report Layout view to edit a field caption object that is not fully displayed?

Resize the object

Provides the main Access commands organized by task into tabs and groups.

Ribbon

To increase an object's window size to view more of the vertical contents of the object, collapse the ____.

Ribbon

Data in Date/Time fields are automatically ____-aligned.

Right

The ___ property specifies the data source for a control in a form or report or for a field in a table or query.

Row Source

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

Rule type

With the help of ____, less experienced programmers can develop applications for mobile devices such as the iPhone

SDKs

When using the copy/paste method to copy records from one table to another table, the two tables must have the same fields, design, and order, known as the table ____________________.

STRUCTURE

____ is the default entry for each field in the Total row of the query design grid.

SUM

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

Save the table object

The ____________________ box in the Navigation Pane (displayed in the accompaying figure) allows the Access user to search for all database objects that contain a specific value, such as the city, "Albany."

The ____ is located to the right of the navigation buttons and is used to locate a specific record in a form.

Search box

To print two records from a form, select the ____ option in the Print dialog box.

Selected Record(s)

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.

Shift

Which key on the keyboard may be used to ensure that a horizontal or vertical line is straight when adding a line to a form or report?

Shift

In the accompanying image, the selected field has been assigned which Data Type?

Short Text

Which data type allows field values to contain letters, digits, and other characters?

Short Text

What are the 8 data types?

Short Text Long Text Number Date/Time Currency AutoNumber Yes/No Hyperlink

An input mask may be created for any field with the ___ or ___ data type.

Short Text, Number

Which of the following may be used as a wildcard character when searching for a value in Access?

In the accompanying figure, which checked option will include null values in the filtered results?

(Blanks)

A wildcard character used as the first and/or the last character in a character string to match any number of characters is the ____ character.

a wildcard character used as the first and/or the last character in a character string to match any number of characters is the _ charater

Allows field values containing letters, digits, spaces, and special characters. Use for names, addresses, descriptions, and fields containing digits that are not used in calculations.

Short text

Which button is used to open and close the Navigation Pane?

Shutter Bar Open/ Close

The accompanying figure shows the first dialog box for the

Simple Query Wizard

The accompanying figure shows the first dialog box for the ____ Wizard

Simple Query Wizard

It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus at one time.

Single record

Flat, Raised, Sunken, Etched, Shadowed, and Chiseled are options for the ____ control property.

Special Effect

Which form tool displays data in both Form view and Datasheet view at the same time?

Split Form

The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

True

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system ?

True

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table.

True

Compacting a database rearranges the data and objects in a database to decrease its file size

True

Compacting a database rearranges the data and objects in a database to decrease its file size.

True

Digital literacy has become a requirement for most careers

True

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time.

True

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time?

True

Field values that may be entered into a field are determined by the data type of the field.

True

Field values that may be entered into a field are determined by the data type of the field?

True

It is possible to view all Access objects in the Navigation Pane.

True

It is possible to view all Access objects in the Navigation Pane?

True

Magnetic storage is considered permanent storage

True

RAM can be inserted into slots on a motherboard to expand storage on some computers

True

The appearance of non theme fonts colors and effects remains unchanged no matter which theme

True

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook

True

The default primary key for an Access database is the ID field.

True

The default primary key for an Access database is the ID field?

True

The default sort order for records in an Access table is based on the values in the primary key field.

True

The default sort order for records in an Access table is based on the values in the primary key field?

True

The format painter does not copy formatting applied to selected text within a cell and it does not copy data

True

An important reference tool available in Access 2016, which may be used to assist a user with problems that might occur, is the ____________________ system

access help

Which Access feature provides information about Access commands and features and instructions about how to use them?

access help

Functions that perform arithmetic operations on selected records in a database.

aggregate functions

Statistical information such as totals and averages is calculated using ____.

aggregate functions

statistical information such as totals and averages is calculated using _

aggregate functions

The default group in the Navigation Pane is ____.

all access objects

the default group in the navigation pane is

all access objects

Cloud computing is not possible without _____

an Internet connection

The criteria entered in the figure above are an example of which logical operator

and

The criteria entered in the figure above are an example of which logical operator?

and

the criteria entered in the figure above are an example which logical operator?

and

To resize an image without changing its proportions, simply drag ____ of the image.

any corner

Brij has already created the table structure he wants to use in his database. Therefore, when he imports the data from the local non-profit organizations, he will ____ the data to his existing table.

append

The + symbol is an example of a(n) ____ operator.

arithmatic

The + symbol is an example of a(n) ____ operator.

arithmetic

the + symbol is an example of a _ operator

arithmetic

With the help of ____, four academic research institutions were connected to each other for the first time through ARPA's computer network.

arpanet

Precise control for moving selected objects on a form is accomplished by using the ____________________ keys on the keyboard.

arrow

The data type that allows both sequential and random numbering is the ____ data type.

autonumber

Which data type allows the designer to define the Field Size property?

autonumber

The Access 2013 view that allows the user to manage files and options.

backstage view

Which Access 2013 view contains commands used to manage Access files and options?

backstage view

The type of operator that compares the value in a field to the condition value and selects all records for which the condition is true.

comparison operator

Many programming languages require a ____ to create executable files

compiler

A primary key that consists of two or more fields in a table

composite key

A primary key that consists of two or more fields in a table.

composite key

The term _____ best describes the level of technology skills needed in today's business world

computer fluency

A(n) ____ is a set of instructions or statements to the computer

computer program

A value set in the Field Properties pane that appears in a field automatically is the default value for the field

default value

In the accompanying figure, the data enclosed in the green rectangle are data imported from a CSV file that have been ____ by commas.

delimited

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

delimited

Which of the following agencies played an important role in the birth of the Internet?

department of defense

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

description

The Access database view that allows users to define or modify a table structure or field properties in a table.

design

The accompanying figure illustrates the ____ view which allows the user to modify a table structure.

design

____________________ view allows the database designer to enter both the field names and define the field properties.

design

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

detail record

a _ is a set of field values for a record that is found in a table related to the primary table on which a report is based

detail record

A printer requires a ____ installed on the computer in order to operate.

device driver

Monitor display size is measured _____.

diagonally

Using analog-to-_____ conversion, we are able to digitize the things we see and hea

digital

Personal music videos that combine user-generated photos with audio music are a good example of

digital convergence

In the accompanying figure, the plus sign beside the record indicated by arrow number 2 indicates that this record ____.

does have a related record in another table

In the URL http://www.erau.edu, erau.edu is the ____.

domain name

It is much easier for people to remember ____ than IP addresses of websites.

domain names

The less precise way to move objects in report Layout view is to ____.

drag objects

the less precise way to move objects in report layout view is to_

drag objects

A webpage can be created using web development software such as ____.

dreamweaver

It is more efficient to use the Query Wizard for common, informational queries than to design your own query. ___________

false

It is not possible to create a query from more than one table.

false

It is not possible to create a query from more than one table. __________

false

Query elements may be added to a form to improve its appearance or add visual appeal.___________

false

Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated. ____________

false

Results of a query are narrowed by using the Or logical operator.

false

Results of a query are narrowed by using the Or logical operator. ___________

false

The Form Wizard limits fields to be used in a form to one table or one query. ___________________

false

The Tabular and Justified form report layouts display the fields from multiple records at one time. ___________

false

The appearance of text on a form or report is changed using the Design group on the FORMAT tab on the Ribbon. _______________

false

The contents of query datasheet are permanent. _______

false

The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field. ________________

false

The default query type for Access is the Crosstab query.

false

The default query type for Access is the Crosstab query. _______________

false

The most detailed view of a form's structure is available the Layout view. ____________

false

The only option available for creating tables in Access is to use the datasheet view. _______________

false

The query results are stored in the database in which the query has been created.______________

false

When a form is created based on two or more tables, a relationship must be defined between queries. ____________

false

When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option. __________

false

a query is used to enter, edit, and view records in a database

false

a question asked about the data stored in a database is called a primary key

false

a table is a predesigned database that includes professionally designed database objects

false

each record in a table is uniquely identified by a foreign key

false

the only option available for creating tables in access is to use the datasheet view

false

Each column in an Access table datasheet represents a ___

field

Each column in an Access table datasheet represents a ____.

field

Access offers the option to use the first row of a linked Excel spreadsheet containing column headings as ____ for the table in the database.

field names

Each Excel worksheet that was exported contained column names. Those names will appear in the first row of the Import Text Wizard and may be used as the ____ in the Access table.

field names

In a single table, all ____________________ must be unique within that table

field names

A database system determines how to store, display, and process field values based on which of the following?

field properties

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________

field properties

Another term used for the column selector feature is ____.

field selector

Before applying a conditional format in a report, the ____ box must be selected.

field value

The specific content of a field is referred to as the ____.

field value

before applying a conditional format in a report, the _ box must be selected

field value

The specific content of a field.

field view

Which of the following is an advantage of using a query as a record source for a report?

fields can easily be added to a query as report requirements change, including calculated fields

In a relational DBMS, a user may create a database structure that contains which of the following?

fields, tables, and table relationships

The Access Ribbon tab that offers the option for the user to compact and repair a database.

file tab

A field's data type and the selected value determine the ____ options that appear on the shortcut menu in Report view.

filter

In the accompanying figure, the ___ for the current field is/are indicated in the box designated by the arrow.

filter choices

To locate a specific field value or part of a field value, a user may search a table datasheet, a query datasheet, or a form using the ____________________.

find command

Which type of query would show results indictating two different student ID numbers have been assigned to the same student?

find duplicates query

The accompanying figure is an example of criteria for a ___ query using the Query Wizard.

find unmatched

The Registrar at Revenswood College would like to create a query which displays al students who haven ot yet registered for fall semester classes. She will use the StudentInformation and TuitionPaid tables to create the query. Which type of query will most likely create the desired results?

find unmatched query

ROM is used for important programs like _____, which come(s) from the manufacturer

firmware

With _____ memory, data is stored permanently with no moving parts or the need for electricity

flash

Rich text formatting available for Long Text fields includes ___

font options

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables; the field in the second table is called a(n) ____________________.

foreign key

A form must be displayed in ____________________ view to navigate, view, and edit data.

form

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

form

Data in a form may only be modified in ____ view.

form

This icon mc011-1.jpg represents which Access 2013 object?

form

data in a form may only be modified in _ view

form

in the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in _ view

form

Alignment of text in a field value may be changed using the ____________________ tab in the REPORT LAYOUT TOOLS contextual tabs when designing a report

format

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

format

options for modifying the format of report objects are found on the _ tab in layout view when the contextual report layout tools tab is available

format

Which Access database object(s) might be used to enter, edit, and view records in a database?

forms

The specifications of a computer usually include the speed of the _____ bus

front side

_ is the default entry for each field in the total row of the query design grid

group by

____ is the default entry for each field in the Total row of the query design grid.

group by

Output that you can feel is called _____ output

haptic

After reviewing the form Sergio decides he wants to create a form that will allow Carmen to enter both the participant information and the amount due by the participant. Sergio will need to use two tables to accomplish this. The second table will be the ___ in the form

subform

In the accompanying figure, the fields indicated by the green brackets are fields to be included in the ____.

subform

The most powerful type of computer is a _____

supercomputer

Each programming language has a particular ____— rules that guide how programming statements are constructed.

syntax

In the accompanying figure, arrow number 3 points to the ____.

tab for the second tab of the tab control

The ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key.

tab order

It is a good idea to ___ the database before using compact and repair to keep the database safe from hardware and software malfunctions.

make a backup copy of

A database management system is a useful tool only if it meets which of the following criteria?

meets the needs of its users

All of the following are common kinds of multicore processors EXCEPT _____.

mega-core

The task of video _____ is to serve as a buffer between the processor and the monitor.

memory

Video cards have their own _____.

memory

Which aggregate function would be used to calculate the lowest field value for the selected records?

minimum

which aggregate function would be used to calculate the lowest field value for the selected records?

minimum

A video card can be found inside the computer, plugged into the _____.

motherboard

A query based on more than one table is a(n) ____query.

multiable

a query based on more than one table is a(n) _ query

multitable

query based on more than one table is a(n) ____query.

multitable

The first, last, next, or previous page in a report may be displayed using the ____________________ buttons.

navigation

Typing a value in a highlighted field while in the ____________________ mode replaces the highlighted field value.

navigation

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________

navigation buttons

There are two ways to move vertically from one record to another in a table; use the vertical scroll bar or the ____________________.

navigation buttons

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

new formatting rule

after a condition formatting rule is created using the _ dialog box, the rule is then available for use in the database from the conditional formatting rules manager dialog box

new formatting rule

The "one" table in a one-to-many relationship is the ____________________ table.

primary

The primary key of a table must be unique for each record; however, the ____ sort field does not have to be unique.

primary

the primary key of a table must be unique for each record; however, the _ sort field does not have to be unique

primary

A field, or collection of fields, whose values are used to uniquely identify each record in a table.

primary key

The default ____________________ provided by Access is the ID field.

primary key

The first field specified in the sorting process is called the ____________________ field.

primary sort

print all, pages and selected record(s) are options available from the _ for printing forms

print dialog box

A report layout may be changed using options on the ____________________ tab.

print preview

The Access 2013 view that shows the number of pages that will be printed.

print preview

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

print preview

viewing and printing options for forms and records are available on the _ tab

print preview

Using Moore's Law, we can gauge how fast ____________ might be in the coming years

processors

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

programming tasks

A calculated field is formatted using the ____ for the field.

property sheet

a calculated field is formatted using the _ for the field

property sheet

The process that occurs when the field Description (Optional) property is changed in Design View and the Property Update Options tool is used to update the entire database everywhere the field is used, including forms and reports.

propogate

In the URL http://www.erau.edu, (Links to an external site.) http: is the ____.

protocol

The standard naming convention prefix tag for a query used to identify the object type is

qry

A question that is asked about the data stored in a database.

query

This icon mc013-1.jpg represents which Access 2013 object?

query

This type of datasheet displays temporary contents based on the criteria established in the design grid.

query

To generate a report with exact results based on specific criteria it is best to base the report on a(n) ____________________ created in the database.

query

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

query

the query type that gives access an example of the information being requested and retrieves information based precisely on matching the example is which type of query?

query by example (QBE)

Data may be sorted in a table datasheet, a form, and a ____.

query datasheet

data may be sorted in a table data sheet, a form, and a

query datasheet

the expression builder dialog box is available from which group on the query design tab on the ribbon?

query setup

The _________________ prompts for information by asking a series of questions and creates the appropriate results based on the answers to the prompts.

query wizard

The default name for a new Access query is ____________________.

query1

A group of fields added all at once using the Data Type gallery.

quick start selection

A ____________________ is a set of records that answers the question resulting from a query.

recordset

A set of rules that Access uses to maintain consistency between related tables when data is updated in a database

referential integrity

A set of rules that Access uses to maintain consistency between related tables when data is updated in a database.

referential integrity

One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

referential integrity

Data organized as a collection of tables creates this type of data system

relational database management system

Data organized as a collection of tables creates this type of data system.

relational database management system

To use an existing query as the basis for a new query, it is necessary to ____ the query before designing the new query.

rename

What function does compacting an Access database perform other than reducing the file size?

repairing the database

This icon mc012-1.jpg represents which Access 2013 object?

report

In the accompanying figure, which Access database object is represented by the icons and titles shown in bracket number 4?

reports

which of the following methods should be used in report layout view to edit a field caption object that is not fully displayed?

resize the object

Data in Date/Time fields are automatically ____-aligned.

right

data in the date/time fields are automatically __-aligned

right

In the accompanying figure, the page number control is set to display the page number in which manner?

right aligned

When using a mouse while in an Access 2013 work session, access a shortcut menu for an object by performing this task.

right click

One ____ available for specifying conditional formatting in a report is "Check values in the current record or use an expression."

rule type

one _ available for specifying conditional formatting in a report is "check values in the current record or use an expression:

rule type

Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon.

run

results of a query may be viewed at any time by clicking the __ button in the results group on the ribbon

run

The local non-profit offices update their donor information every quarter. Brij will find it necessary to update the database by using the same import specifications four times a year. Which process would expedite this task for Brij?

save the import steps in the Access database so they could quickly be run again

To save the HighestTemp query, Mrs. Godwin's students had to perform which of the following tasks?

save the query object with a new name

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to complete which process?

save the table object

the _ is located to the right of the navigation buttons and is used to locate a specific record in a form

search box

To select and set properties for an entire section, click on the ___

section selector

Common properties for multiple controls may be set by performing which of the following tasks?

select adjacent and nonadjacent controls using the Ctrl key and the mouse; then change the properties for all controls at once

Records printed in Form view are distinguished from one another in Print Preview by ____________________.

shading

To select both a field label and field value to move in a report design, after selecting the field label press the ____ key to select the field value box.

shift

to select both a field label and field value to move in a report design, after selecting the field label press the _ key to select the field value box

shift

Which data type allows field values to contain letters, digits, and other characters?

short text

In the accompanying figure, which button on the ribbon should be used to add a table to the Relationship window?

show table

An Access 2013 tool that allows the user to quickly add fields and records to display in query results.

simple query wizard

The ____________________ Field Size property of a Number field stores positive and negative numbers to precisely seven decimal places in four bytes.

single

is it often easier to maintain data in a data sheet using a form because all changes for a _ are the focus at one time

single record

A(n) ____ license can be used anywhere on a college campus

site

The field used to determine the order of records in a datasheet.

sort field

Using the datasheet in Figure 3-1-1, which is the quickest method to help students determine the highest wind speed from the recorded data?

sort the Wind mph field in Datasheet view using the largest to smallest AutoFilter option

To avoid the look of missing data in a report, use the Hide Duplicates property on ____ fields.

sorted

Programmers create ____ and compilers turn it/them into ____.

source code, object code

It is important to open the ____ file before opening a linked Access table.

source file

A(n) ____ is a program containing original information or an original object that can be integrated into Access.

source program

A Kindle eBook reader is an example of a(n) _____ computer

special-purpose

Changing the order of fields in a database table is an example of changing a table's ____.

structure

By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but not the ____.

structure, data

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

tab, enter

All data in a database is contained in which database object?

table

Which Access object(s) may be used when creating a lookup field to select values?

table

Which of the following is an Access 2013 database object?

table

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

table 1

Access reports are based on a selected ____________________ or ____________________.

table, query

All of the data in a relational database are contained in ____________________.

tables

Text box controls arranged in a datasheet format with a label above each column indicates the ____ layout

tabular

In the accompanying figure, object dependencies are shown for the ___ object.

tblPatient

In the accompanying figure, the frmPatient object is dependent on the ___ object

tblPatient

____ defines how information travels across the Internet.

tcp/ip

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

temporary

The condition "Seattle" for the field City in a student database is an example of what type of value?

text value

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

the Access field names and the Excel worksheet column headings do not match

The label attached to a bound control displays which of the following?

the field name or Caption property

In the accompanying figure, arrow number one indicates ____ for the data being imported into Access.

the field names

the appearance of fields in a report that is created using the report wizard is determined by _

the order the fields are selected in the report wizard

Nina does not see any fields available to add to the report after making the correct selection from the DESIGN tab on the Report Layout Tools Ribbon. What is most likely the problem?

the tables are not visible in the Field List pane of the report design window and must be made visible

A predefined set of formats including colors, fonts, and other effects that enhance an object's appearance and usability.

theme

In addition to standard colors, the font color gallery displays ____ colors.

theme

What is the purpose of the primary key?

to uniquely identify each RECORD in a table

What is the purpose of the primary key?

to uniquely identify each record in a table

to add a row labeled "total" to a query design click the _ button in the show/hide group on the design tab on the ribbon

totals

The _____ is the key active component in practically all modern electronics

transistor

An integrated circuit may hold thousands, millions, or even billions of _____.

transistors

A database or a relational database is a collection of related tables. _______________________

true

A form created from more than one table uses the primary table for the main form. ___________________

true

A form's object name appears on the tab for the form in the Access window. ____________________

true

A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut. ________________

true

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). __________________

true

Access allows all pages, a range of pages, or a currently selected record to be printed from Form view. ______________

true

Access database objects are divided into categories on the Navigation Pane. ________________

true

Access does not require a field description for every field included in a table.

true

Access does not require a field description for every field included in a table. ________________

true

Access does not require a table to have a(n) primary key. ______________________

true

Access may base queries on one or more tables or queries. ________

true

Caution should be used when deleting an entire record in Form view because the record will also be deleted in the form's underlying table. __________________

true

Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

true

Changes made to a field in a query datasheet updates the same field in the table on which the query is based. _____________

true

Compacting a database rearranges the data and objects in a database to decrease its file size. _____________

true

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

true

Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database. _________________

true

Design changes cannot be made to a form in Form view. ____

true

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _____________

true

Field values edited in Form view are also changed in the form's underlying table. ________________

true

Field values that may be entered into a field are determined by the data type of the field. ____________________

true

Fields included in a query may be modified after the query is saved.

true

Fields included in a query may be modified after the query is saved. ___________

true

In order to define table relationships, each table being joined must contain a common field.

true

In order to define table relationships, each table being joined must contain a common field. __________________

true

It is possible to view all Access objects in the Navigation Pane. _________________

true

Layout view shows both the form and its data while allowing the form to be modified. ________________

true

Logical operators must be used in order to combine two or more conditions in a query.

true

Logical operators must be used in order to combine two or more conditions in a query. _____________

true

Report fields and field value boxes may be repositioned while viewing the report in Layout view. _________________

true

The Columnar form layout displays the fields from one record at a time. _______________

true

The Currency data type is accurate up to 4 digits on the right side of the decimal point. ____________________

true

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view. _____________________

true

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane.

true

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _____________________

true

The Report Wizard allows detail records to be sorted by up to four fields. ________________The Report Wizard allows detail records to be sorted by up to four fields. ________________

true

The default primary key for an Access database is the ID field. _______________

true

The default sort order for records in an Access table is based on the values in the primary key field. ___________

true

The process of rearranging records in a specified order or sequence is referred to as sorting. ______________

true

To toggle between navigation mode and editing mode press the F2 keyboard shortcut.

true

To toggle between navigation mode and editing mode press the F2 keyboard shortcut. _________________

true

When a question is asked of a database using a select query, the answer is returned as a data sheet. ______________

true

When a question is asked of a database using a select query, the answer is returned as a datasheet.

true

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data. ______________

true

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

true

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message. ___________________

true

a database or a relational database is a collection of related tables

true

a software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)

true

compacting a database rearranges the data and objects in a database to decrease its file size

true

the number of the currently selected record in a table and the total number of records in the table are displayed in the current record box which appears between the two sets of navigation buttons on a datasheet

true

when creating a form in access, the layout view allows the user to make design changes to the form while it is displaying data

true

The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

ture

The ___________________ command allows hidden fields to be redisplayed.

unhide fields

When the sort field data for each record in a database is different, the sort field is ____.

unique

when the sort field data for each record in a database is different, the sort field is _

unique

As Carlos plans for the fall planting season, he would like to bundle all of his shipments from the Organic Opportunities supplier into one shipment. He needs to know which products he has previously ordered from Organic Opportunities. Which method will quickly produce the results Carlos need?

use the AutoFilter option in the Supplier table for the appropriate field

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

values

Formatting Date/Time fields changes only the way data is displayed, not the field __________

values

An advantage of ____ software is its ability to run more than one operating system on a computer

virtual machine (VM)

In the accompanying figure, which field is the secondary sort field?

visitdate

In the accompanying figure, the primary key for the Vist table is the ____ field.

visitid

A calculated field created in a query generates results when ____.

when the query is run

a calculated field created in a query generates results when _

when the query is run

A text box that is too narrow to display the full field value will display the pound sign (#), which means the ____ of the text box must be adjusted.

width

A ____ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern.

wildcard character

a _ is a placeholder used in a search when the search should start or end with a specific character or match a particular pattern

wildcard character

In the accompanying figure, arrow number 4 indicates which chart element?

x-axis

In the accompanying figure, arrow number 2 indicates which element of the chart?

y-axis

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition

yes/no

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

yes/no

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

yes/no

A dialog box used to enter text, expressions, or other values.

zoom box

Random access memory (RAM) is also sometimes called _____ storage.

primary

Files created with Access 2013 may be used with which previous version of Access?

Access 2010

A CPU component known as the _____ carries out the instructions used for mathematical and logical operations.

ALU

Which of the following is the file extension associated with an Access template?

*.accdt

Values in a CSV file are separated by which symbol?

, (comma)

Which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order?

which of the following characters represents the wildcard character that matches any one of a range of characters in ascending order

In crosstab query results, the value of a checked Yes/No data type field will display as ____

-1

Which of the following is the file extension used for Access 2013 database files?

.accdb

Which of the following is the file extension used for Access 2016 database files?

.accdb

What two values represent the binary number system?

0 and 1

In the accompany figure, editing mode is indicated by which numbered arrow?

In the accompany figure, editing mode is indicated by which numbered arrow? (PIC7)

In the accompanying figure, which arrow points to the Tab Control tool?

In the accompanying figure, which numbered arrow indicates the report results are filtered?

in the accompanying figure, editing mode is indicated by which numbered arrow?

A(n) ____ allows others besides the manufacturer to develop software to run on the system or device.

API

Which Access feature provides information about Access commands, features, and instructions

Access Help

An important reference tool available in Access 2013, which may be used to assist a user with problems that might occur, is the ____________________ system.

Access Help

Which Access feature provides information about Access commands and features and instructions about how to use them?

Access Help

Nina has completed the report Carlos requested, but she notices that the columns of the report are not spaced equally. Nina can fix this problem quickly by selecting the entire report in Design view and choosing the Equal Horizontal option from the Size/Space button on the ____ tab.

ARRANGE

Files created with Access 2013 may be used with which previous version of Access

Access 2010

What is the maximum number of sort fields that can be included in a report?

In the accompanying figure, which arrow indicates the move handle of a control?

In the accompanying figure, which number corresponds to the datasheet selector which selects all records in a table?

In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?

In the accompanying figure, which numbered arrow indicates the Report view button

In the accompanying figure, which numbered arrow indicates the property that must be changed for the selected control to display "Guest Last Name?"

In the accompanying figure, which numbered arrow indicates the right margin guide

Files created with Access 2013 may be used with which previous version of Access?

2010

Moore's Law states that the number of transistors on a chip will double about every _____ months

In the accompanying figure, what is the Top Values property that has been set for the qryLargeInvoiceAmounts?

25%

A field Description property can be up to _____ characters long.

255

The default Field Size for the Short Text data type is ____________________ characters.

255

The default character length for the Short Text data type is ____ characters.

255

In the accompanying figure, which arrow indicates the Detail section bar?

In the accompanying figure, which number indicates the Selection type entry?

In the accompanying figure, which numbered arrow indicates a number formatted in the Standard format?

In the accompanying figure, which numbered arrow indicates the button that moves the Form Wizard to the second dialog box where a form layout may be chosen.

In the accompanying figure, which numbered arrow indicates the chart legend?

In the accompanying figure, which record number is the current record?

In the accompanying figure, which record number is the current record? (PIC8)

in the accompanying figure, which record number is the current record?

In the accompanying figure, which numbered arrow indicates the Layout view button?

In the accompanying figure the field size is set to

In the accompanying figure, which arrow indicates a bound control?

How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?

What is the maximum character length of a field name?

A selected control will display how many sizing handles?

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number

999/-000/-0000

All records in an Access table exported as XML begin and end with which XML tag?

Which symbol is used to distinguish an expression from a fieldname in a calculated control?

Akash has included a calculated field in the subform which was created using a query for unpaid invoices. The calculated field should show the total amount of unpaid invoices from the InvoiceAmt field; however, the form does not show the calculation in Form view. Which expression will solve this problem?

=Sum([InvoiceAmt])

Which of the following criteria will show Ja'nice all orders placed on or after July 1, 2015?

>=#7/1/2015#

In an input mask, the letter __ indicates that a letter or digit must be entered, and the entry is required.

Each row in an Access table datasheet displays which of the following?

A record

To resize an image without changing its proportions, simply drag ____ of the image.

Any corner

Which import option should be chosen in the Import XML dialog box when the data being imported are to be added to an existing table?

Append Data to Existing Table(s)

Setting the ___ field property to Yes instructs Access to keep an historical record of all versions of the Long Text field value

Append Only

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen, and changes made to the source data will not be reflected in the database.

Append a copy of the records to the table

To use an application part in an existing database, choose ____ from the CREATE tab on the ribbon to view the application parts gallery.

Application Parts

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

Application Parts gallery

The ____ option in the Tab Order dialog box allows a tab order of left-to-right or top-to-bottom.

Auto Order

What are the 5 aggregate functions?

Average, Count, Max, Min, Sum

The purpose of the ____ is to store the boot process instructions for the computer to start up.

BIOS

Which button on the FORMAT tab is used to change the background color of a control, section, or object?

Background Color

Which Access 2013 view contains commands used to manage Access files and options?

Backstage View

Which Access 2013 view contains commands used to manage Access files and options?

Backstage view

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

Best Fit

Carlos has asked Nina to create a report that will list all of his customers by last name with their email addresses. To begin creating the custom report after opening the database, Nina will choose the ____ from the CREATE tab on the Ribbon.

Blank Report

Which of the following is an example of optical storage?

The number of occurrences of an expression is determined using the ___ function in a form or report

COUNT

Janise notices, after viewing the report in Report view, that the Special Requests field does not show all of the data she needs to view. Which property should she change for the text box containing the Special Requests field information?

Can Grow

The text box property that allows the box to expand vertically to fit the field value is the ____ property

Can Grow

The new custom form meets Carlos' requirements; however, some of the labels do not clearly describe the data that needs to be entered in the form. Which label property should Carlos change to make the label more descriptive and clear to the user?

Caption property

____ can be applied to more than one webpage, producing a website with a consistent design and appearance.

Cascading Style Sheets

____ is one of the options available from the Page Layout group on the PRINT PREVIEW tab when previewing how a report will print.

Changing page orientation

The ____ tool is used from the Controls group on the DESIGN tab to create a chart based on field data from an Access table or query.

Chart

True/False: A sort field is unique if more than one record can have the same value for the sort field.

False

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. Sergio wants the form layout to display the fields for only one record at a time. Which form layout should Sergio select? (PIC46)

Columnar

After reviewing the simple form, Carlos decides that he needs a form which is customized to make data entry more accurate and less cumbersome. Because most of his products are already in the database, he would like to use a list to choose the product during data entry. However, there are times that a product might not be available in the database, and it needs to be added. What is the best type of control for Carlos to use in his custom form to meet this requirement?

Combo box

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Common Field

Asks Access to compare the value in a field to the condition value and to select all the records for which the condition is true.

Comparison Operator

A criterion, or rule, that determines which records are selected.

Condition

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting.

Conditional

The REPORT LAYOUT TOOLS tabs are ____ tabs available only when working with report objects.

Contextual

In the accompanying figure, the Table Tools tab is an example of this type of tab that appears and provides options for working with a specific object when the object is selected

Contextual Tab

An item on a form or report object that can be manipulated to modify an object's appearance is a(n) ____.

Control

Spacing around the text inside a control is determined using the ___ property

Control Margins

Only a field name or an expression may be used for the ___ property in a calculated control

Control Source

A ____ asks a series of questions and then uses your answers to create a control in a form or report.

Control Wizard

Text that appears in a ScreenTip when the mouse pointer is positioned above a control in a form is determined by the ____ property.

ControlTip Text

The Line tool is accessed using the More button in the ____ group on the DESIGN tab

Controls

To add the control to the form that meets his requirements, Carlos will use the ____ from the DESIGN tab in the Forms Layout Group on the Ribbon.

Controls gallery

The aggregate function which returns the number of nonnull field values is the ___ function.

Count

To design a form using the Form Wizard, begin by clicking on the ____ tab on the Access Ribbon.

Create

Provides options for creating various database objects, including tables, forms, and reports. The options appear on the tab grouped by object type.

Create Tab

A ____ query uses functions, such as Sum and Count, to perform arithmetic operations on selected records.

Crosstab

Which query wizard allows the user to choose the field that will be calculated for each row and column intersection?

Crosstab Query Wizard

Which of the following illustrates a calculated field with the name of the calculated field in the proper format?

DonationsGreaterThan2500: [Donation] >= 2500

Carlos has decided to market his cooking demonstration based on his most abundant products. To do that he needs to know the quantity of each product by category (such as beef, green vegetables, peppers, etc.) Because each product in the Products table is assigned a category in the Category field, he will create a query that lists the categories in rows in the datasheet and the product totals as columns in the datasheet when the query is run. Which type of query will Carlos create?

Crosstab query

Which keyboard shortcut selects the first field value in the first record when in Navigation Mode?

Ctrl+Home

which keyboard shortcut selects the first field value in the first record when in navigation mode?

Ctrl+Home

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

Custom

Ja'nice would also like to create a query that shows her specific products (by Product ID) that were purchased by individual customers. To do this, she must use at last two tables to create the query. Which two tables would be best to use for this query?

Customer Info and Order Info

The Tab Order button, which quickly displays the Tab Order dialog box, is located on the ____ tab in Form Design view.

DESIGN

A collection of related tables

Database

Displays the table's contents in rows and columns, similar to a table that you create in a word document or an excel spreadsheet.

Datasheet

Which Access 2013 view shows the contents of a table as a datasheet?

Datasheet View

Carlos is creating a simple form using the Products table and would like to include all fields from the table. He would like for the form to display all of the fields using a datasheet layout. Which tool would be best for Carlos to use?

Datasheet tool

Which Access 2013 view shows the contents of a table as a datasheet?

Datasheet view

In the expression =Date(), used to return the current date, which portion of the expression is the name of the function?

Date

Which data type would be the best logical data type for a field named PaidDate?

Date/Time

You can use the _________ to enter an optional description for a field to explain is purpose or usage.

Description Property

Allows you to define or modify a table structure or the properties of the fields in a table

Design View

The accompanying figure illustrates the design view which allows the user to modify a table structure

Design View

Which view or tool allows the form designer the most control and precision when designing a form?

Design View

Nina successfully added the required fields to the report. Now she wants to sort the report alphabetically by the customer's last name. To Add a Sort Field, Nina must first be in ____ view.

Design or Layout

A ____ is a set of field values for a record that is found in a table related to the primary table on which a report is based.

Detail Record

Which option in the Import Text Wizard allows the user to choose fields that will be imported from a CSV file?

Do not import field (Skip)

The Access tool that allows the user (or designer) to create detailed documentation of all, or selected, objects in a database is the ___.

Documenter

The less precise way to move objects in report Layout view is to ____.

Drag objects

Once Zach has created the appropriate files from the Excel workbooks, Cayla will import the data into the Access database. Which tab will Cayla use from the Access Ribbon to begin the import process?

EXTERNAL DATA

In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

To generate the most readable format for a table exported to HTML, always select the ____ option from the available export options.

Export data with formatting and layout

To avoid typing errors when creating a more advanced expression for a calculated control, it is a good idea to use this Access feature.

Expression Builder

Font Weight

Extra Light and Semi-Bold are examples of which feature available in the Label Wizard?

When defining the fields in a table, you can move from the Table Design grid to the Field Properties pane by pressing the ________.

F6 Key

The Select All button, which selects all controls in a report or group, is located on the ____ tab of the Report Design Tools

FORMAT

A formatted printout (or screen display) of the contents of one or more tables or queries is a(n) form.

False

A query is used to enter, edit, and view records in a database

False

A question asked about the data stored in a database is called a primary key

False

A question asked about the data stored in a database is called a primary key.

False

A relationship between two tables in a database is formed using an backstage field?

False

A single characteristic or attribute of a person, place, object, event, or idea is a(n) table.

False

A table is a predesigned database that includes professionally designed database objects?

False

Access report printing options may be changed using the Navigation dialog box.

False

Each record in a table is uniquely identified by a foreign key

False

Each record in a table is uniquely identified by a foreign key.

False

Each record in a table is uniquely identified by a foreign key?

False

JavaScript is an example of a server-side programming language.

False

Podcasts and video podcasts are distributed using CSS technology

False

The only option available for creating tables in Access is to use the datasheet view?

False

The query results are stored in the database in which the query has been created.

False

True/ False: Access does not allow data to be imported from sources other than another Access database.

False

True/False: A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

False

True/False: A query is used to enter, edit, and view records in a database.

False

True/False: A single characteristic or attribute of a person, place, object, event, or idea is a(n) table.

False

Data in a form may only be modified in ____ view.

Form

In the accompanying figure, arrow number 1 identifies the button which indicates the form is displayed in ____ view. (PIC1)

Form

This icon represents which Access 2013 object? red bar at the top with two boxes on the right

Form

Titles, instructions, command buttons, and other controls added to the bottom of a form and that remain on the screen when the form is displayed in FOrm view or Layoutview are added to the ___ section of the form

Form Footer

Janise is planning her first custom form carefully. She knows that she wants a title for her form and several fields included in the form controls. Which feature will Janise use to add the appropriate section for a title to her form?

Form Header/Footer

Options for modifying the format of report objects are found on the ____ tab in Layout view when the contextual REPORT LAYOUT TOOLS tab is available.

Format

In the accompanying figure, the ____ Access database object is indicated by the icons shown in bracket number 3.

Forms

Which Access database object(s) might be used to enter, edit, and view records in a database?

Forms

Which of the following is an example of a cellular network platform

GSM

____ is the default entry for each field in the Total row of the query design grid

Group By

Options for modifying a report's grouping fields, sorting fields, and report calculations for the groups are available using the ____.

Group, Sort, and Total Wizard

The Page Numbers button, used to add a page number expression to a report, is found in the ____ group on the DESIGN tab

Header/Footer

Akash used the Header section in his main form design, but he does not plan to use the Footer section. To remove the footer section, which section property should be set to zero?

Height

Some of Janise's clients have more than one pet. The current version of the report shows the client's information for each pet the client has listed with Janise's pet sitting service. Janise would like for the client information to appear only once on the report but still see each pet and the pet's information listed. The report is sorted on the Client's last name. Which property should Janise set to YES for the client information fields to obtain the results she wants?

Hide Duplicate Values

To create a reminder for an import task that is repeated on a regular basis, a(n) ____ may be created.

Outlook Task

All major operating systems for desktop computers, as well as handheld devices, include software that will open and display the ____ file format.

PDF

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

PDF

Because the doctor wants all data entered for parents and guardians regardless of the data in the field, marie must create a calculated field in the query with a function that tests the Mother, Father, and Guardian fields for a condition that is either true or false. If the condition is true, one result will be displayed, and if the condition is false a different result will be displayed. Which function should Marie use for this calculated field?

IIf

The ____ function tests a condition and returns one of two values; the function returns the first value if the condition is true and the second value if condition is false

IIf

The new Internet Protocol that was recently implemented to identify the large amount of Internet users is called ____.

IPv6

A(n) ____ is a company that provides a subscriber with access to the Internet.

ISP

Cayla wants to create a new table for each of the imported files. Which option should she choose from the dialog box that appears during the import process?

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

Which comparison operator defines a condition with a list of two or more values for a field and includes records when the field matches one value from the list in the query?

You can define a condition with a list of two or more values for a field by using the ___ comparison operator

Detail

In the accompanying figure, which report section contains the data for the column "Affiliation?"

Report Footer

In the accompanying figure, which section of the report has a Height property set to zero?

In the accompanying figure, the top values query is designed to return the top values for the ___ field

InvoiceAmt

In the accompanying figure, what is the condition for the calculated expression?

IsNull(Parent)

Through the use of ____ and other technology, software applications are able to run directly through a web browser window.

Javascript

A custom date format set for a Date/Time field that contains the symbols mmm/dd/yy would display the date as ____

Jul/04/16

The input mask character ___ indicates that a letter only must be entered, and the entry is required.

In the accompanying figure, the control type for the selected control is a ____

Label

The format for a label is displayed in the Prototype label box when using the ____.

Label Wizard

In the accompanying figure, which of the following is the truepart of the calculated experession?

LastName & "," & FirstName

In the accompanying figure, the arrow number 2 indicates the form is displayed in the ____ view. (PIC2)

Layout

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. The Facet theme is currently the theme for the form Sergio has created. He wants to change the theme to the Slice theme and apply the Slice theme to all of the database objects. To apply the new theme, Sergio must be in the ____ or Design view. (PIC47)

Layout

To modify a report while viewing actual report data, use the ____ view.

Layout

In the accompanying figure, which view is being used to view the report?

Layout view

Which view is used to make design changes to a form while the form is displaying data?

Layout view

To obtain maximum report width, calculate the report width by subtracting the size of the ____ from the width of the page which will be used to view or print the report

Left and Right margins

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters

To add more flexibility and functionality to a parameter query, comparison operators, such as ____. May be added to the original criterion.

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces

Like "704*"

Allows field values containing letters, digits, spaces, and special characters. Use for long comments and explanations.

Long text

Data in a form created from the primary table is contained in the ____.

Main form

Access uses ____ as the source program to create a graph when the Chart Wizard is used.

Microsoft Graph

To export an Access database object to an HTML document, click the ____ button on the EXTERNAL DATA tab on the Ribbon.

A customizable form that displays multiple records from a source table or query in a datasheet format may be created using the ___ form tool.

Multiple Items

Lists all the objects (tables, reports, and so on) in the database, and it is the main control center for opening and working with database objects

Navigation Pane

In the accompanying figure, the red brackets designate which element of the Access 2013 window?

Navigation Pane, its the big pane on the left that says all access objects

In the accompanying figure, the red brackets designate which element of the Access 2013 window

Navigation pane

After a conditional formatting rule is created using the ____ dialog box, the rule is then available for use in the database from the Conditional Formatting Rules Manager dialog box.

New Formatting Rule

What are the four field naming guidelines?

No Spaces Capitalize the first letter of each word Abbr whn appr n nec Break into smallest part

A criterion may be negated by using the ___ logical operator

Not

Which of the following applications may be used to view an XML file containing the data and the code that describes the data?

Notepad

Which type of report does the accompanying figure illustrate?

Object Definition report

Exists between two tables when one record in the first table matches zero, one, or many records in the second table, and hen one record in the second table matches at most one record in the first table.

One-to-Many Relationship

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. Which field is the common field for the two tables Sergio used to create the form? (PIC45)

ParticipantID

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. Sergio would like to create a form for Carmen to use to enter information about the participants. Which table should Sergio use to create the form? (PIC43)

ParticipantInformation

Sergio would like to create a form for Carmen to use to enter information about the participants. Which table should Sergio use to create the form?

ParticipantInformation

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below. The first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling. Which two tables should Carmen use to create the report? (PIC48)

ParticipantInformation and ParticipantAccount

The first report Carmen would like to create will include all participants and the balance due to participate in the Spring Fling. Which two tables should Carmen use to create the report?

ParticipantInformation and ParticpantAccount

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below. The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report? (PIC50)

ParticipantInformation:Email ParticipantAccount:LocationSite RequestedResources:TableQuantity RequestedResources:ChairQuantity

The faculty sponsor has asked Carmen to create a report that includes the participant email address and the location site assigned to the participant. He would also like to know how many tables and chairs each participant needs. Which tables and fields does Carmen need to use to create the report?

ParticipantInformation:Email ParticipantAccount:LocationSite RequestedResources:TableQuantity RequestedResources:ChairQuantity

Each parks and recreation employee must keep a copy of parent contact information for all campers with them at all times. Using the figure above, which two tables must have a relationship established to allow Leah to print a report of all campers and the their parents' contact information?

Participants and Parents

In the accompanying figure, which field must be used to create a relationship between the Patient table and the Visit table?

PatientID

A form created from related tables usually consists of a ___ table which is the "one" side of the one-to-many relationship with a subform

Primary

The "one" table in a one-to-many relationship.

Primary Table

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

Print Preview

Viewing and printing options for forms and records are available on the ____ tab.

Print Preview

Which report view is the best to use to see what a report will look like when it is printed?

Print Preview

Print All, Pages, and Selected Record(s) are options available from the ____ for printing forms.

Print dialog box

Print preview

Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box

Prototype label

To further personalize her pet sitting service, Janise has decided to mail each client a postcard with a 10% discount for the month of each pet's birthday. She will be creating mailing labels from her Clients table. Janise will set the formatting for the mailing labels in the ____ of the Label Wizard.

Prototype label box

A question you ask about the data stored in a database.

Query

In the accompanying figure, the icons and titles shown in bracket number 2 represent the ____ Access database object.

Query

This icon represents which Access 2013 object? two windows open on eachother with greenish bars at the top

Query

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Query

Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report?

Query

The default name for a new Access query is ____________________.

Query1

Signing up for a(n) ____ will automatically provide you with web content that is updated on a regular basis

RSS feed

A collection of related fields

Record

To find records in a form using a Combo box, it is necessary to change the ___ form property of the form to the table or query that is the source for all the bound controls in the Detail section

Record Source

Using the accompanying figure, which Ribbon group and button would be used to create a new record in an Access database table?

Records group, New button

A tool used to form a group of related controls or to separate the group from other controls is the ____ tool.

Rectangle

A set of rules that Access enforces to maintain consistency between related tables when you update data in a database.

Referential Integrity

The "many" table in a one-to-many relationship.

Related Table

What function does compacting an Access database perform other than reducing the file size?

Repairing the Database

Which control format property adds comma separators and two decimal places in report Design view.

Standard

Provides information about the program or open file, as well as buttons for working with the file.

Status Bar

Sergio and Carmen are planning the Spring Fling event for their college campus. The event will have exhibits, vendors, and entertainment for students. A database has been created to handle registration for all of the student groups, businesses, and other vendors who will be participating in the Spring Fling. The tables in the database and the fields for each table are illustrated in the figure below. After reviewing the form Sergio decides he wants to create a form that will allow Carmen to enter both the participant information and the amount due by the participant. Sergio will need to use two tables to accomplish this. The second table will be the ___ in the form. (PIC44)

Subform

The form control that appears in the Access window with tabs at the top is the ____ Control.

Tab

Set the ____ property to No to prevent users from using the Tab key to navigate to a control.

Tab Stop

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Tab, Enter

A collection of related records

Table

All data in a database is contained in which database object?

Table

This icon represents which Access 2013 object? blue bar at the top with a grid?

Table

Which of the following is an Access 2013 database object?

Table

After Cayla imports all of the data into the Access database, Zach will use the ____ tool to be sure there are no redundant data in the table and review the results carefully.

Table Analyzer

In the accompanying figure the top portion of the table window indicated by the red bracket is the

Table Design Grid

In the accompanying figure, the icons and titles shown in bracket number 1 represent which Access database object?

Tables

_____ was invented to standardize computer interfaces around one type of connection.

The USB port

Which of the following would be a likely reason that an import process from excel to access might fail?

The access field names and the excel worksheet column headings do not match

The appearance of fields in a report that is created using the Report Wizard is determined by ____.

The order the fields are selected in the Report Wizard

Before typing the title, which tool should Janise choose from the DESIGN tab on the Ribbon?

Title

To add a row labeled "Total" to a query design click the ____ button in the Show/Hide group on the DESIGN tab on the Ribbon.

Totals

When working with Access in ____ Mode, the user may tap the buttons on the Ribbon and also tap to use other features of Access 2013.

Touch

To begin the process of removing the default alternate row color in a report, select the ____ Border Style after selecting all sections of the report from the FORMAT tab.

Transparent

A database or a relational database is a collection of related tables

True

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS)

True

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).

True

True/False: A database or a relational database is a collection of related tables.

True

True/False: A form created from more than one table uses the primary table for the main form.

True

True/False: A form's object name appears on the tab for the form in the Access window.

True

True/False: A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut.

True

True/False: Access does not require a field description for every field included in a table.

True

True/False: Access does not require a table to have a(n) primary key.

True

True/False: Access may base queries on one or more tables or queries.

True

True/False: Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

True

True/False: Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

True

True/False: Expression Builder is found in the Query Setup group on the DESIGN tab.

True

True/False: Field values edited in Form view are also changed in the form's underlying table.

True

True/False: In order to define table relationships, each table being joined must contain a common field.

True

True/False: Layout view shows both the form and its data while allowing the form to be modified.

True

True/False: Report fields and field value boxes may be repositioned while viewing the report in Layout view.

True

True/False: The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

True

True/False: The field name displayed in database objects, including forms and reports, is determined by the Caption property.

True

True/False: The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

True

True/False: The process of rearranging records in a specified order or sequence is referred to as sorting.

True

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data

True

When creating a form in Access, the Layout view allows the user to make design changes to the form while it is displaying data.

True

The ____ operating system provides the technological foundation of the Mac OS X.

UNIX

In the accompanying figure, which field property will appear on the screen if the user enters the value 5 in the InvoiceAmt field in datasheet view?

Validation Text

Crosstab queries may use which of the following aggregate functions?

Var

Which property must be set to Yes in the Property Sheet to display a control or a section in the form?

Visible

In the accompanying figure, the primary key for the Vist table is the ____ field.

VisitID

In the accompanying figure, which field is the secondary sort field?

VistitDate

Thanks to _____, voice and data traveling together through our telecommunications lines will be seamless

VoIP

The term ____ implies that the webpage you design with web development software will look the same when published on the web.

WYSIWYG

A _____ provides content that is accessible on the World Wide Web

Web Server

drag the Page Header border down to the desired height

Which option will allow you to increase the height of the Page Header using the mouse?

Brij has contacted each local chapter of the non-profit organization and asked for local donor information. Some local chapters use Excel to record the information, some use Access, and some use other database or spreadsheet applications. To streamline the import process, Brij has asked each local chapter to send him the information in a(n) ____ document that is well suited for data exchange among many different programs.

XML

Which type of file contains the format specifications for Access table data when exporting table data as an XML file?

XSL

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

Yes/No

Which of the following is an example of a parameter query prompt criterion?

[Type the state:]

When creating an input mask, the ___ input mask character is used to indicate that the following character will be a literal display of that character.

A typical Group Footer section will include which type of data?

a count or subtotal for records in that group

Each row in an Access table datasheet displays which of the following?

a record

best fit

In the accompanying figure, what is the name of the table being edited?

billing

The prefix Giga represents approximately one _____ units of information

billion

The _____ system, which uses only two digits, 1 and 0, is commonly used for representing values in computers

binary number

All of the fields added to the form are from the Customer table. These controls are called ____ controls because they are connected to a field in the database.

bound

The _____ is housed in the CPU and temporarily stores frequently used data.

cache

A value that is the result of an expression is displayed in which type of control in a form?

calculated

The expression =Sum([InvoiceAmt]) might be found in which type of control added to aform?

calculated control

The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values

cascade delete related records option

The Access option that deletes a record in the primary table and also deletes all records in related tables that have matching foreign key values.

cascade delete related records option

The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table

cascade update related field option

The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

cascade update related fields option

_ is one of the options available from the page layout group on the Print Preview tab when previewing how a report will print

changing page orientation

Which of the following attributes of a table are saved only when the table object is saved?

characteristics of the fields

In the accompanying figure, the ____ is indicated by arrow number 1.

chart title

In the accompanying figure, which field is the primary sort field?

city

In a(n) ____ relationship, multiple users are provided with access to a server at the same time

client/server

When copying and pasting records from one table to another, the records must first be copied to the

clipboard

When copying and pasting records from one table to another, the records must first be copied to the ____.

clipboard

Clicking on the Close option from the Backstage view in Access 2013 performs which of the following tasks?

closes the current database

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

closes the current database

Typical _____ computing providers deliver common software online that is accessed from another web service or browse

cloud

Embedded systems can be found in all of the following EXCEPT _____

cloud computers

Using the web as a primary user interface to access such applications as Google Docs is an example of ____.

cloud computing

A control that combines the features of a text box and a list box is a ___

combo box

A field used to connect one table logically with another table is called a ____ field.

common

Queries based on more than one table, must have a ____ field

common

Queries based on more than one table, must have a ____ field.

common

queries based on more than one table, must have a _ field

common

Records in separate tables may be connected through a(n) ____________________ that appears in both tables.

common field

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

common field

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

compact and repair

The ____________________ option is available to compact and repair a database file automatically every time the database is closed

compact on close

The ____________________ option is available to compact and repair a database file automatically every time the database is closed.

compact on close

The process of decreasing the file size of a database and enhancing the performance of the database is called ____________________ the database.

compacting

Marie creates the following expression as a new field in the query that she will use to create the report requested by the doctor PatientName: [ LastName] & ", " [FirstName]. This expression is an example of ____.

concatenation

The calculated expression =City & "," & State & " " & ZipCode is an example of ____

concatenation

A criterion or rule that determines which records are selected when a query is run.

condition

A criterion, or rule, that determines which records are selected when a query is run is called a(n) ____.

condition

Formatting used in a report that is applied to certain field values depending on the conditions set for the values is ____ formatting

conditional

formatting used in a report that is applied to certain field values depending on the conditions set for the values is _ formatting

conditional

While editing a chart in Microsoft Graph, properties of any chart control may be accessed by double-clicking the ____.

control

A set of controls grouped together in a form or report that allows manipulation of the set of controls as a single control is a(n) ____________________.

control layout

Which aggregate function supports the Yes/No field data type?

count

which aggregate function supports the yes/no field type data?

count

to design a form using the form wizard, begin by clicking on the _ tab on the access ribbon

create

Carmen and Sergio have created a database for the Spring Fling event at their college. Sergio created forms for Carmen to use when entering data into the database. Carmen needs to create some reports to update the faculty sponsor on the progress that has been made planning the event. The tables and fields for the database along with established relationships are illustrated in the figure below. The faculty sponsor has asked Carmen to email all participants with a balance greater than zero and remind those participants of the due date for payment. Carmen wants to generate a report with participant email addresses only for those participants with a balance greater than zero. Which method would be best for Carmen to use to generate the report? (PIC52)

create a query using a criterion for the balance then create a report based on the query

Carlos needs to decide which cooking demonstrations to offer next month. He would like to offer his five most popular demonstrations. Which method would be best for Carlos to use find this information from his database?

create a top values query based on the field in the CookingDemo table that lists the number of participants

The Access Ribbon tab that allows the user to create database objects such as tables, forms, and reports.

create tab

A calculated field is formatted using the ____ for the field.

criteria

The keyboard shortcut that moves the insertion point to the right of the last character in the field value when in editing mode.

ctrl + end

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

currency

A status box that displays the number of the current record and the total number of records in a table.

current record box

A report created using the Report Wizard and modified in Layout view or Design view is a ____ report.

custom

The Layout view or the Design view may be used to create a ____ form

custom

____ categories may be created to group objects in a way best suited to manage any database in the Navigation Pane.

custom

After choosing the two tables for the new query, Ja'nice must relate the two tables using a common field. What is the common field between the two tables?

customer ID

Which of the following is an Access 2013 database object? a. record b. field c. data d. table

d. table

In the accompanying figure, arrow number 1 indicates which element of the chart?

data marker

In the accompanying figure, the highlighted record entries illustrate a database design with ____

data redundancy

In the accompanying figure, the highlighted record entries illustrate a database design with ____.

data redundancy

The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

data redundancy

A table's contents are shown in rows and columns when using the ____________________ view.

data sheet

AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

data type

An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time

data type gallery

An Access feature available from the FIELDS tab that allows the user to add a group of related fields to a table at the same time.

data type gallery

A table's contents are shown in rows and columns when using the ____________________ view.

datasheet

Which view must be used to delete an entire record?

datasheet

which view must be used to delete an entire record?

datasheet

Which data type would be the best logical data type for a field named PaidDate?

date/time

The ____ property specifies the number of decimal places displayed to the right of the decimal point

decimal places

____________________ values are never allowed by Access in the primary key field

duplicate

____________________ values are never allowed by Access in the primary key field.

duplicate

Data in an Access table linked to an Excel source file may be edited using which process?

edit data in the Excel source file only

which record modification mode is used to insert or delete characters in a field value based on the location of the insertion point?

editing mode

Transistors control the flow of _____ by switching electrical pulses on and off.

electrons

In the accompanying figure, fields inserted into the table using the Address Quick Start fields will be inserted prior to the ____ field.

A chart created with the Access Chart Wizard is ____ in Access.

embedded

in the accompanying figure, how is the match type specified to find the characters "1638"

entire field value

Clicking or tapping on a(n) ____ file will start up a program.

executable

Zach has been given an Excel spreadsheet with each school's asssessment information and needs to integrate that data into the existing Access database. He would like to import each Excel worksheet as a separate table into the database. What is the best option for Zach to use to create a file from the Excel data that can be imported into Access?

export the Excel data for each school as a CSV file

Zach and Cayla have successfully imported all of the data from the school system's assessments into the Access database. Multiple queries have been created from the data, and the school system administrators would like to share the data with the school administrators and teachers using their secure Intranet. What is the best method to use to share the information so that it is easy to read using a Web browser?

export the query results to HTML documents

Brij has been asked to share a report with the non-profit's Board of Directors which lists all donors by state. Brij created a query to appropriately sort the data and generated the report using Access. The report will be shared using e-mail. Which option is Brij most likely to choose to share this information?

export the report to a PDF file to minimize file size and decrease download time

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

external data

A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control. _________________

false

A formatted printout (or screen display) of the contents of one or more tables or queries is a form. ________

false

A primary key that consists of two or more fields is called a(n) redundant key. _________________

false

A query is used to enter, edit, and view records in a database. ______________

false

A question asked about the data stored in a database is called a primary key. ___________

false

A single characteristic or attribute of a person, place, object, event, or idea is a table. ________________

false

A sort field is unique if more than one record can have the same value for the sort field. ____________

false

A table is a predesigned database that includes professionally designed database objects. _____________

false

Access automatically assigns the Number data type to all new fields.

false

Access automatically assigns the Number data type to all new fields. ___________________

false

Access does not allow data to be imported from sources other than another Access database.

false

Access does not allow data to be imported from sources other than another Access database. ____________________

false

Access report printing options may be changed using the Navigation dialog box. ______________

false

All fields in a database should be contained in one table.

false

All fields in a database should be contained in one table. _________________________

false

Arithmetic operations are performed on selected records in a database using Statistical functions. ____________

false

Each record in a table is uniquely identified by a foreign key. ___________________

false

Field names in a table may only be changed in Design view.

false

Field names in a table may only be changed in Design view. ________________

false

Hiding a field in Datasheet view removes the field from the current table.

false

In the Database Design grid, press the Enter key to move from one property to the next property. ______________

false

It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

false

The _____ system is used to represent RGB color in digital graphics.

hexadecimal

The ____ command removes the display of one or more fields in Datasheet view.

hide fields

the __ command removes the display of one or more fields in data sheet view

hide fields

The keyboard shortcut that moves the insertion point left to the first field value in a record when in navigation mode.

home

To avoid the display of a security warning when opening a database, place the database ___.

in a trusted folder

When using ____ as a Service, a business does not have to oversee the storage, backup, or security of its data.

infastruture

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

infinity symbol

The Unicode encoding scheme is used to add support for _____ character sets

international

In the accompanying figure, once the selected field is moved it will appear above which field in Design view?

invoicepaid

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

join

The common field between two tables in the Relationship window is indicated by a(n) ____.

join line

The ____ property prints a group header on a page only if there is enough room on the page to also print the first detail record for a group.

keep header and first record together on one page

ASCII is the encoding standard used to represent _____ in digital form

keyboard characters

A report formatted in _____________________ is wider than it is tall.

landscape orientation

Clicking or tapping this navigation button l> l moves the insertion point to the ____________________ in a table.

last record

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table

last record

In the accompanying figure, which field represents a calculated field?

late fee

Which view is used to make design changes to a form while the form is displaying data?

layout view

In a query, Access sorts fields first based on the sort field that is ____ in the design grid of the Query window when in Design view.

leftmost

in a query, access sorts fields based on the sort field that is _ in the design grid of the query window

leftmost

In the criterion, <=250, the operator will return values for the specified field that are ____.

less than or equal to 250

Which comparison operator matches a pattern that includes wildcards?

which comparison operator matches a pattern that includes wildcards?

Which Excel external data option automatically updates a table in the Access database when the Excel source file is updated?

link to the data source by creating a linked table

Operators that allow two or more conditions to be combined such as And.

logical operators

What is the default setting for the Field Size property for a field with the Number data type?

long integer

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

long text

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

m/dd/yy

Data in a form created from the primary table is contained in the ____.

main form

data in a form created from the primary table is contained in the _

main form

The process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as ____ a database.

maintaining

the process of adding, modifying and deleting records in a database to keep the records current and accurate is referred to as __ a database

maintaining

A Social Security Number which appears in the format 123-456-7891 is an example of a(n) ____

predefined input mask

The process of identifying and eliminating anomalies from a collection of tables is called ____.

normalizing

The comparison operator, < >, is used to insert a condition that means ____

not equal to

A field in an Access database table that has no value is determined by Access to have a ____ value.

null

The value of a field containing no information is a ___ value.

null

Which data type allows both positive and negative numbers as field values?

number

Date criteria are automatically enclosed in ____ when entered in a query design.

number signs

When using the Report Wizard, the report title entered in the Wizard is also the name of the report ____________________.

object

The default theme for a new form that is created is the ____________________ theme.

office

The ascending sort order for the Date/Time data type sorts dates from ____________________.

oldest to most recent

The ascending sort order for the Date/Time data type sorts dates from ____________________.

oldest to most recent date

Based on the criterion for the BirthDate field in the image above, the query will return all patients with a birth date ____.

on or before 12/31/1956

based on the criterion for the birthdate field in the above image, the query will return all patients with a birth date _

on or before 12/31/1956

The default Form Footer section Height property is set to ____ when the Form Footer is added in Design view

one-quarter inch

A form created from two tables that have a ____ relationship creates a main form and a subform.

one-to-many

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a(n) ____ relationship

one-to-many

a form created from two tables that have a _ relationship creates a main form and a subform

one-to-many

Linux is ____ software, which means users can manipulate the source code to customize their operating system to their needs.

open-source

____ software allows the user to copy, modify, and redistribute source code

open-source

It is the job of the ____ to oversee the removal of software programs on a computer.

operating system

Ja'nice wants to create a query that will show her all orders placed on or after July 1, 2015. Which table does Ja'nice need to use for this query?

order info

A record in a table that is related to a prmiary table but has no matching record established with the primary table

orphaned record

A record in a table that is related to a prmiary table but has no matching record established with the primary table.

orphaned record

Data ____ travel over the Internet from router to router until reaching their destinations

packets

A ____ may be inserted manually using the Page Break tool to make navigation of a large form easier by using the Page Up and Page Down keys on the keyboard.

page break control

Data from an Access database exported to an XML file are contained in ____.

paired tags

Carlos would like to create a query based on the Customer table that allows him to type in the name of the cooking demonstration for which the query will run. Which type of query should Carlos create so that he can type in the name of the cooking demonstration before the query runs?

parameter query

Which table in the Chatham database is illustrated in the accompanying figure?

patient

A ____ network is used when a user wants to make his or her computer and others' computers available for access

peer/peer

Read-only memory differs from random access memory due to its ability to _____ store instructions

permanently

In the accompanying figure, arrow number 2 is pointing to which type of chart?

pie chart

When you combine a system's hardware configuration and operating system, it is sometimes called the computer's ____.

platform

A report formatted where the page is taller than it is wide is formatted in ____.

portrait orientation

a report formatted where the page is taller than it is wide is formatted in _

portrait orientation

A computer offers specific _____ to connect peripherals such as keyboards or printers

b

Related study sets

The Market System and the Circular Flow

Chapter 10: Property and Motor Vehicle Insurance

漢字４章

Connect final MC

MA test II

Chapter 3 - RELATIONAL DATABASE DESIGN FUNDAMENTALS

EMS chapter 16

Biology 103 - Module 6 Study Guide

Biology 3 Ch 5 Energy and Life

CJUS 320 Ch. 10-16

Ch 16, 18 Econ.

Theology Chapter 1

Workplace Safety Video

Chapter 2

Philosophy (Glossary)

CHAPTER 12 THE CONTROL OF GENETIC INFORMATION VIA GENE REGULATION

Act 1 scene 1-2 character list

Economics Test #1

2-5-2021

Chapter 4: Cognition, Consciousness, and Language