Using Access’s forms and reports tools, you can design a user-friendly interface for your database. In this training, you will learn how to use those tools in-depth to create easier-to-use databases. You will also learn how to package and password protect your database so that it behaves like a stand-alone application, with only the tools users need to work with being visible.
Access: Designing the Database Interface
- Create relational forms and reports
- Enhance forms with drop-down lists and command buttons
- Use design features to make forms and reports more usable and attractive
- Create a navigation form
- Clean up and package a finished database
- Create parameter queries
- Summarize data using groups, calculated expressions, and aggregate totals
- Perform mathematical and text operations in a query
Enroll in the online course
Follow the appropriate enrollment method below, depending on your IU status.
IU faculty, staff, and students
Join using the self-enroll feature of Canvas (requires IU username and passphrase).Enroll in Access: Designing the Database Interface (IU: No cost)
Join via IU Expand at a low cost (requires an IU Guest account, a free sign-up for anyone).Enroll in Access: Designing the Database Interface (Non-IU: $9.99)
This course is part of an IT Training Certificate Series, which awards a certificate on successful completion of a final online exam. Learn more about the Access Essentials Certificate Series.
Materials and Files
For IU learners, if you're interested in the content for this title, but prefer not to enroll in the online course, you can download the PDF and exercise files below.
Note: The PDF and exercise files provided here formed a basis for the online course, but may vary from the online course.