Mastering Microsoft Access: Reports, Forms, and Combo Boxes in Your Database Projects
Enhance your Microsoft Access skills with this comprehensive guide focused on creating and managing reports and forms. Learn to design effective queries, utilize the Report Wizard, and modify report layouts in Design View. Discover the importance of grouping and subtotals in reports while mastering how to print and save your work. Dive into form creation with the Form Wizard, adding calculated fields, titles, and data viewing techniques. This resource empowers you to effectively use Access for your database needs.
Mastering Microsoft Access: Reports, Forms, and Combo Boxes in Your Database Projects
E N D
Presentation Transcript
Microsoft Access Project Four Reports, Forms, and Combo Boxes
MOUS Objectives • Create a query for a report • Use the Report Wizard to create a report • Use the Report window to modify a report design • Move between Design view and Print Preview
MOUS Objectives • Recognize sections in a report • Save and close a report • Print a report • Create a report with grouping and subtotals • Use the Form Wizard to create an initial form
MOUS Objectives • Use the Form window to modify a form design • Place a calculated field on a form • Place a title on a form • View data using a form
Introduction • Grouping • Subtotal • Alisa Vending Services
Project Four • Opening the Database
Report Creation • Creating a Query
Report Creation • Creating a Report
Report Creation • Using Design View • Report Sections
Report Creation • Changing Properties • Property sheet
Report Creation • Enlarging Controls
Report Creation • Saving and Closing a Report • Close Report Window • Say yes to save
Report Creation • Printing a Report • Select Report • Right Click • Select Print on Shortcut menu
Grouping in a Report • Creating a Second Report • Group header • Group footer • Subtotal
Reviewing the Report Design • Removing Unwanted Controls