Show:
Database Basics
Table
Forms
Queries
Reports
100
A collection of data that is stored in a computer system.
What is a database
100
This holds and organizes data.
What is a table
100
An easy way to create new records.
What are forms
100
This allows you to pull information from one or more tables based on a a set of search conditions you define.
What are queries?
100
This allows you to organize and present your data in a reader-friendly, visually appealing format.
What are reports
200
Tables, forms, queries, and reports.
What are the four objects in a database.
200
It is a unique number that refers to each record.
What is an ID number
200
Editing and changing the layout of a form.
What is form design view?
200
This lets you specify exactly what type of information you want your query to retrieve.
What are criteria
200
This is where you get the information for your report
What are tables and queries
300
Tables
What is the heart of a database
300
The horizontal rows and vertical columns in a table.
What are records and fields
300
This is the basic purpose of forms
What is entering and modifying data
300
Used after you set your criteria ready to view the results of your query.
What is the run command?
300
This shows how a report will appear on a printed page
What is print preview?
400
The easiest way to understand a databse.
What is a collection of lists
400
This contains bits of information in a table.
What does a field contain
400
This provides a list of options relating to a specific field
What is a drop down bar
400
This is where query results are displayed.
What is datasheet view
400
Formats you can use to save a report.
What is are PDFs and XPS
500
Being able to understand how lists and objects within a database relate to one another.
What is a relational database
500
When you have a field that you don't plan on editing or don't want other people to edit, you do this
What is hiding fields
500
These allow you to scroll through records one at a time.
What are navigation arrows?
500
Where the selected table appear as a small window
What is an object relationship pane?
500
Saving reports in other formats so that they will be viewable outside of Access
What is exporting