access forms

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

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

Access 2007: Forms

resolvedResolved · Low Priority · Version 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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips


Server loaded in 0.09 secs.