Database forms

Question 1

What is a form in the context of databases?

Answer 1

A form is a database object that you can use to enter, edit, or display data from a table or a query.

Forms are essential for interacting with database records.

Question 2

What are the primary functions of forms?

Answer 2

Forms can be used to:
* Enter a new record
* Modify an existing record
* View records already stored in a table

These functions facilitate user interaction with the database.

Question 3

What is an advantage of using forms for data entry?

Answer 3

When data is entered into the form, it is automatically stored in the correct table.

This feature enhances data integrity and reduces manual errors.

Question 4

How do forms contribute to data accuracy?

Answer 4

Forms provide greater consistency and accuracy of data entered.

This is crucial for maintaining reliable database information.

Question 5

What customization options are available for forms?

Answer 5

Forms can be customised with logos and colours.

Customization enhances branding and user experience.

Question 6

What are the characteristics of a good form?

Answer 6

A good form:
* Has a user-friendly interface
* Hides complexity from the user
* Provides options for the user to speed up data entry

These characteristics improve usability and facilitate data input.

Question 7

Fill in the blank: A good form has a _______ interface.

Answer 7

[user-friendly]

User-friendly interfaces are essential for effective data entry.

Question 8

True or False: Forms can be used to delete records from a database.

Answer 8

False

Forms are primarily for entering, modifying, and viewing records, not deleting.