The query statement tells the program what records to search for in the database. Queries can be entered in a data sheet or form, and data can be combined from multiple tables based on related fields in one query. Query wizards are available for creating queries. A query might ask to list all the girls in the 4th grade who have math scores above the 90th percentile but reading scores at or below the 50th percentile, and list them by home room and in alphabetical order. Forms Forms can be used to enter data into a database, display data for review, and print one record at a time.
Forms offer greater control over how information is arranged than when using tables.
One record can be displayed at a time and one form can contain data from multiple tables. For most purposes, it is easier to input data using layout view instead. A Report is a printout of specific, requested information and is used for printing or displaying particular information. Data from multiple tables can be combined in a report. Report Wizards are available for creating reports.