Access Video Quiz X0.1
By Richard Rost
2 days ago
How Do You Include All End Date Times in Queries?
In Access, what unit is returned when you subtract a clock-in time from a clock-out time? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions covering timekeeping queries, date ranges, regular and overtime hours, and payroll calculations. Track your answers and see how well you know Access date and time functions.
Recommended Courses
Want More?
Keywords
Access Video Quiz, Access timekeeping queries, Access date time subtraction, total query, aggregate query, date range criteria, end date plus 1, overtime calculation, IIf function, payroll calculation, work hours calculation
More InformationTranscript Welcome to another video quiz from Access Learning Zone.
This one is for expert-level users.
Today is Labor Day here in the States, so we got five questions covering Access timekeeping queries.
You'll have three seconds to answer each question. Hit that pause button if you need more time.
Keep track of your scores so you can see how you did at the end.
Are you ready to clock in? Here we go.
Question 1.
An employee clocks in at 8 a.m. and clocks out at 4:30 p.m.
In Access, subtracting time in from time out returns a value measured primarily in what unit: hours, minutes, days, or seconds?
That's going to be days. Access stores date/time values as numbers, with a whole day equal to 1.
Question 2.
You have several work log records for the same employee because they clocked out for lunch.
Which type of query is best for calculating the employee's total hours for the day: crosstab, aggregate, delete, or make table?
That's going to be an aggregate query, also called a total query.
Question 3.
Your employee time query uses Between Start Date And End Date, but shifts later in the day on the end date are missing.
Which criteria correctly includes the entire ending date?
Greater than Start Date and less than End Date.
Greater than or equal to Start Date and less than or equal to End Date.
Greater than or equal to Start Date and less than End Date plus 1.
Equals Start Date or End Date.
That's going to be greater than or equal to Start Date and less than End Date plus 1.
You want to include that whole end date in your query.
Question 4.
A company pays overtime for hours worked beyond 8 hours in a day.
Which Access function is commonly used in a calculated query field to split regular hours from overtime hours: IIf, DLookup, Replace, or Date?
That's going to be the IIf function, immediate if.
Question 5.
An employee earns $20 per hour and works two overtime hours at time and a half.
What should the overtime portion of the Access payroll calculation return: $20, $40, $60, or $80?
That's going to be C, $60.
Yeah, that's just a basic math question. You got to know math to use Access sometimes.
Did you overthink that one?
Alright, how'd you do? Did you get all five?
Are you promoted to chief of not working Monday? Or are you still trying to find the time clock?
Well, if you missed any of these questions, I cover all this kind of material in my Access expert lessons, all kinds of functions and working with dates and times and all that stuff.
Alright, thanks for playing. Post your score down below in the comments, and try not to claim overtime for taking an Access video quiz.
Well, if you can get paid for it, more power to you.
Until next time, live long and prosper, and happy Labor Day. Intro In Access, what unit is returned when you subtract a clock-in time from a clock-out time? Welcome to another Microsoft Access Video Quiz. You will be asked five expert-level questions covering timekeeping queries, date ranges, regular and overtime hours, and payroll calculations. Track your answers and see how well you know Access date and time functions. |
