b
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."
Search
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 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 data sheet. _____
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?
1
In the accompany figure, editing mode is indicated by which numbered arrow? (PIC7)
1
In the accompanying figure, which arrow points to the Tab Control tool?
1
In the accompanying figure, which numbered arrow indicates the report results are filtered?
1
in the accompanying figure, editing mode is indicated by which numbered arrow?
1
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?
10
In the accompanying figure, which arrow indicates the move handle of a control?
2
In the accompanying figure, which number corresponds to the datasheet selector which selects all records in a table?
2
In the accompanying figure, which numbered arrow corresponds to the button which, when clicked, moves all Available Fields to the Selected Fields box?
2
In the accompanying figure, which numbered arrow indicates the Report view button
2
In the accompanying figure, which numbered arrow indicates the property that must be changed for the selected control to display "Guest Last Name?"
2
In the accompanying figure, which numbered arrow indicates the right margin guide
2
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
24
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?
3
In the accompanying figure, which number indicates the Selection type entry?
3
In the accompanying figure, which numbered arrow indicates a number formatted in the Standard format?
3
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.
3
In the accompanying figure, which numbered arrow indicates the chart legend?
3
In the accompanying figure, which record number is the current record?
33
In the accompanying figure, which record number is the current record? (PIC8)
33
in the accompanying figure, which record number is the current record?
33
In the accompanying figure, which numbered arrow indicates the Layout view button?
4
In the accompanying figure the field size is set to
5
In the accompanying figure, which arrow indicates a bound control?
5
How many characters may a field name in Access contain including numbers, letters, spaces, and special characters?
64
What is the maximum character length of a field name?
64
A selected control will display how many sizing handles?
7
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?
<tblReferral>
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.
A
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?
CD
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.
Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?
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?
In
You can define a condition with a list of two or more values for a field by using the ___ comparison operator
In
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.
L
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
Like
To add more flexibility and functionality to a parameter query, comparison operators, such as ____. May be added to the original criterion.
Like
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.
More
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
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. Before printing the report, Carmen uses ____ to view the page breaks and make sure that no records are split across pages. (PIC49)
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
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. By default, data in the reports created by Carmen will be grouped by ____. (PIC51)
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
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: 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
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
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?
like
which comparison operator matches a pattern that includes wildcards?
like
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
ports