DataBase Basics
Tables
Forms
Queries
Reports
100
A collection of data that is stored in a computer system
What is a database?
100
Tables
What is the most important object in Access?
100
A way of requiring information in a specific format
What is forms?
100
A way of searching for and compiling data from one or more tables
What is Queries?
100
Give you the ability to present components of your database in an easy-to-read, printable format
What is Creating Reports?
200
Enter, access, and analyze their data quickly and easily
What is database users allowed to do?
200
All tables are composed of horizontal rows and vertical columns, with small rectangles called cells
What do all tables contain?
200
Data goes exactly where it's supposed to go-- into one or more related tables
What is form in Access?
200
Are far more powerful than the simple searches or filters you might use to find data within a table
How are Queries Used?
200
Access will create a new report based on your
What is object?
300
Collection of lists
What is the easiest way to think of a databases?
300
Records and fields
What is rows and columns?
300
The forms you work with may include special tools and features that let you do common tasks with one click of a button
What is Entering and Modifying Data?
300
When you run a query, the results are presented to you in a table, but when you design one, you use a very different view
What is Query Design view?
300
Click any cell in the field you would like to delete and press delete
What is To Delete a Field in a Report?
400
Access is far stronger at handling non-numerical data, like names and descriptions
Why use a database?
400
A way of organizing information by type
What is field?
400
Records group on the Home tab of the Ribbon, click the New command
What is to add a New Record?
400
You need to be pretty familiar with the different tables in your database.
What is writing a query?
400
Data within your fields and organize those fields into multiple levels, like in an outline or bulleted list.
What is Organizing the Report?
500
Is able to understand how lists and the objects within them relate to one another
What is relational database?
500
Is unique to its record, and refers to all the information within that record
What is ID number?
500
Navigation arrows and navigation search box
What is two ways to find and view an existing record using a form?
500
Pinpoint, Identify, Locate, and Determine
What is Planning a Query?
500
is a tool that guides you through the process of creating complex reports
What is Report Wizard?
M
e
n
u