Microsoft Access - Producing Reports
Tom Chandler 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. 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
Speaker Profile
Tom Chandler is the founder, principal trainer and consultant of TechMentors, LLC. TechMentors’ mission is to help people and businesses get more out of technology through training, consulting, and programming. Tom has been a full-time computer trainer, consultant and programmer since 1996. He has developed desktop solutions for multiple organizations including Stanford Medical Center, Visa, Genentech, Blue Shield, Seagate, and the City of San Jose. He has also taught hundreds of students in basic- through advanced-level classes. His specialties include database design with Microsoft SQL Server and Microsoft Access, Business Intelligence with Microsoft Power BI, and Microsoft 365 desktop applications including Excel, Word, PowerPoint, OneNote, Publisher, and Outlook. Tom has a bachelor’s degree in finance from Brigham Young University, and an MBA in IT Management from Wester Governor University.