Access
select query
A _____ displays data from one or more tables or queries, based on the fields that you select
desktop database
A database that does not require a SharePoint server.
parameter query
A query with user-controlled criteria input.
Print Preview
A specific report view that shows how the database report will appear when printed
Stores each unique piece of data in only one table
A well designed database_____
Bound
A(n) ______ text control displays data from a field
CSV
Abbreviation of "comma-separated values," this is a widely-used format for storing data. File format that uses a comma as the delimiter. These files have a .csv file extension
True
Access will not round the values stored in currency fields
False
Autofilter and filter by selection settings are saved with the database
Short text data type
Can hold up to 255 characters. Should be treated as text
grouping
Feature that organizes records into distinct sections within an access report
Datasheet
Table data and query results displayed in datasheet view
Label control
Unbound control that displays the field name or other text
attachment
Which data type should be used to include an image file with each record in a table?
Default Value Property
adds a preset value to the field.
Currency format
displays a $ symbol before the number and two digits to the right of the decimal place.
innermost sort
in a multilevel sort the last field the data are sorted on.
calculated field
A ____ displays a value returned by an expression
split form
A _____ combines the convenience of a continuous datasheet form with the usability of a Single record form displaying one record at a time.
subform
A _______ is a form within a form that displays records related to the record in the main form
Calculated
An unbound text box control that contains an expression (formula) is called a(n) _____ control
calculated control
An unbound text control that contains an expression (formula).
bound control
Control that displays data from a specific field.
field
Each column in a table
Input Mask
Ensures that users enter data in a database field in a particular format
Find unmatched query
If you want to create a query that shows records from one table that have no corresponding records another table, use a ____
True
Moving a field in design view also changed the field order in datasheet view
stacked layout
Places the form or report labels at the left side with data to the right
macro
Programming instruction that can be run from within a file. Used to automate data entry and formatting processes and to execute commands from buttons in a database
Message bar
Security warning that displays at the top of the window, below the Ribbon.
criterion
Singular form of the word criteria
Tables
Store all the database data
record source
The associated table or query for a database form or report.
False
The currency field format is the same as the currency data type
Primary Key
The field that contains a unique field value for each record in the table
import
To bring data into the database from another file format.
Orientation
To change the direction a report prints on the page, change the page _______
Field Size Property
To control the number of characters a user can enter into a table field use ______
False
To rename a database object, double click the name in the navigation pane and type the new name
export
To save data in a file format accessible to other applications
Tables
What are the building blocks of a database?
parameter query
When you create a _____, you specify the field or fields that the query will use, but you don't specify the exact criteria
Report Wizard
Wizard that walks you step by step through the process of creating a report.
Database
a collection of organized data that allows access, retrieval, and use of data
unbound control
a control that is not linked to a field.
calculated field
displays a value returned by an expression (a formula) Calculated each time the query is run
select query
displays data from one or more related tables or queries, based on the fields that you select.
record
each row in a table
query
extracts data from one or more database tables according to criteria that you set
find duplicates query
finds duplicate records in a table or a query
Form view
provides a user-friendly interface for entering data. You cannot change the form layout or formatting
Long Text data type
A data type that can store up to 65,535 characters in each record. Can be formatted using rich text formatting
relational database
A database that allows you to relate tables and databases to one another through common fields
subform
A form with the form to display the related records from the "many" table in a one to many relationship
Expressions
A formula used in a calculated field in a table or query or a calculated control in a form or report
relational database
A group of tables related to one another by common fields
one-to-many relationship
A relationship between two database tables where the primary table contains a primary key field that is included as andirons (the foreign key) in the secondary table. This one record in the first table can relate to many records in the second table
delimiter
A specific character that separates the fields in text file with multiple data fields. Common delimiters are commas, tabs, semicolons, and spaces
False
A stacked layout placed labels across from the top with columns of data (similar to a datasheet or a spreadsheet)
Quick Start application parts
A table template that you can use to start building a database.
be unique
A table's primary key must_____
table
All data entered into a form are stored in the underlying______
Forms
Allows database users to input data through a friendly intersurface
Field Properties Pane
Allows you to set field properties in table Design view.
Field List pane
Click and drag fields from the ______ to add controls to a blank report
control layout
Combines multiple controls in your database form or report into a single layout object in one or two formats: tabular or stacked
5 quick start application parts
Comments, contacts, issues, tasks, and users
criteria
Conditions that the records must meet in order to be included in the query results
Text box control
Control that displays text, numbers, dates, and similar data. Can be bound or unbound
Format field property
Controls the way the data are displayed to the end user
False
Creating a backup of the database removes unnecessary file space and hidden temporary objects from your database
cascading options
Delete and update options that may be applied to relationships between tables. When they are enforced, actions in one table affect records In the related table.
Calculated field data type
Displays a value returned by an expression (a formula)
Control
Displays data or allows user to enter and edit data in a form or report. Controls be bound, unbound, or calculated
report
Displays database info for printing or viewing on screen
Comma style format
Displays the , symbol within the number and two digits to the right of the decimal
field
Each column in a table represents a specific data value called a ____
True
Each form and report in a database can have its own theme
record
Each row in a table contains all the data for a single ____
not equal to
Entering <>80 as the criteria for a query will return results that are ____
AutoNumber data type
Fields with this data type are automatically assigned its value by access. Database users cannot edit or enter data in an autonumber fields. AutoNumber fields are often used as a primary key if no other unique field exists in the table
Number Data Type
Fields with this data type hold a numerical value
Date and Time Data
Fields with this data type store a numerical value that is displayed as a date and time. The format in which the date and it time displays is controlled by the format property
Currency Data Type
Fields with this data type store a numerical value with a high degree of accuracy (up to four decimal places to the right of the decimal).
Yes/No Data Type
Fields with this data type store a true/false value as -1 for yes and 0 for no
Hyperlinks Data Type
Fields with this data type store a web address or email address
Find unmatched query
Finds records in one table that do not have related records in another table
Input Mask
Forces users to input data in a consistent format
Single-record form
Form that displays one record at a time
Datasheet form
Form that reproduces the exact look and layout of the table datasheet
Report Footer section
Grand totals in a report are added to the _____
find duplicates query
If you wanted to display records of all employees who live in the same city(from the city field in the table), you would use a ____
outermost sort
In a multilevel sort, the first field the data are sorted on.
Foreign Key
In a one to many relationship, the field in the secondary table that relates to the primary key in the primary table
filter
Limits the database records displayed to only those that meet specific criteria. They are temporary and are not saved with the database object unless they are defined in the objects properties
Access Web App
Online database that requires a share point server
False
Page numbers can be added only to a footer section
Navigation Pane
Pane that organizes all the objects for a database. Left side of the screen
tabular layout
Places the form or report lanes across the top, with columns of data
Structured Query Language (SQL)
Programming language used in access and other relational database management systems to define queries
Quick Start field
Provide an easy way to add address fields and other common field groups to your table
Report View
Shows a static view of the database report. You cannot change the layout or formatting of the report.
SQL view
Shows the code used to build the query.
padding
Space between the layout rows and columns in a form or report
Wildcard
Special characters used in criteria to substitute for any character * replaces any string of characters ? Replaces a single character
table
Stores all the database data. Basic building blocks of data
Attachment Data Type
Stores files as attachments to records
Rich Text Format (rtf)
Text format can be used with any word processing program
False
The format field property affects the data stored in the table
Query Grid
The lower pane in Query Design View. Where the fields and criteria for the query are defined
referntial integrity
The policy that ensures that related database records remain accurate. If enforced, no modification can be made to either table that would violate the relationship structure
Form Header
The section directly above the detail section where the data are displayed in a form
Form footer
The section directly below the detail section where the data are displayed in a form
False
The upper pane in query design view shows the query grid where you specify which fields to include in a query
True
To limit query results to only records that meet all the criteria, enter criteria for multiple fields on the criteria row, or enter multiple criteria for the same field separated by the word "and"
Linked Table Manager
Took that allows you to update the connection to linked data
Compact and Repair Database
Tool that eliminates hidden temporary objects that take up database space unnecessarily
False
Users can enter and edit data in an auto number field
Data sheet view
View to use when entering data in a table or to sort and filter data. By default tables open in datasheet view
Layout view
View where you can modify some (but not all) structural elements in a form or report.
Design View
View where you establish the table primary key and table properties as well as specific properties or formatting for individual fields. Use design ire when you want to change the structure or properties of the table
outermost
When sorting a datasheet in more than one field, apply the _____ first
Undo the entire record at once
When you are entering data in a new record in a form the undo command will ______
Relationships window
Window that provides a visual representation of the relationships in your database
Form Wizard
Wizard that walks you through the steps of creating the form, including selecting fields and a layout. Used to create a form combining fields from multiple related tables
False
You can undo a record deletion
True
You cannot change any properties in the linked table
False
You must manually save the record each time you enter data in a table or form
criteria
____ are conditions that the records must meet in order to be included in the query results
split form
combines the convenience of a continuous datasheet form with the usability of a single form displaying one record at a time
Field Size Property
limits the number of characters that can be entered in a text field.