Thus a table represents a collection of records that describe similar data. In a flat-file database, you most likely would have all data stored in a single Access table. These are the objects used to input data into tables as well as view your records one at a time. Although you can enter data directly into a table, forms provide an user-friendly interface for data input, editing, and review. Forms are made up of controls .
Controls are items on the background of a form.
Controls are so named because they control where you can enter or review the data in your tables. Queries may be used to find records from within a single table as well as to combine information from two or more related tables into a single object. Queries may also be used to perform calculations on the selected information. When you design a query, you specify which tables you wish to use as a data source specify which field from those tables contain the information you desire set the criteria for each field so that the query will find the desired information For example, suppose you needed to determine which students were eligible for the particular honorary society. The criteria is all students who have had a minimum of three courses in the department in question with a grade of B or better and an overall GPA of 3.0.