1 / 13

Day 19: Access Chapter 4

Day 19: Access Chapter 4. Tazin Afrin Tazin.Afrin@mail.wvu.edu October 24, 2013. objectives. Reports Creating report Modify report Use report wizard Report sections Report views. report.

dinh
Télécharger la présentation

Day 19: Access Chapter 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Day 19:Access Chapter 4 Tazin AfrinTazin.Afrin@mail.wvu.edu October 24, 2013

  2. objectives • Reports • Creating report • Modify report • Use report wizard • Report sections • Report views

  3. report • A report is a printed document that displays information from a database in a format that provides meaningful information to its readers. • Most of the printed documents generated by Access will come from reports. • Report tool is used to instantly create a tabular report based on the table or query currently selected.

  4. Create report • Creates a simple report for the currently selected table or query • Create -> Report -> Report Design -> Blank Report • Report Design and Blank Report both create empty reports so you can build your report from scratch • Report Design opens the empty report in Design View • Blank Report opens the empty report in Layout View

  5. Report wizard • The Report Wizard asks you questions and then uses your answers to generate a report. • Allows you to easily create reports that use data from multiple tables or queries • Like the forms, data can be grouped on the reports based on established relationships

  6. Report wizard • Steps of creating report – • Add grouping • Add sorting and summary option • Choose the layout for the report • Save and name the report

  7. Label Wizard • Create->Reports->Labels • Allows you to create mailing labels, name tags, or any other specialized labels based on the data in your database

  8. Modify report • Add a field • Delete a field • Layout control • Adjust column width • Add theme • Sort records

  9. Report sections • Reports have multiple sets of headers and footers… one for the entire report, one for each page • Additionally there is a header and a footer for each grouping • Report Header and Footer section • Page Header and Footer section • Group Header and Footer section • Detail section

  10. Report views • Layout view • alter the report design while still viewing the data. • add or delete fields in the report • modify field properties • change the column widths • add grouping and sorting levels to a report • filter data • Print preview • Print Preview enables you to see exactly what the report will look like when it is printed.

  11. Report views • Design view • Design view displays the report’s design without displaying the data. • Shows report sections • Report view • Report view enables you to see what the printed report will look like in a continuous page layout.

  12. Control types • Bound control • Unbound control • Calculated control

  13. Thank You Log Off

More Related