Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access forms

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007: Forms

Access 2007: Forms

ResolvedVersion Standard

Access 2007: Forms

What is the difference between a query and a form

Edited on Tue 25 Mar 2008, 10:45

RE: Access 2007: Forms

Hi Nicky, Thank you for the post, In answer to your question, a query is a dataset of information which can be extracted from related tables and is presented in table format. There are five main types of query, Select, Parameter, Crosstab, Action and SQL Query. Queries can be used as a souce for Forms and Reports.
Forms provide a different way of viewing Access tables or queries. They are often designed to automate the use of standard paper forms. A well designed form significantly reduces the risk of data entry errors in the table.
There are several benefits to be gained from utilising forms in a database;
Forms can be designed to look like the data source. Different forms can be designed for each input source or each user making data entry more accurate and efficient.
Forms usually display one record at a time, although multiple records can be displayed on screen, single record forms appear less cluttered than multiple record forms.
Forms can often display more fields than a datasheet.
Form fields can be customised to be read-only fields, which cannot be modified by the user.
A variety of control objects such as drop down lists or check boxes can be used to limit the amount of typing that is required and eliminate data entry errors.
I hope that has made it clearer, best regards Pete.

Access tip:

Modal forms

If you have created a form / switchboard and dont want people to get away from using the switchboard, you can change the form properites for Modal to On.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.