Exam 14: Using Forms and Reports in Access

Datasheet view shows all the fields and records at one time,which provides all the information you need to update your data,unlike in a form or query,where some of the fields or records may not be in view.

Before you can use two tables in a form,you must make sure there is a one-to-one relationship between the tables.

A split form is helpful when you want to work with one record at a time and still see the big picture in the main table.

To update data in a table,you must be in Edit mode.

In a split form,there are buttons on the Navigation bar to move only from record to record,and each record shown at the top is the record highlighted in the datasheet at the same time.

A(n)________ control represents the actual value of a field and is a bound control.

Which of the following is NOT true about editing,adding,and deleting records?

Changes to data are saved automatically,but can be undone while the table or form is open by using the Undo button.

A theme is a built-in combination of colors and fonts.

To break a report into smaller sections,subtotals or groups may be added.

If you want to delete a customer from tblCustomer when referential integrity is turned on,and that customer has appointments in tblSchedule,then the appointments for the customer have to be deleted from the tblCustomer first.

Which of the following is NOT true about navigating forms?

A(n)________ file is usually smaller than the original document,and is easy to send through e-mail.

When the text of a field is selected and highlighted,you are in ________.

A control is a part of a form or report that you use to enter,edit,or display data.