Database Basics
Tables
Forms
Queries
Reports
100
collection of data in a computer system
What is a database?
100
Stores detailed information
What is a table?
100
A way of entering data which allows you to ensure you're entering the data in the correct location and format
What is a form?
100
They let you pull information from several tables based on a set of conditions the user inputs
What are queries?
100
Allows you to organize and present data in a way in which it can be read by other users, and in a visual manner
What is a report?
200
Numerical and non-numerical data, such as names
What can a database store, specifically?
200
Horizontal rows and vertical columns with cells, the intersection of rows and columns.
What are consisted within tables?
200
They help the database to run better and they are easier to use
What are the advantages of using forms?
200
A one-table query and a multi-table query
What are the two different types of queries?
200
Tables and queries
What can you create reports from?
300
understand how lists and what's in them connects to each other
What is a relational database?
300
Records are rows and columns are fields
What are records and fields?
300
In the records group on the home tab, located on the ribbon, select the New command button
How do you add a new record to a form?
300
In a table
When you run a query, how are results presented?
300
Click the cell and press the delete key
How do you delete a field in a report?
400
Connectivity
What sets databases apart?
400
A record
What is one unit of information in a table?
400
2
How many ways can you find and view an existing record using a form?
400
Datasheet view
What is the specific name for the location in which the query results will be displayed?
400
Exporting
What is it called when you save reports in other formats?
500
Tables
What is the most important object in a database?
500
ID number
What does each record have in a table?
500
Simple forms and complex forms
What are the different types of forms?
500
1. Pinpoint 2. Identify 3. Locate 4. Determine
What are the four steps for planning a query that utilizes more than one table?
500
tool that guides you through the process of making complex reports
What is a report wizard?
M
e
n
u