A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
1. format row
Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
3. exclamation mark
2. Document tab
1.The record is deleted in the form and from its source table.
2. The record is deleted in the form, but not from its source table.
3.The record is neither deleted in the form, nor from its source table.
4.The record is not deleted in the form, but is deleted from its source table.
1. Between the content of the controls and the outside edge of then controls
2.Between all controls
3.Between the control and the Formâ€™s edge
4. Between controls and gridlines
2. Form Wizard
3.Multiple Item Form
Which of the following database objects can have more than one Group Header/Footer section?
1.Adding groups can help organize the labels.
2. It helps users to create package labels.
3.It allows users to select a label type and size.
4.It allows users to sort the labels.
Which of the following views displays the field name, description, and properties of a table?
______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
4. Report View
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
4. Any number
A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
1. Group Header
4. Page Footer
1. Access Button
Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
1. Design View
4. Print Preview
In a query, using the keyword _______________ will return records in which the field value is between two numbers.
2. Is Null
In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
1.in alphabetical order
2. at the end of the table
3.at the beginning of the table
4.in numerical order
4.with key icon
In the Relationship window, related fields from each table are connected by a(n) _______________.
2. linking tables
3. setup routine
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
1.format an object
2.resize a column
3.use Datasheet View
4.close an object
1.Force all uppercase
3.Store symbols with data
4.Use preset masks
The Table _______________ Wizard analyzes a database and recommends changes for normalization.
To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
1. Clear All Sorts
2.Delete All Sorts
3.Eliminate All Sorts
4.Remove All Sorts
Using the keyword _______________ will return records in which the field value equals a defined text.
2. Is Null
1.Utilizes field placement to improve the efficiency of data entry.
2.Forms store information more efficiently.
3.Forms show the summary of all the records.
4.Forms cannot be edited.
What is the process of eliminating redundant fields by separating data into tables called?
What type of relationship is created when you select a primary key in both related tables?
4. End With
Which mode sizes an image to fit the control while maintaining the proportions of the original image?
1.Add summary functions
3.Group fields into more than one Control Layout
4. Select fields
Which of the following database objects extracts information from one or more tables or queries?
Which of the following field properties enforces the use of parentheses when keying an area code?
1. Field Size
Which of the following field properties is an expression that specifies criteria or requirements for entering data?
3. Input Mask
Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
2.Match: Whole Field
3.Match: Start of Field
4.Match: Any Part of Field
1.Print page 1, 3, and 5
2.Print pages 1 through 5
3. Print selected records
4.Print only the third record
1.A calculated field does not store data in a recordset.
2.Calculated fields use an expression or formula as its data source.
3.Data contained in a calculated field is created the first time a query is run.
4.A calculated field can be created using the Expression Builder dialog box.
1.Criteria can contain wildcard characters.
2. Criteria in a query selects or excludes certain records.
3.Criteria cannot be specified as an expression.
4.Multiple criteria can be specified using AND, OR, and relational operators.
1. It is used to graphically summarize and analyze data in a table, query, or form.
2.It can be used to view different levels of detail or to specify custom layout.
3. It displays field values that can be switched for different views of data.
4.. It displays the same information as a crosstab query, except for the counts and sums of numeric fields.
1.The actual tab order setting for a form can be used in the Form View.
2.The tab order setting determines the movement of the insertion point through a form.
3.The tab order setting is usually right-to-left and top-to-bottom.
4. The default tab order setting can be altered by moving the controls in the Design View.
1.The Top Values property displays only the highest values from the query.
2.The Top Values property requires the fields to have a defined sort order.
3.The Top Values property finds a specified number of records.
4.The Top Values property finds a specified percentage of records.
Which of the following views is used to graphically summarize and analyze data in a recordset?
4. Page Footer