Microsoft 365 Access For Dummies, 2nd Edition

Chapter 8

A Form for All Reasons

IN THIS CHAPTER

Creating a form easily with the Form tool

Building a form with the Form Wizard

Adding the finishing touches

Managing Data in Form view

Access forms are similar to paper forms in their function — they’re used in part to collect data — but Access forms go beyond paper forms by having a direct connection to the database tables that store the collected information. Electronic databases such as Access simultaneously place the data typed into an electronic form in the table connected to that form. Forms, therefore, are a tool for adding and editing data, as well as viewing it. They don’t house the data directly, but provide a way to — pardon the expression — access it.

Like reports and queries, forms are named and stored in the database file. Forms are full-fledged Access objects, so you can customize them easily to meet your needs.

This chapter shows what forms can do for you, shows you how to make forms, and provides tips for customizing forms so they’re exactly what you need.

Generating Forms

Depending on your needs, you can create ...