Podcast Beta
Questions and Answers
Forms ensure you're entering the right data in the right ______ and format.
location
This lesson will address the benefits of using forms in a ______.
database
You will review examples of different forms and form ______.
components
Finally, you will learn how to use forms to enter new records and view and edit existing ______.
Signup and view all the answers
Forms are a way of requiring information in a specific ______, which means the person filling out the form knows exactly which information to include and where to put it.
Signup and view all the answers
When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related ______.
Signup and view all the answers
In the Orders Table, the Customer ID field is linked to the ______ table.
Signup and view all the answers
To see the entire order, you would also have to look at the Order Items table, where the menu items that make up each order are recorded. This process involves looking at ______ tables.
Signup and view all the answers
The records in these tables include ID numbers of records from other tables. Glancing at these records may not provide much information because the ID numbers don't tell you much about the data they relate to. This can make data analysis a ______ and tedious task.
Signup and view all the answers
When using a form to view or modify records, you don't have to worry about entering data into the right tables or in the right format—the form can handle these things itself. Forms bring all of the information you need together in ______ place.
Signup and view all the answers
Forms make the data entry process easier for the user and keep the database working smoothly. With forms, database designers can control how users interact with the database and set restrictions on individual form components to ensure all needed data is entered in a valid format. This helps in keeping the data ______ and organized.
Signup and view all the answers
To add a new record to a form, you can follow two ways. One way is to directly add a new record, and the other way is to ______ an existing record.
Signup and view all the answers
