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