EXCEL TUTORIAL 10
ACCESS TUTORIAL 9
ACCESS TUTORIAL 9
EXCEL TUTORIAL 9
EXCEL TUTORIAL 9
100
Expresses the relationship between a company's expenses, it's volume of business, and the resulting profit or net income
What is CVP
100
creates a new table by copying records from one or more existing tables
What is Make Table
100
is a join in which the DBMS selects all records from one table and only those records from a second table that have matching common field values
What is Outer Join
100
Calculates the future value of an investment or loan
What is FV
100
another measure of the value of an investment
What is IRR (Internal Rate of Return)
200
the point where revenue equals expenses
What is Break-even Point
200
adds records from existing tables or queries to the end of another table
What is Append
200
displays windows, dialog boxes, command buttons, other controls, and graphical pictures called icons, that you use to communicate with a program
What is GUI
200
calculates the present value of an investment or loan
What is PV
200
Change by constant percentage
What is Growth trend
300
uses two input cell, but unlike a one variable data table, only the value of a single result cell can be displayed.
What is Two-Variable Data tables
300
contains data that is longer no longer needed for current processing but that you might need to reference in the future
What is History Tables
300
a form that appears when you open a database and that provides controlled access to the database's forms, reports, and queries
What is Switchboard
300
calculates the interest rate charged or received during each payment period
What is RATE
300
to fill in missing values when you know the beginning and ending values in a series and the series trend.
What is Interpolation
400
enables you to create as many scenarios as you want, easily switching between the different scenarios to display the results of several what-if analysis
What is Scenario Manager
400
exists between two tables when each record in the primary table matches zero, one, or more records in the related table, and when each record in the related table matches at most one record in the primary table
What is 1 to many
400
is an action, or a set of actions, that you want access to perform automatically for you
What is Macros
400
(cost, salvage, life) Returns the straight-line depreciation in which the asset declines by a constant amount each year, where cost is the initial cost of the asset, salvage is the salvage value, and life is the useful lifetime of the asset
What is SLN
400
When values change by a constant amount; when plotted, a linear trend appears as a straight line
What is Linear Trend
500
lists the values for the changing cells and result cells under each scenario
What is Scenario Summary Reports
500
exists between two tables when each record in the first table matches at most one record in the second table, and each record in the second table matches at most one record in the first table
What is 1 to 1
500
Deletes a group of records matching the criteria you specify from one or more tables
What is Delete Query
500
(cost, salvage, life, period [month]) Returns the declining balance depreciation in which the asset declines by a constant percentage each year, where period is the year of the depreciation and month is an optional argument that defines the number of months that assets were owned during year 1
What is DB
500
the length of time required for an investment to recover its initial cost
What is Payback Period
M
e
n
u