1) Define a table validation rule for the tblCourse table to verify that StartDa

1) Define a table validation rule for the tblCourse table to
verify that StartDate field values precede EndDate field values in
time. Use The course start date must come before the course
end date as the validation message. Save your table
changes, and then test the table validation rule, making sure any
tested field values are the same as they were before your
testing.2) Create a query to display the InstanceID, TotalCost, and
BalanceDue fields from the tblRegistration table and the Phone and
Email fields from the tblStudent table. Find all records for which
the BalanceDue value is greater than 0. Add a calculated field
named Payer as the first column that concatenates
FirstName, a space, LastName, and (student) if the BillingLastName
field is null. Otherwise, the calculated field should concatenate
BillingFirstName, a space, BillingLastName, and (billing). Sort the
results on the calculated field in ascending order. Save the query
as qryBalanceContacts, run the query, resize all
columns to their best fit, and then save and close the query.I cant attach the database that your supposed to do these two assignments on in the post so just give step by step examples and photos if you can.
Requirements: N/a

Leave a comment

Your email address will not be published. Required fields are marked *