BTEC National ICT U2 - Microsoft Access Reports

Reports are used to:

• Interrogate data

• Store data

• Present data

• Enter data

Which of the following section of a report would you put a logo in and it would only appear once in the report?

• Page header

• Group footer

• Group header

• Report Header

Which of the following sections of a report could you put a page number in for it to appear once on every page? (Choose all that apply)

• Page header

• Page footer

• Group footer

• Report Header

A retail company has produced a report grouping sales by product. They want to total the number of sales of each product. Which sections of the report could they put the calculation in to achieve this? (Choose all that apply)

• Report Footer

• Page Footer

• Group header

• Group footer

In which views of reports can data be viewed but not edited? (Choose all that apply)

• Report View

• Layout View

• Design view

• Print Preview

In which report view can you see and modify the data?

• Report View

• Layout View

• Design view

• Print Preview

If you put a calculation in the Report Footer which records will be used in the calculation.

• All the records on each page

• All the records in one group

• All the records in the report

• A selection of records from the reports.

If you put a calculation in the Page Footer which records will be used in the calculation.

• All the records on each page

• All the records in one group

• All the records in the report

• A selection of records from the reports.

If you put a calculation in the Report Header which records will be used in the calculation.

• All the records on each page

• All the records in one group

• All the records in the report

• A selection of records from the reports.

If you put a calculation in the Group Header which records will be used in the calculation.

• All the records on each page

• All the records in one group

• All the records in the report

• A selection of records from the reports.