1 / 35

Database Forms and Reports Mastery

Learn how to create forms with multiple tables, solve SQL database problems, and design reports in Access. Master the art of creating specific record views and generating various types of reports.

tamra
Download Presentation

Database Forms and Reports Mastery

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. Form and Report

  2. Midterm exam • Friday, October 31, 2008 • Content: Week 1 to Week 8 • Format: • Matching • Multiple choice questions • Database problem solving questions (SQL)

  3. Create forms with more than one table

  4. Create forms with more than one table

  5. Create forms with more than one table

  6. Create forms with more than one table

  7. Create forms with more than one table

  8. Create forms with more than one table

  9. Create forms with more than one table

  10. Create a form to view specific records Create -> Form Design

  11. Create a form to view specific record

  12. Create a form to view specific records

  13. Create a form to view specific records

  14. Create a form to view specific record

  15. Create a form to view specific record Private Sub Command3_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "ViewEmployee" stLinkCriteria = "[Name]=" & "'" & Me![Name] & "'" DoCmd.OpenFormstDocName, , , stLinkCriteria End Sub Form Name Text box Name Field Name

  16. Create a form to view a specific record

  17. Create a form to view specific record

  18. How about this?

  19. Using wildcats * and ? • View a form in Design View

  20. Using wildcats * and ?

  21. Using wildcats * and ? Private Sub Command3_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "ViewEmployee" stLinkCriteria = "[Name] LIKE" & "'" & Me![Name] & "'" DoCmd.OpenFormstDocName, , , stLinkCriteria End Sub

  22. Using wildcats * and ?

  23. Using wildcats * and ?

  24. Report

  25. Why do we need reports? • Final product of most database applications is report • Reports combine information from tables, queries, and forms • Support paperless office

  26. Forms and reports • Differences: • Reports are intended for printing while forms are intended for viewing/interacting with users • Underlying data can’t be changed • No Datasheet view in report • Number of columns, width..etc are controlled by Printer Setup

  27. Reports in Access • Group/totals report • Tabular reports • Others: Single-column report, Multi-column report, Mailing label, unbound report

  28. Creating a report using Report Wizard Create -> Report Wizard

  29. Create a report using Report Wizard

  30. Create a report using report wizard

  31. Create a report using Report Wizard

  32. Create a report using Report Wizard

  33. Create a report using Report Wizard

  34. Create a report using Report Wizard

  35. Create a report using Report Wizard

More Related