Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
61 Cards in this Set
- Front
- Back
|
What is a collection of data in your computer system?
|
Database
|
|
|
What are 3 things a user of a database can do with their data?
|
Enter, access and analyze
|
|
|
Another way to understand a database is to consider it a collection of
|
Lists
|
|
|
How would a database become more complex?
|
Add more lists
|
|
|
What does access store its lists of data in?
|
Table
|
|
|
What is Excel best used for?
|
Storing and organizing numbers
|
|
|
What type of data is Access best used for?
|
Non-numerical data
|
|
|
What are two things you can do with Access since it has non-numerical data?
|
Sort and analyze
|
|
|
What makes databases unique compared to other ways to store data?
|
Connectivity
|
|
|
What type of database understands how objects and lists work together?
|
Relational
|
|
|
What are three things a relational database can do with a table?
|
Enter, search, analyze
|
|
|
What are the four objects that make up a database?
|
Table, queries, forms and reports
|
|
|
A collection of data in a database is organize into connected
|
Lists
|
|
|
What is the heart of a database?
|
Table
|
|
|
Are rows horizontal or vertical?
|
Horizontal
|
|
|
Are columns horizontal or vertical?
|
Vertical
|
|
|
What is a row called in a database?
|
Record
|
|
|
What is a way or organizing information by the type of data it is?
|
Field
|
|
|
In example A, list the three field names.
|
IndividualID, First Name, Email Address
|
|
|
What is considered to be a unit of information?
|
Row
|
|
|
What identifies each record?
|
ID Number
|
|
|
What are three uses for a form?
|
Enter, modify and view
|
|
|
Why are forms so popular?
|
Guide people into entering data easily
|
|
|
What would you use if you wanted to enter data into several tables at once?
|
Form
|
|
|
What are two uses for queries of a table?
|
Search and compile
|
|
|
What allows you to present your data in a printed format?
|
Report
|
|
|
Why are reports useful?
|
Present components in an easy to read format
|
|
|
What can you create a report from?
|
Table or a query
|
|
|
Sets of related data
|
Table
|
|
|
User friendly interfaces for entering and viewing data
|
Forms
|
|
|
Data resulting from questions you asks of one or more tables
|
Queries
|
|
|
Formatted summaries of data suitable for printing
|
Reports
|
|
|
What do you click to see more commands?
|
Tab
|
|
|
What are tabs divided into?
|
Groups
|
|
|
What type of tabs appear when certain items are selected?
|
Contextual
|
|
|
How can you reach more options in the group?
|
Click arrow (bottom right corner)
|
|
|
What is the shortcut to minimize the ribbon?
|
Ctrl + F1
|
|
|
Where can the QAT (Quick Access Toolbar) be found in Access?
|
Above the ribbon
|
|
|
What three commands does the QAT show automatically?
|
Save, Undo, and Repeat
|
|
|
What is the short cut to save?
|
Ctrl + S
|
|
|
Where do you find information about saving, printing, and viewing files?
|
Backstage view
|
|
|
What ribbon do you click on to reach the backstage view?
|
File
|
|
|
Does SAVE save the entire database or just the current object?
|
Current object
|
|
|
How can you secure your database so you must have a password to open it?
|
Encrypt
|
|
|
How is “recent” different than “recently opened”?
|
Recently opened only lists four while recent has a more complete list
|
|
|
How many previous databases are listed under recently opened?
|
Four
|
|
|
What are two items the “help” pane can do?
|
Access help or check for updates
|
|
|
What pane allows you to change the default font style?
|
Options
|
|
|
What pane allows you to choose a template in Access?
|
New
|
|
|
What pane allows you to print preview?
|
Print
|
|
|
What pane would allow you choose advanced options to save your database?
|
Save and publish
|
|
|
What pane lists every object in the database?
|
Navigation
|
|
|
How are the objects organized into groups?
|
By type
|
|
|
List three things you can do in the navigation pane?
|
Open, rename, delete objects
|
|
|
Where is the double arrow located to minimize the pane?
|
Upper right corner
|
|
|
What should you do if the navigation pane takes up too much room but you still need to see it?
|
Rezise it
|
|
|
How can you customize the navtigation pane to minimize groups?
|
Click double arrow next to the name of the group
|
|
|
Why it advantageous to hide tables and rarely used forms, queries and reports?
|
Reduces the change of database being damaged by accidentally editing or deleting data.
|
|
|
To view an object, click it’s
|
Tab
|
|
|
What can appear if you select certain tabs?
|
Sub-tabs
|
|
|
Which object is displayed within the form?
|
Currently opened one.
|
