Database Basics
Tables
Forms
Queries
Reports
100
database creation and management program
What is Access?
100
rows
What is records?
100
nsure you're entering the right data in the right location and format
What is forms?
100
way of searching for and compiling data from one or more tables
What is query?
100
give you the ability to present components of your database in an easy-to-read, printable format
What is reports?
200
collection of data that is stored in a computer system
What is databases?
200
columns
What is fields?
200
the menu items that make up each order are recorded
What is Order Items table?
200
When you run a query, the results are presented to you in a table, but when you design one you use a different view
What is Query Design view?
200
a tool that guides you through the process of creating complex reports
What is Report Wizard?
300
plays a significant role in almost any database, and it's important to be able to sort and analyze it; like names and descriptions
What is non-numerical data?
300
rule about the type of data that can appear in that field
What is validation rule?
300
Some forms may include more options, like calendar buttons, drop-down lists, yes-no checkboxes, subforms, and embedded tables.
What is complex form?
300
allows you to create advanced functions that you will not need to use for this tutorial or for most Access functions
What is SQL view?
400
minimize groups of objects you don't want to see
What is upward double arrow?
400
selected to search only for cells that match your search term exactly
What is whole field?
400
The records in these tables include numbers of records from other tables
What is ID numbers?
400
allows you to apply an initial sort, then further organize data with additional sorts
What is multilevel sort?
500
a database that is able to understand how different sets of data relate to one another
What is relational database?
500
ialog box offers several advanced formatting options, including the ability to modify background color, gridline color, and border and line style
What is Datasheet Formatting?
500
to find and view an existing record using a form
What is Navigation Bar?
500
allows you to create a query that can be updated easily to reflect a new criterion
What is parameter query?
M
e
n
u