In access, this displays the results of a calculation in a query
A. Lookup field
B. Calculated field
C. Source field
D. Child field
Select an option to see the answer and solution.
If you are creating a cross tab query, what must table you are querying contain?
A. Lots of confusing information
B. More than 100 records
C. At least one field
D. None of the above
Select an option to see the answer and solution.
What type of control in a form can display data from database table?
A. Bound control
B. Unbound control
C. Both of above
D. None of above
Select an option to see the answer and solution.
Which field type will you select when creating a new table if you require to enter long text in that field?
A. Text
B. Memo
C. Currency
D. Hyperlink
Select an option to see the answer and solution.
which of the following is not a data type
A. Picture/graphic
B. Data/time
C. Texst
D. Number
Select an option to see the answer and solution.
When adding an image, which size mode will change the height or width of the image fit the control?
A. Clip
B. Stretch
C. Zoom
D. Crop
Select an option to see the answer and solution.
In a module, a(n) _______ is a series of commands and properties that perform a specific task.
A. event
B. property
C. procedure
D. macro
Select an option to see the answer and solution.
By default, what is the name of a new module in the Modules folder of the Project pane called?
A. Bas1
B. Module
C. New Module
D. Module1
Select an option to see the answer and solution.
You add a table to the query design window
A. Select Edit>Add Table from the menu
B. Select Tools>Add table from the menu
C. Click the Show Table button on the toolbar
D. Select the table from the Table list on the toolbar
Select an option to see the answer and solution.
You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
A. 5
B. 8
C. 24
D. Not enough information to tell
Select an option to see the answer and solution.
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
A. Detail
B. Form Footer
C. Form Header
D. Page Header
Select an option to see the answer and solution.
In MS Access, Field Value may contain
A. Text
B. Date & Time
C. Picture
D. All of the Above
Select an option to see the answer and solution.
How to make a date field DOB store the dates like "2002/10/17" ?
A. By setting the input mask property to "yyyy/mm/dd"
B. By setting the format property to "yyyy/mm/dd"
C. By entering dates in yyyy, mm, dd order
D. none of the above
Select an option to see the answer and solution.
In Access press to Move to the previous page of the wizard
A. TAB
B. ALT+N
C. ALT+B
D. ALT+F
Select an option to see the answer and solution.
The operation of checking input data against specified criteria is known as?
A. Data verification
B. Data validation
C. Cross check
D. Data control
Select an option to see the answer and solution.
A(n)_______ is a major object that can run independent of a control.
A. event
B. property
C. procedure
D. macro
Select an option to see the answer and solution.
(IF [Age]>65, "Senior","Adult") This expression is an example of:
A. A conditional expression
B. Algebraic expression
C. Something that belongs in a Microsoft Excel book
D. A financial expression
Select an option to see the answer and solution.
It is a query that when run displays its own dialog box prompting you for information, such as
A. Select
B. crosstab
C. Parameter
D. Append
Select an option to see the answer and solution.
Which of the following can a Report Wizard NOT do?
A. Add summary functions
B. Create groups
C. Group fields into more than one Control Layout
D. Select fields
Select an option to see the answer and solution.
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
A. format row
B. criteria row
C. aggregate function
D. format layout
Select an option to see the answer and solution.