Which Access 2016 view shows the contents of a table as a datasheet? |
Datasheet view |
Each row in an Access table datasheet displays which of the following? |
a record |
Each column in an Access table datasheet represents a ____. |
field |
The specific content of a field is referred to as the ____. |
field value |
Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables? |
common field |
What is the purpose of the primary key? |
to uniquely identify each record in a table |
Which Access 2016 view contains commands used to manage Access files and options? |
Backstage view |
Another term used for the column selector feature is ____. |
field selector |
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 view is used to make design changes to a form while the form is displaying data? |
Layout view |
What function does compacting an Access database perform other than reducing the file size? |
repairing the database |
Which of the following is the file extension used for Access 2016 database files? |
.accdb |
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 |
Which data type allows field values to contain letters, digits, and other characters? |
Short Text |
When copying and pasting records from one table to another, the records must first be copied to the ____. |
clipboard |
____ is the default name for a new table in an Access database. |
Table1 |
The ____ property allows the database designer to explain the purpose of a field or how a field is used. |
Description |
A field used to connect one table logically with another table is called a ____ field. |
common |
When choosing field names, it is best to choose names that ____. |
describe the content or purpose of the field |
The default character length for the Short Text data type is ____ characters. |
255 |
The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of acondition. |
Yes/No |
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 |
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 |
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 field in an Access database table that has no value is determined by Access to have a ____ value. |
null |
Changing the order of fields in a database table is an example of changing a table's ____. |
structure |
The common field between two tables in the Relationship window is indicated by a(n) ____. |
join line |
By choosing the Definition Only option in the Import Objects dialog box, the ____ of a table is imported, but notthe ____. |
structure, data |
A relationship between Access tables that is a relationship between one record in the first table and zero, one, ormany records in the second table, and at least one record in the second table matches at most one record in thefirst table, is defined as a ____ relationship. |
One-to-Many |
Results of a query may be viewed at any time by clicking the ____ button in the Results group on the Ribbon. |
Run |
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 |
Which view must be used to delete an entire record? |
Datasheet |
A query based on more than one table is a(n) ____query. |
multitable |
Queries based on more than one table, must have a ____ field. |
common |
A field with the Short Text data type sorted in descending order will display the data in which order? |
Z to A |
The comparison operator, < >, is used to insert a condition that means ____. |
not equal to |
In the criterion, <=250, the operator will return values for the specified field that are ____. |
less than or equal to 250 |
Date criteria are automatically enclosed in ____ when entered in a query design. |
number signs |
A combination of database fields, constants, and operators that are used to perform a calculation is called a(n) ____. |
expression |
Which aggregate function would be used to calculate the lowest field value for the selected records? |
Minimum |
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 |
____ is the default entry for each field in the Total row of the query design grid. |
Group By |
Which comparison operator matches a pattern that includes wildcards? |
Like |
Statistical information such as totals and averages is calculated using ____. |
aggregate functions |
Data in a form may only be modified in ____ view. |
Form |
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 form created from two tables that have a ____ relationship creates a main form and a subform. |
one-to-many |
A report formatted where the page is taller than it is wide is formatted in ____. |
portrait orientation |
Data in Date/Time fields are automatically ____-aligned. |
right |
Formatting used in a report that is applied to certain field values depending on the conditions set for the values is____ formatting. |
conditional |
Which Access database object is best to use for the basis of a report when specific criteria must be applied to the report? |
query |
Data in a form created from the primary table is contained in the ____. |
main form |
It is often easier to maintain data in a datasheet using a form because all changes for a ____ are the focus atone time. |
single record |
A wildcard character used as the first and/or the last character in a character string to match any number ofcharacters is the ____ character. |
* |
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 the condition is false. |
IIf |
The standard naming convention prefix tag for a query used to identify the object type is ____. |
qry |
The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters. |
Like |
Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces. |
Like "704*" |
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 form the list in the query results? |
In |
Which of the following is an example of a parameter query prompt criterion? |
|
To add more flexibility and functionality to a parameter query, comparison operators, such as ____, may be added to the original criterion. |
Like |
A Social Security Number which appears in the format 123-45-6789 is an example of a(n) ____. |
predefined input mask |
To avoid the display of a security warning when opening a database, place the database ____. |
in a trusted folder |
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 |
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. |
\ |
Which query wizard allows the user to choose the field that will be calculated for each row and column intersection? |
Crosstab Query Wizard |
Which type of query would show results indicating two different student ID numbers have been assigned to the same student? |
find duplicates query |
Which Access object(s) may be used when creating a lookup field to select values? |
table |
You can define a condition with a list of two or more values for a field by using the ____ comparison operator. |
In |
The Layout view of the Design view may be used to create a ____ form. |
custom |
A control that combines the features of a text box and a list box is a ____ |
combo box |
A customizable form that displays multiple records from a source table or query in a data sheet format may be created using the ____ form tool. |
Multiple Items |
Which form tool displays data in both Form view and Datasheet view at the same time? |
Split Form |
Which view or tool allows the form designer the most control and precision when designing a form? |
Design view |
A value that is the result of an expression is displayed in which type of control in a form? |
calculated |
Which property must be set to Yes in the Property Sheet to display a control or a section in the form? |
Visible |
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 Layout view are added to the ____ section of the form. |
Form Footer |
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 |
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 number of occurrences of an expression is determined using the ____ function in a form or report. |
Count |
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 |
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 ____ refers to the order in which the focus moves from one control to another control when a user presses the Tab key. |
tab order |
A subform may be added to a main form by using the Subform/Subreport tool or by using the ____. |
Subform Wizard |
Which report view is the best to use to see what a report will look like when it is printed? |
Print Preview |
To modify a report while viewing actual report data, use the ____ view. |
Layout |
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. |
height |
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 |
The ____ section appears at the bottom of each page of a report is used for page numbers and brief explanations of symbols or abbreviations, among other elements. |
Page Footer |
The text box property that allows the box to expand vertically to fit the field value is the ____ property. |
Can Grow |
Which section contains content that will appear at the top of every page of a report? |
Page Header |
Spacing and punctuation for mailing labels is determined by spacing and punctuation inserted in the ____ box. |
Prototype label |
Extra Light and Semi-Bold are examples of which feature available in the Label Wizard? |
Font weight |
Which option will allow you to increase the height of the Page Header using the mouse? |
drag the Page Header border down to the desired height |
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 |
Values in a CSV file are separated by which symbol? |
, (comma) |
The form control that appears in the Access window with tabs at the top is the ____ Control. |
Tab |
A chart created with the Access Chart Wizard is ____ in Access. |
embedded |
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 |
Access uses ____ as the source program to create a graph when the Chart Wizard is used. |
Microsoft Graph |
While editing a chart in Microsoft Graph, properties of any chart control may be accessed by double-clicking the ____. |
control |
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 |
Which type of file may be used to export an Access report and reduce the file size to minimize downloading time? |
|
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 |
A make-table query is a(n) ____ query that creates a new table by copying records from one or more existing tables. |
action |
An action query that changes selected field values form selected records in one or more tables is a(n) ____ query. |
update |
A(n) ____ query adds records from existing tables or queries to the end of another table. |
append |
Many-to-many relationships are created using a third table that forms ____ relationships with the two original primary tables. |
one-to-many |
A one-to-many relationship is formed when two tables are joined using ____. |
a common field |
When each record in the first table matches at most one record in the second table, and each record in the second table matches at most one record in the first table, a(n) ____ relationship exists between the two tables. |
one-to-one |
Which of the following table names would appear in Design view to indicate a table being used in a self-join relationship and distinguish it from the first instance of the table in the relationship? |
tblPatient_1 |
A(n) ____ value is not allowed in an index if the setting for the Primary property is Yes. |
null |
A multiple-field index must be created using ____. |
the Indexes dialog box |
Records deleted using a Delete query may not be restored by using the ____ command. |
Undo |
An Access action that finds the first record (or the next record, if the action is used again) that meets specified criteria. |
FindRecord |
The development environment in Access that is used to create, view, and modify macros is the ____. |
Macro Designer |
A button that performs an action when the user clicks on the button is a(n) ____ button. |
command |
Which macro feature is used to run a macro one step at a time to verify that arguments are correct and the macro runs appropriately? |
single step mode |
Using VBA code, a group of statements may be created that set the event property value to the name of that group of statements; Access will then execute an event ____ when the event occurs. |
procedure |
Most database developers prefer to prevent inexperienced database users from using which type of query? |
action |
Which of the following describe the five SQL statement types? |
select, update, delete, insert, create |
In a SQL SELECT statement a field name enclosed in square brackets like this most likely refers to which of the following field names from the selected table? |
Last Name |
Access 2016 provides ____ predefined layouts for navigation forms with different layouts for the placement of tabs and subtabs. |
6 |
When Access opens a form or report, the ____ event occurs. |
Load |
VBA procedures are created, modified, and displayed in the ____ window. |
Code |
Visual Basic for Applications is a(n) ____ provided with Microsoft Office programs. |
programming language |
Which of the following is a type of VBA procedure? |
Function |
VBA code is created and modified using the ____. |
Visual Basic Editor |
Which of the following color options may be assigned to a control property as a VBA constant? |
vbRed |
The Immediate window allows the developer to test or ____ individual lines of VBA code. |
debug |
A control is not displayed when the Visible property is set to ____. |
False |
Color values for controls may be coded in several different ways. Which type of color value represents color intensities of red, green, and blue instead of the color values ranging from 0-255? |
hexadecimal |
A comment line in the Code windows is indented and appears in the color ____. |
green |
Which VB constant used in conjunction with the StrConv function will convert all characters of a string to upper case letters? |
vbUpperCase |