ACCESS CODING

Question 1

New Wage: [Wage Rate]*1.1

Answer 1

increases wage rate by 1%

Question 2

Yes and No commands in Criteria

Answer 2

must equal yes or no from table short text

Question 3

Pay: [Hours]*[Wage Rate]

Answer 3

New section of pay that multiplies hours and wage rate

Question 4

How do you create total section for a counting on Employee IDs?

Example: COUNT for EMPLOYEE ID

Answer 4

1) Σ Total button

2) select count

Question 5

How do you create total section for an average on Employee IDs?

Answer 5

1) Σ Total button

2) select avg

Question 6

Increased Rate: [AvgOfWage Rate]*1.1

Answer 6

create a new section that uses query of avgofwage rate that multiplies 1 percent

Question 7

AvgOfWage Rate: Wage Rate

Answer 7

new title that replaces wage rate title of table

Question 8

Bonus: Date()-[Date Hired]

Answer 8

new section that uses today’s date subtracted by Date Hired

Question 9

Elapse of Time: ([Clockout]-[Clockin])*24

Answer 9

a new section that subtracts clockout and clock in that multiplies by 24 hours.

Question 10

update button?

Answer 10

uses to update information

Question 11

[Wage Rate]+0.5

Answer 11

update wage rate to fifty cents per rate.

in the update to section