LF logo
by learnformula
search
Log in
search
Courses/Office Productivity/Microsoft

Microsoft Access Databases - Volume 2 - Forms and Reports

Learn how to create forms and reports in Microsoft Access

Created byTom Fragaleworkspace_premium
4.6
(7 reviews)
IntermediateUpdated Jun 18, 2020
Microsoft Access Databases - Volume 2 - Forms and Reports

What You'll Learn

check_circleCreate professional Access forms.
check_circleDesign and customize interactive reports.
check_circleImplement advanced form and report controls.
check_circleAdd dynamic calculations and groupings.
check_circleGenerate mailing labels with wizards.
check_circleBuild user-friendly database navigation.

About This Course

Unlock the full potential of your Microsoft Access databases with "Microsoft Access Databases - Volume 2 - Forms and Reports." This comprehensive course builds on foundational knowledge, guiding you to transform raw data into powerful, user-friendly applications and professional, insightful presentations.

You will master the art of creating intuitive data entry forms and generating dynamic, well-formatted reports. Key learning outcomes include:

  • Designing and customizing forms using AutoForm and the Form Wizard, including advanced controls, properties, and subforms for efficient data interaction.
  • Generating professional reports with AutoReport and the Report Wizard, mastering data grouping, sorting, calculations, and custom layouts to present information effectively.
  • Creating specialized outputs like mailing labels using the Label Wizard.
  • Integrating forms and reports into a seamless, complete Access application with the powerful Switchboard Manager.
  • Optimizing your database with essential finalization steps like setting startup options and hiding navigation panes for a polished end-user experience.

By the end of this course, you will be equipped to build robust, user-friendly Access solutions that streamline data management and enhance data presentation without writing any code.

Your Instructor

Tom Fragale
Tom Fragale

Microsoft Certified Trainer with over 25 Years of Training Experience, and over 40 years in IT overall

menu_book56 courses
star5,752 reviews

Tom Fragale is a computer professional with over 40 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel, and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 50,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Copilot, ChatGPT, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access, and another on Excel Pivot Tables. He graduated in 1988 from LaSalle University in Philadelphia, PA with a B.A. in Computer Science.

Credit Information

Do these courses count toward my professional development requirements?

This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.

If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.

What Students Are Saying

4.6
Student's Choice
7 reviews

Frequently Asked Questions

We are a registered provider with 327+ associations and regulatory bodies worldwide. We operate across 29 global markets including Canada, the US, Australia, and the UK. Every course page clearly displays its specific accreditations. Upon completion, you receive a professional certificate that can be validated online. Our certificates include all necessary accreditation details, credit hours, and completion dates, and are formatted specifically to meet the submission requirements of most global regulatory bodies.