Show:
Database Basics
Tables
Forms
Queries
Reports
100
the most important object.
What is a table
100
place where all data is stored
What is a table?
100
entering, modifying, and viewing records.
What is a form used for?
100
searching for and compiling data from one or more tables
What is a query?
100
to present your data in print
What is a report used for?
200
Collection of data stored in a computer system
What is a database?
200
Rows and Columns
What are records and fields?
200
make entering data easier
What do forms do?
200
like a detailed question
What is a query like?
200
allow you to present components of your database in an easy-to-read format
What do reports do?
300
Tables, Queries, Reports, and Forms.
What are the four objects in Access?
300
storing information
What are tables used for?
300
visiting a doctor's office, applying for a job, or registering for school
When do you use a form?
300
compiling data from one or more tables
What is a query used for?
300
ability to create a report from any table or query
What do reports offer?
400
a record
What is a row called?
400
identifies each record
What is a ID number?
400
easy way to guide people into entering data correctly.
What are forms used so often?
400
by defining specific search conditions
How can a query be used?
400
tables and queries
Where can information be taken from?
500
a field
What is a column called?
500
Columns and Rows
How is a table formed?
500
help keep data consistent and well-organized
What do forms do?
500
to find the name and phone number of every customer who's made a purchase within the past week
Why would you use a query?
500
Formatted summaries of data suitable for printing
What is a report?