Database
Mathmatical Operator Symbols
word processing
Types of network and spreadsheat
FORMULA AND BASIC FUNCTION NOTES KEY
100
is a tool used to organize, store, retrieve, and communicate groups of related information.
What is a database
100
+(plus sign)
What Mathematical Operator is used in formulas in Excel for addition
100
when you apply a background color to text
What is a shading
100
A LAN connects devices within a limited area, such as a home or a small group of offices.
What is a LAN
100
instructs the software to perform a calculation
What is a formula
200
1. phone book 2. online library card catalog 3. payroll data including employee names, social security numbers, pay rates, exemptions, etc. 4. eBay and other online businesses use databases to maintain inventory and keep track of customers, products, vendors, pay pal accounts
What is the examples of databases and database uses in business and society:
200
-(minus sign or hypen)
What Mathematical Operator is used in formulas in Excel for subtraction
200
used to create, edit,proofread, format, and print documents
What is a word processing software
200
A WAN is a network that connects devices in geographically separated areas
What is WAN
200
classification indicates that the data has the potential to be used in calculations
What is a value
300
1. Text – used for data that will be sorted in alphabetical order or listed randomly, but will not be used in mathematical calculations. 2. Memo – a data type used for lengthy entries that allows combinations of text and numbers 3. Number – used for data that may be calculated, sorted, or filtered. 4. Date/time – data type used to arrange and sort data chronologically, often used with the input mask field property
What are the data types
300
*(asterisk)
What Mathematical Operator is used in formulas in Excel for multiplcation
300
used to combine text and graphics to creat document such as brochures, greeting cards, annual reports, books,or magazines
What is a desktop publishing programs (DTP)
300
are individual locations on a spreadsheet
What is a cell
300
classification is used for cells that contain text or for numbers that will not be used in calculations.
What is a label
400
1. A table is an arrangement of columns and rows. It is the fundamental building block of all databases. 2. An entry is a single piece of data in a database table. 3. A field is a grouping or category of similar information contained in a table; a unique identifier for a category of information 4. A record is a complete description of all of the fields related to one item in a table.
What are some of the tables
400
/(slash)
What Mathematical Operator is used in formulas in Excel for Division
400
are used to present your findings about a given topic; a research paper
What is a Modern Language association report (MLA)
400
is an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information, usually in numerical form.
What is a spreadsheet
400
Indicates a cell’s location and provides instructions for how cell data is copied or used in calculations
What is a cell reference
500
1. Field size – used to control the size of the field, measured in characters 2. Format – used to control the layout of the field, such as one or two decimal places 3. Input Mask – a template-like field property that regulates how data is entered in a cell. For example, if the phone number input mask is used, the user will be prompted to input data in a specific format, such as (919) 555-5555. 4. Caption – a field property used for column naming that allows a more user-friendly and properly formatted field name than the field name stored in the database design
What are the Field properties
500
=(equal sign)
What Mathematical Operator is used in formulas in Excel for Equal
500
The vertical or horizontal setup of a printed page
What is a orientation
500
which contains one or more spreadsheets
What is a workbook
500
intecates the high value in a range
What is a max
M
e
n
u