Database Reports and Forms Creation

Questions and Answers

Where can you create a new blank report that will open in Layout view?

Create Ribbon Tab in the Reports Ribbon Group (correct)

Database Tools Ribbon Tab

Home Tab in the Home Ribbon Group

Design Ribbon Tab in the Form Ribbon Group

What is the process to use the Form Wizard to create a new form?

In the Create Ribbon Tab, click the Form Wizard button and select the required fields in the specified order.

How do you group a report by values in the DOB field from Layout view?

Click the Group & Sort button in the Design Ribbon Tab and select DOB as the field to group by.

What is the command to create a new blank form that will open in Layout view?

Click the Blank Form button in the Create Ribbon Tab in the Forms Ribbon Group. Signup and view all the answers

How do you move the DOB column between the FirstName and GPA columns?

Select the DOB column on the report and use the Arrange Ribbon Tab to move it to the desired position. Signup and view all the answers

What steps do you take to add the UniversityLogo image to the form header?

Click the Logo button in the Design Ribbon Tab, then select UniversityLogo from the Insert Picture dialog. Signup and view all the answers

How do you create a Single Record form from the Classes table?

Right-click the Classes table and select the Form option from the Create Ribbon. Signup and view all the answers

What is the procedure to preview how a report will look when printed?

Open the backstage view, click the Print navigation button, then click the Print Preview button. Signup and view all the answers

How can you add automatic totals to the GPA column to calculate the average GPA?

Right-click in the GPA column and select Average from the Total GPA menu. Signup and view all the answers

How do you change the width of the DeptName column to approximately 2.3 inches?

Click on the DeptName column, open the Property Sheet from the Design Ribbon, and enter 2.3 in the Width option. Signup and view all the answers

Study Notes

Report Creation

Blank reports can be created in Layout view using the Blank Report button found in the Create Ribbon Tab under the Reports Ribbon Group.

Form Creation with Wizard

The Form Wizard assists in creating forms, allowing users to select fields from multiple tables.
For a form based on the Departments table, the process includes selecting DeptCode, DeptName, CourseNumber, and CourseDescription in that specific order.
Use a datasheet subform for data organization between Departments and Courses tables, and finish the setup by following prompts in the Form Wizard.

Report Grouping by DOB

Reports can be grouped by the DOB field, with options to change grouping to years.
Controls for grouping and sorting are located in the Design Ribbon Tab, specifically under Grouping & Totals.

Grouping by Classification

Grouping a report by the Classification field involves selecting the desired field and adding it to the group in the Grouping & Totals Ribbon Group.

Blank Form Creation

New blank forms can also be created in Layout view using the Blank Form button located in the Forms Ribbon Group.

Column Reordering

Moving columns in reports requires selecting the desired column (DOB) and placing it between two other specific columns (FirstName and GPA) utilizing the Arrange Ribbon Tab.

Adding Images to Forms

Logos, such as UniversityLogo, can be added to form headers without changing views by using the Logo button in the Header/Footer Ribbon Group.

Creating Single Record Forms

To create a Single Record form from the Classes table, right-clicking the table and selecting options from the Forms Ribbon Group facilitates this process.

Report Print Preview

Reports can be previewed for printing by accessing the Print navigation button from the backstage view and selecting Print Preview.

Automatic Totals in Reports

Automatic totals for columns such as GPA can be added while in Layout view by right-clicking the desired column and selecting the Average option from the context menu.

Adjusting Column Width

The width of specific columns (e.g., DeptName) can be adjusted to prevent text wrapping through setting the width to approximately 2.3 inches in the Property Sheet dialog, found under the Design Ribbon Tab.

Description

This quiz focuses on the fundamentals of creating reports and forms in a database. It covers the use of the Form Wizard, grouping reports by fields such as DOB and Classification, and the organization of data with subforms. Test your understanding of these essential database functionalities.