Chapter 4- lab quiz.docx

1 Page

Information Technology Management
Course Code
ITM 102
Catherine Middleton

This preview shows half of the first page. Sign up to view the full page of the document.
Chapter 4- Create Reports  Reports are often based on queries.  You can add the fields that you need to the query, add criteria, and then use the Report tool to create a report to display the results of the query.  After selecting a theme for your database, you can apply fonts or colors from a different theme.  When you are working with an Access object, the status bar contains buttons for switching views.  When a report is based on a query, the query criteria are applied to the report. Here, only the five instructors without a W-4 form on file are listed.  When you select a theme, you are applying a set of fonts and a set of colors. Here, the Elemental font set includes Palatino Linotype for both labels and text boxes.  In this manner, you can combine your current theme with a color or font set from a different theme. Here, the report's fonts have changed to Bookman Old Style for the report header controls and Gill Sans MT for the values in the text boxes. The colors from the Elemental theme are still applied.  Recall that forms and reports are layouts---cells arranged in rows and columns into which controls are placed. You can resize, delete, and merge these rows and columns so the report can be viewed on a screen without scrolling.  When you resize one text box or label in a report's layout, all the label text boxes in that column are also resized.  The entire report now displays within the width of a typical computer screen. The report is wider than a single sheet of paper, as indicated by the dashed vertical line.  When you need to print a report, you can adjust its margins and orientation to fit the size of a sheet of paper. You may also need to remove extra space from the report to prevent printing blank pages.  The first column is very close to the edge of the paper and the Phone column is on another sheet of paper.  When you modify a report so that all the controls fit within a single sheet of paper, some report elements may still extend to a second sheet of paper. When this happens, a warning displays that the second sheet will be empty.  The Error Message describes the problem and lists commands with possible solutions to the problem.  When extra space is removed, blank pages will not be printed. Here, the entire report displays on a single page.  The Blank Report Tool is used when you want to build a report by adding fields one at a time or to arrange the fields in a different layout.  As you add fields with the Blank Report tool, the other tables move to the lower sections of the Field List pane.  When you add a field from another table, that table moves to the upper pane of the Field List and any tables related to this table become available.  Report data can be grouped and sorted to add meaning to it.  Reports can b
More Less
Unlock Document

Only half of the first page are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.