QUERY AND FORM IN ACCESS

STEPS TO RUN QUERY WHEN THE QUERY CONDITION/SEARCH STRING IS NOT EXACT  

A query condition is said to be not exact when the search string is unspecific  i.e when one is searching for a group of information in a database.

STEPS TO CREATE QUERY

1.       Open the database you want to query

2.       Click on query

3.       Click on new

4.       Click on design view

5.       Select the table you want to use for the query

6.       Click on ok

7.       Click on add and close

8.       Under fields, select all the fields names in you want to query

9.       Under criteria, type the search string/criteria

10.   Click on run    

FORM:  Form can be defined as a command used to select records to be produced as hardcopy in a database.

STEPS TO APPLY FORM:

1.       form finish Open database you want to produce it

2.       Click on form

3.       Click new

4.       Click on form wizard

5.       Select the table or query you want to use for the form

6.       Click on ok

7.       Select the field names you want

8.       Click on next

9.       Select the layout of your choice and click on next e.g Tabular

10.   Select the style of your choice and next

11.   Type the title of the

12.   Click on finish