Show:
Database Basics
Tables
Forms
Queries
Reports
100
Collection of data that is stored in a computer system.
What is Database?
100
One of the most importat objects in Access
What are Tables?
100
way to enter data that lets you be certain that you are entering the right data in the right location and format.
What is a Form?
100
This allows you to pull information from one or more tables based on a set of search conditions you define.
What is a Query?
100
A way to share information from your database with someone without letting that person work with your database.
What is a Report?
200
Access stores its lists of data in this.
What is Tables?
200
Columns and rows is the other name for this.
What is another name for records and fields?
200
There are two ways to do this
What is the number of ways you can add a new record to a form?
200
You are defining specific search conditions to find exactly the data you want, when you build this.
What are you doing when you build a query?
200
Reports can use these to help organize information.
What is sorting and filtering?
300
This sets databases apart from any other way of storing data
What is Connectivity?
300
Way of organizing information by type
What is a Field?
300
Forms change this on their own
What is ID?
300
Queries are far more powerful than than this.
What is a Filter?
300
A command center that allows you to print reports, and view them.
What is Print Preview?
400
This is able to understand how lists and objects within them relate to each other.
What is Relation Database?
400
One unit of information that has its own ID number.
What is a Record?
400
These can control how you interact within Forms and Database
What is Database Designers
400
It lets you see how your query is put together.
What is Query Design View?
400
Way to set the width of the margins on your reports.
What is Page Size Options?
500
Four Objects used in Databases.
What are tables, queries, forms, and reports?
500
You use this to help you navigate through the records and find specific items.
What is Record Navigation Bar?
500
Specific name describing the different content and design of a Form and the information on them.
What is Simple Form and Complex Form
500
these help you specify what the query do, by giving the query specific directions.
What are symbols?
500
Way to save reports to
What is Exporting a file