Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. When creating a report in Access what report tool best outlines the following

ID: 667321 • Letter: 1

Question

1. When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given.

       Label Tool
       Tabular Layout Report
       Blank Report Tool
       Report Wizard

2. Which of the following is a/are question(s) that you should ask before you create an Access report?

       What is the purpose of the report?
       Who will use the report?
       How will the report be distributed?
       All the above questions should be asked

3. Which one of the following report sections appear once on every report page?    

       Report Header section
       Report Footer section
       Page Footer section
       Detail section

4. Which of the following is supported by a primary key?

       Changeable over time
       May be null
       Unique
       Updateable

5. All of the following are reasons to save first name and last name as separate fields EXCEPT       

       fewer fields are used.
       first name could be used in a salutation.
       last name could be used in a salutation.
       you can sort on last name then first name

Explanation / Answer

1. When creating a report in Access what report tool best outlines the following description: This report tool asks a series of questions and helps the designer create a report most suitable based on the answers the designer has given.

Report Wizard

2. Which of the following is a/are question(s) that you should ask before you create an Access report?

What is the purpose of the report?
       Who will use the report?
       How will the report be distributed?
       All the above questions should be asked

3. Which one of the following report sections appear once on every report page?

       Page Footer section

4. Which of the following is supported by a primary key?

Unique

5. All of the following are reasons to save first name and last name as separate fields EXCEPT  

fewer fields are used.