Overview:
Do you need to create a professional looking report? Did you know that Microsoft Access has a powerful and easy to use report builder that can be used with data stored in Access, Excel, or even a CSV text file? This course will teach you how to create multi-page reports using the built-in Access report wizard or from scratch.
Do you need to create a professional looking report? Did you know that Microsoft Access has a powerful and easy to use report builder that can be used with data stored in Access, Excel, or even a CSV text file? This course will teach you how to create multi-page reports using the built-in Access report wizard or from scratch. You will also learn how to enhance the report with filters, sorts, additional labels, images, lines, boxes, borders, colors, headers, footers, page sizes, page breaks, and more.
Areas Covered in the Session:
- Data Sources
- How can my report be based on
- How do you create a report with the report wizard?
- Report Views
- What is the print preview view?
- What is the report view?
- What is the design view?
- What is the layout view?
- How do you create a report of labels?
- How do you create a report from scratch?
- What is a report property?
- How do you filter a report?
- How do you sort data within a report?
- How do you change a report's caption?
- How do you change the default view?
- Page Setup
- How do you change paper size?
- How do you change report margins?
- How do you switch between portrait and landscape modes?
- Report Sections
- How do you insert a report header/footer?
- How do you insert a page header/footer?
- How do you insert a group header/footer?
- Controls
- How do you add a label?
- How do you add a text box?
- How do you add a combo box?
- How do you add a line?
- How do you add a box?
- How do you add an image?
- How do you insert a page break?
- How do you change a control's font, font size, and attributes?
- How do you change a control's font color and background color?
- How do you change a control's border size and color?
Who Will Benefit:
- Small Business Owners
- Administrative Professionals
- Office Workers
- Database Designers
- Data Analysts
- Managers of All Levels