Podcast
Questions and Answers
Where can you create a new blank report that will open in Layout view?
Where can you create a new blank report that will open in Layout view?
What is the process to use the Form Wizard to create a new form?
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?
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?
What is the command to create a new blank form that will open in Layout view?
Signup and view all the answers
How do you move the DOB column between the FirstName and GPA columns?
How do you move the DOB column between the FirstName and GPA columns?
Signup and view all the answers
What steps do you take to add the UniversityLogo image to the form header?
What steps do you take to add the UniversityLogo image to the form header?
Signup and view all the answers
How do you create a Single Record form from the Classes table?
How do you create a Single Record form from the Classes table?
Signup and view all the answers
What is the procedure to preview how a report will look when printed?
What is the procedure to preview how a report will look when printed?
Signup and view all the answers
How can you add automatic totals to the GPA column to calculate the average GPA?
How can you add automatic totals to the GPA column to calculate the average GPA?
Signup and view all the answers
How do you change the width of the DeptName column to approximately 2.3 inches?
How do you change the width of the DeptName column to approximately 2.3 inches?
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.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
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.
