Cascade delete option
A. is used to delete all the records of all tables in a database
B. will repeat the recent delete operation to all the records of current table
C. is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
D. None of above
Select an option to see the answer and solution.
Which object is used to create a form?
A. Tables and Queries
B. Tables only
C. Tables and reports
D. Queries and reports
Select an option to see the answer and solution.
In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
A. formula
B. format
C. layout
D. record
Select an option to see the answer and solution.
After right click the field selector button, which do you choose to delete a field in design view?
A. Delete field
B. delete rows
C. remove field
D. remove rows
Select an option to see the answer and solution.
Which of the following statements about option group is incorrect?
A. It is a control object.
B. It is bound to two fields.
C. It is a control to identify a choice.
D. It contains a set of controls representing choices.
Select an option to see the answer and solution.
The two form layout types will display multiple records at one time are tabular and___
A. columnar
B. justified
C. date sheet
D. pivot table
Select an option to see the answer and solution.
Which of the following queries modifies fields not records?
A. Append
B. Delete
C. Make-Table
D. Update
Select an option to see the answer and solution.
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
A. Text
B. Form
C. Label
D. Field
Select an option to see the answer and solution.
Which leads you through the process of creating a table?
A. wizard
B. assistant
C. relation
D. coach
Select an option to see the answer and solution.
To create primary key for a table when in design view
A. Type PRIMARY in field type box when creating required field
B. Mark the Primary check box in field name of required field
C. Click the Primary Key button in Design ribbon when the cursor is in required field
D. None of the above
Select an option to see the answer and solution.
Which of the following field properties enforces the use of parentheses when keying an area code?
A. Field Size
B. Format
C. Input Mask
D. Validation Rule
Select an option to see the answer and solution.
In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)
A. F6
B. F7
C. F8
D. None of these
Select an option to see the answer and solution.
Which of the following is not a type of relationship that can be applied in Access database
A. One to One
B. One to Many
C. Many to Many
D. All of above can be applied
Select an option to see the answer and solution.
Which of the following functions CANNOT be used in the Totals row?
A. Average
B. Count
C. Maximum
D. Round
Select an option to see the answer and solution.
Which criteria do not return the position "Officer" as a match?
A. position = "*ff*"
B. position = "O??icer"
C. position = " ?ff*"
D. position = "O#r"
Select an option to see the answer and solution.
To remove all Sorts in a table you can click the ______ command.
A. Clear All Sorts
B. Delete All Sorts
C. Eliminate All Sorts
D. Remove All Sorts
Select an option to see the answer and solution.
The expression builder is an access tool that controls an expression___ for entering an expression
A. Table
B. Box
C. Cell
D. Palette
Select an option to see the answer and solution.
The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
A. primary, foreign
B. primary, common
C. foreign, primary
D. foreign, common
Select an option to see the answer and solution.
Which of the following may not be a database?
A. Data presented in table in MS Word document
B. Data entered in Excel spreadsheet
C. A presentation created in PowerPoint
D. A telephone diary
Select an option to see the answer and solution.
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
A. a doctor's sign
B. thin + sign
C. outline rectangle
D. None of above
Select an option to see the answer and solution.