Database Basics
Tables
Forms
Queries
Reports
100
Database is a structured set of data held in a computer
What is database?
100
Tables sort data in columns and rows
What do tables sort?
100
In forms, one can enter, edit, or display data.
What can one do to data in forms.
100
Queries can make searches easier and faster.
What are the advantages of queries over filters?
100
Reports organize and present data
What do reports do?
200
The kind of information that database contain are a number of tables that are related to one another
What kind of information does database contain?
200
To make a table, first click table wizard, and create data into the datasheet.
How do you make tables?
200
You can make forms by clicking on form wizard and customizing the form's appearance
How do you make forms?
200
You make queries by query design and entering the corresponding data into the tables
How do you make queries?
200
You can make reports by clicking on report and enter the corresponding data
How do you make reports?
300
A database contains a number of tables related to one another
What does a database contain?
300
Address, name, anything that comes in categories
What kind of information does a good table have?
300
You move data in a form by dragging the information boxes
How do you move data in a form?
400
The column is known as a field
What is the column called?
400
As many as you want
How many fields can a table have?
400
By going to form design
How do you edit a form?
400
You enter information by using equations and formulas
How do you specify to search information on a query?
400
Makes it easier to understand the information
How are reports useful?
500
The horizontal data is called a record
What is the horizontal data called?
500
Table are organized by the type of information displayed?
How are tables organized?
500
Forms show information based on the table
What do forms show?
500
Queries are another option to search information without using filter
What is another option to search for specific data without using filter?
500
You can make a mailing label by clicking on labels
How do you make a mailing label?
M
e
n
u