Creating Access-based applications - Creating forms and reports

In the advanced course, students will build on the basics and learn the details of designing forms and reports, and maintaining databases. The course is recommended for those who will be responsible for designing databases, reports, forms and management in Access.

The course is available for all software versions (2010, 2013, 2016, 2019, O365)

Overview of Access funds
Forms

• Form types (simple, continuous, split, dialog)
• Creating forms with a wizard
• form design, properties
• using controls
• use of special effects (e.g. date selection from calendar, layout view)
• printing forms, using Layout view
• using split form technology
• use of conditional formatting with data bars (Data Bar)

Reports

• Create and design reports
• using templates
• report customisation
• report properties
• sorting and grouping
• terms
• printing reports
• export reports to PDF or XPS

Database maintenance overview, basics

• database compression, recovery
• creating MDE files
• database duplication, creating a copy
• data protection (database password, encryption, decryption, user level data protection)

Completion of or knowledge of our course for beginners on Managing Databases in Microsoft Access, or experience of working with the program.