Database Terms

Learn about common Access 2000 database terms in this free lesson.

Database terms: Queries and forms

Query: This is data resulting from questions you ask of one or more tables.

lesson arrowExample: Include a list of the female students in Mr. Emerson's class.

students in Mr. Emerson's class - table

females in Mr. Emerson's class - query result

Form: A form is a graphical user interface (GUI) used to enter—and view—data. Forms usually display one record at a time and contain blank fields, allowing for easy data entry.

lesson arrowExample: A new student arrives at Great Lake Elementary School. Using a form, the administrative assistant enters the student's information into the Great Lake Elementary School database. The new data is now stored in the database.

new student form