Chat with AIExam 4: Query Calculations and Expressions
Exam 1: Office 365 Common Features100 Questions
Exam 2: Introduction to Access87 Questions
Exam 3: Tables and Queries in Relational Databases97 Questions
Exam 4: Query Calculations and Expressions87 Questions
Exam 5: Basic Forms and Reports89 Questions
Exam 6: Data Validation and Data Analysis96 Questions
Exam 7: Action and Specialized Queries98 Questions
Exam 8: Advanced Forms and Reports98 Questions
Exam 9: Get Connected98 Questions
Exam 10: Fine-Tuning the Database100 Questions
Exam 11: Enhanced Database Techniques97 Questions
Select questions type
Match the following formatting options with their examples:
I. Long Date
II. Medium Date
III. Short Date
IV. Long Time
V. Medium Time
A. 12/26/1959
B. 26-Dec-59
C. Saturday, December 26, 1959
D. 3:03
E. 3:03:03 PM
(Essay)
4.8/5 
(38)
(38) Match the following terms with their description:
I. Argument
II. Expression
III. Grouping
IV. Function
V. Constant
A. Combination of elements that produce a value
B. Value that does not change
C. Input used in a function
D. Predefined computation
E. Method of summarizing data
(Essay)
4.8/5 (37)
(37) Which of the following is not an advantage of using the Expression Builder?
(Multiple Choice)
4.8/5 (41)
(41) A totals query allows you to see only the results of aggregate functions, not the detail.
(True/False)
4.8/5 (32)
(32) Which of the following can help you build more complex expressions in calculated fields?
(Multiple Choice)
4.8/5 (34)
(34) 
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)