Which of the following is available in a report but not in a form?

a.Page Footer section

 

b.Group Header section

 

c.Detail section

 

d.Form Header/Report Header section

 

 

Which event is triggered before a record is changed?

a.After Insert

 

b.Before Update

 

c.Before Delete

 

d. On Close

 

Why would you use an append query?

a. Because users need to be able to select records based on varied selection criteria

 

b. To determine which records may need to be deleted from the database

 

c. To summarize the data in a firm’s database to help managers evaluate their financial position

 

d. To copy records from one table to another based on criteria that you specify

 

 

When is it generally useful to run a delete query?

a. A delete query is usually run after an append or make table query.

 

b. A delete query is usually run after an update query.

 

c. A delete query should only be run when you need to delete data permanently from a database.

 

d. A delete query is usually run before an update query.