Access Test Concepts
False
(T/F) AutoFilter by Selection settings are saved with the database object.
True
(T/F) 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
2 tables w/ referential integrity enforced
-you cannot add a record to the secondary table w/out an associated record in the primary table -you cannot make changes to the primary table that would cause records in the secondary table to become unmatched
True
A stacked layout places labels across the top, with columns of data (similar to a data sheet or a spreadsheet). (T/F)
be unique for every field
A table's primary key must...
Stores each unique piece of data in only one table
A well-designed database...
Table
All data entered into a form are stored in the underlying...
File
Click this tab to display Backstage view.
False
Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database. (T/F)
Record
Each row in a table contains all the data for a single...
report footer section
Grand totals in a report are added to where?
False
If you have downloaded a file from the Internet and it opens in Protected View, you should never open the file. (T/F)
Excel
Microsoft _____ is a spreadsheet program.
False
Page numbers can only be added to a footer section. (T/F)
False
The upper pane in query Design view shows the query grid where you specify which fields to include in the query. (T/F)
Split form
This combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.
Quick Access Toolbar
This gives you quick one-click access to common commands and is located at the top of the application window above the File tab.
Subform
This is a form within a form that displays records related to the record in the main form.
Ribbon
This is located across the top of the application window and organizes common features and commands into tabs.
File properties
This provides information about a file such as the location of the file, the size of file, when the file was created and when it was last modified, the title, and the author.
Right-click
To display a shortcut menu you _______ an area of the file
ctrl + v
To paste an item from the Clipboard, use this keyboard shortcut..
False
To rename a database object, double-click the name in the Navigation Pane and type the new name. (T/F)
True
Users can enter and edit data in an AutoNumber field. (T/F)
Undo the entire record at once
When you are entering data in a new record in a form, the Undo command will...
True
When you save files to your SkyDrive, they are available to access from other computers that have SkyDrive capability. If you are working on an Excel or Word file, others can be working on the same file at the same time you are working on the file. (T/F)
Account
You can change user information from the _____ page in Backstage view.
You can export Access data to which file format?
False
You can undo a record deletion (T/F)
False
You must manually save the record each time you enter data in a table or form (T/F)
forces users to input data in a consistent format
an input mask...
Calculated
an unbound text box control that contains an expression (formula) is called a _________ control.
criteria
are conditions that the records must meet in order to be included in the query results.
Tables
are the basic building blocks of a database
Field
each column in a table represents a specific data value called a...
not equal to 80
entering <>80 as the criteria for a query will return results that are...
find duplicate query
if you want to create a query that shows records from one table that have no corresponding records in another table, you use this...
True
the Currency field format is the same as the Currency data type (T/F)
False
the Percent field format displays the % symbol in the data table. (T/F)
Page numbers
this design element is not available in forms
calculated field
this display a value returned by an expression
select query
this displays data from one or more tables or queries, based on the fields that you select
bound
this text control displays data from a field.
orientation
to change the direction a report prints on the page, you will change the page to?
the Field Size property
to control the number of characters a user can enter into a table field, use what?
attachment
to include a photo image with each record in a table, use a field with this data type:
double-click the column header, and type the new field name
to rename a field...
parameter query
when you create this, you specify the field or fields that the query will use, but you don't specify the exact criteria.
field list pane
you click and drag fields from this to add controls to a blank report.
