Show:
Basics
Basics (cont.)
Basics (cont.)
Managing database
Sorting & filtering
100
Collection of information
What is database?
100
Presentation of data
What is a report?
100
An area in Access that contains all commands
What is a ribbon?
100
Click its tab in the Documents Tabs bar
How to open an object in Access?
100
Sort by ID numbers
What is the default sorting of data in Access?
200
The format of data storage in databases
What is a table?
200
The vertical region in database
What is a column?
200
The horizontal region in database
What is a row?
200
Right-click the object in the navigational panel
How to rename an object?
200
Turn on and turn off the filter
What is toggling the filter?
300
A guide to enter, modify and view data efficiently
What is a form?
300
Columns that contain the same type of information
What is a field?
300
Rows that have the specific information from each category
What is a record?
300
Go to the backstage view
How to open or close the database?
300
Ascending or descending order
What is a way you can sort both text and numbers?
400
Numbers to the left of each row that distinguish the records
What is an ID number?
400
A method of searching the data from tables; search conditions must be specific
What is a query?
400
Opens up the option for saving, printing and viewing database
What is a backstage view?
400
A yellow bar with security warning below the ribbon
What may appear when a database contains customized functions?
400
Equals, does not equal, begins with, does not begin with
What are some search terms that filter texts?
500
Contains non-numerical data and categorizes data by relationships
What is relational database?
500
Characteristics of databases that distinguishes them
What is connectivity?
500
A tab in the ribbon that will only appear when the window is in a certain view
What is contextual tab?
500
Separate documents that need to be opened and saved individually
What are objects in Access?
500
Greater than, less than, between
What are some search terms used to filter numbers?