98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007: Forms
Access 2007: Forms
Resolved · Low Priority · Version Standard
Nicky has attended:
Access Introduction course
Access Introduction course
Access Intermediate course
Excel Introduction course
Excel Intermediate course
PowerPoint Intermediate Advanced course
Word Advanced course
Excel Intermediate course
Word Advanced course
Excel Advanced course
Access 2007: Forms
What is the difference between a query and a form
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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Deleting duplicate records from a tableYou 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. |