Exam Review : Exam Review
Components : Components Gimp
Access
PowerPoint
Excel/Finance
Gimp : Gimp
How transparent a layer is : How transparent a layer is Opacity
A fade between two or more colors : A fade between two or more colors Gradient
The amount of color in a photo : The amount of color in a photo Saturation
A shade of a color : A shade of a color Hue
Determines how “picky” the color selector is. : Determines how “picky” the color selector is. Threshold
Allows one to see through multiple layers to layers beneath : Allows one to see through multiple layers to layers beneath Layer Mask
Access : Access
Database vs. DBMS : Database vs. DBMS A database is the collection of tables/forms/queries/reports. Usually one database per topic.
A Database Management System (DBMS) is the software that allows one to view individual databases.
Other Database Managers : Other Database Managers IBM DB2
Oracle
Microsoft SQL Server
mySQL (free) All multi-user dbms
Two Types of DBMS : Two Types of DBMS Single user
Multi User
A row in DB terminology : A row in DB terminology Record
A column in database terminology : A column in database terminology Field
Special field that ensures each record is unique : Special field that ensures each record is unique Primary Key
Determines what type of values are allowed in a field : Determines what type of values are allowed in a field Data Type i.e. Text, Number, Date, Yes/No, Memo, etc.
Symbol which represents all fields : Symbol which represents all fields *
4 Parts of Access : 4 Parts of Access Tables – Where the data is stored
Form – User friendly method of adding/viewing data
Report – Creates a printout of data
Query – Retrieves data based on criteria
Process of connecting form to a table or query : Process of connecting form to a table or query Binding
Used to display 2 or more related tables at one time : Used to display 2 or more related tables at one time Join
Power Point : Power Point A Presentations Software Program
Determines how 1 slide changes to next slide : Determines how 1 slide changes to next slide Transition
Determines how individual objects (text/photos) enter the slide : Determines how individual objects (text/photos) enter the slide Animation
Power Point is part of what larger Microsoft package? : Power Point is part of what larger Microsoft package? Microsoft Office
A predetermined set of background, font size, color, etc. : A predetermined set of background, font size, color, etc. Design Template
Places objects in consistent locations on the screen for multiple slides : Places objects in consistent locations on the screen for multiple slides Slide Layout
Allows one to rearrange the order of slides : Allows one to rearrange the order of slides Slide Sorter
Present / Future Value : Present / Future Value Question asks “How much will I need…”
Future Value
Question asks “How much do I need to have now…”
Present Value
=FV(Rate/12, Length, Mon. Inv.,PV) : =FV(Rate/12, Length, Mon. Inv.,PV)
=PV(Rate/12, Length, Mon. Inv.,FV) : =PV(Rate/12, Length, Mon. Inv.,FV)
Negative values represent money being spent : Negative values represent money being spent
Positive values represent money returning to you : Positive values represent money returning to you
A completely electronic stock trading system : A completely electronic stock trading system NASDAQ In Times Square!
A traditional stock trading system where people buy and sell on the trading floor : A traditional stock trading system where people buy and sell on the trading floor New York Stock Exchange
A method of retirement savings where your company takes out an investment before it goes into your paycheck : A method of retirement savings where your company takes out an investment before it goes into your paycheck 401k
A method of retirement savings where one invests on their own, but can't access the saving until retirement age : A method of retirement savings where one invests on their own, but can't access the saving until retirement age IRA
A measurement of a mutual fund's risk. : A measurement of a mutual fund's risk. Beta
A measure of how many shares of a given stock were traded in a day : A measure of how many shares of a given stock were traded in a day Volume
A collection of 30 companies that are used to measure the country's financial status. : A collection of 30 companies that are used to measure the country's financial status. Dow Jones Industrial Average