What is the purpose of a form in Microsoft access?

Answer 1

Forms allow you to display data in a more presentable form than a datasheet can. It can allow you to see all the fields at once, or just some of the fields. It can also allow you to generate other data from the existing data, like showing a calculation from figures on the form. Forms allow more functionality by having controls on them, such as buttons. They can link into queries. They can set up subforms for presenting data in relationships. There are many other things they can do, so they are very useful for databases.

Answer 2

Sounds like a "do my homework for me" question, but the answer is fairly simple.

A form can be used for several purposes.

1) To present on on-screen "form" which can be used for data entry to an Access database e.g. the details of a customer order. The form can get the data in a simple way which customers or sales staff can fill in and then the form can make sure that the information gets put into the correct place in the database.

2) It can be used to display information gained from another part or parts of the database e.g. details of a club member. This would be used if the information required was a one-off, perhaps when answering a query over the phone. When details of sets of information are required (e.g. all companies with a turnover of more than 10 million a year) then a report is the tool needed.

3) It can be used to create a "splash screen", and then give easy access (e.g. via an on-screen "button") to other parts of the database, including other forms.

4) It can be used to generate a dialog box for the user, with buttons which can be pressed for interaction with the database contents. Basic interaction can be done using built-in dialog boxes, but custom dialog boxes built with forms can accept very database-specific interaction - "Do you want to include (a)part-time, (b) suspended students?"

You can get all of this information by looking at Access's own Help Screens. they have material on the basics of Access - look there.

Answer 3

A form is a database object that you can use to create a user interface for a database application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.

Answer 4

Forms are used in Access to make data entry less tiresome for the typist. Its as simple as that.

Answer 5

A form is a simple way to display data for a number of users. Setting up a form correctly can increase the speed users work at.