Mis Exam3

Front 1

Data series –

Back 1

range of values with 3 components

Front 2

Category axis –

Back 2

horizontal axis containing categorynames (for column and line charts)

Front 3

Value axis –

Back 3

vertical axis containing values generatedby the high and low values found in the data series

Front 4

Category names

Back 4

become axis labels

Front 5

Data series names

Back 5

become the legend

Front 6

Datapoint –

Back 6

each value in the worksheet

Front 7

Data marker –

Back 7

represents the datapoint in the chart

Front 8

Column –

Back 8

used to make comparisons – most common type; Excel’s default chart type; F11creates automatic column chart

Front 9

Stacked column –

Back 9

used to show percent to total• Line – used to show trends over time

Front 10

Pie –

Back 10

used to show relative proportions or parts ofa whole

Front 11

Bar –

Back 11

same as a column; axis reversed

Front 12

Hints for Effective Charts

Back 12

Limit the details – should convey a simple and obviousmessage• Use descriptive titles • Chart consistent categories • Use special effects like arrows, text boxes, callouts • Watch 3-D charts – they may be difficult to read (exceptfor pie)• Use gridlines in moderation • Limit the use of different text styles to no more than 2 • Limit the number of data series used in the chart:– Line – no more than 3 – 4 – Pie – no more than 6 slices

Front 13

Sparklines

Back 13

Mini chart displayed in a single cell

Used to convey onemessage in a minimum amount of space

Front 14

You can change the way Excel has interpreted thedata with the Switch row/column button on the

Back 14

Chart tools/Design ribbon

Front 15

Database Hierarchy

Back 15

Related characters = field

Related fields = record

Related records = file

Related files = database

Front 16

Field –

Back 16

represents an attribute or measurement of some object or event

Front 17

Record –

Back 17

group of related fields about one object or event

Front 18

Fields are in

Back 18

columns

Front 19

Records are in

Back 19

rows

Front 20

Pivot Table Field List –

Back 20

list of the column headings

Front 21

Pivot Table Report –

Back 21

area used to construct and analyze the results

Front 22

Pivot Table Tools –

Back 22

commands found on the Ribbon under the Options and Design tabs used to adjust the settings and appearance of a Pivot Table

Front 23

DBMS – Database Management System

Back 23

Package of computer programs and documentation that lets youestablish and use a database

Front 24

Database –

Back 24

organized collection of related data that allows access, retrieval, and use of the dat

Front 25

Table –

Back 25

the part of the database that holds the data similar to a2-D table in which columns are fields and rows are records

Front 26

Query –

Back 26

set of conditions that provides for retrieval of certainrecords from a table

Front 27

Report –

Back 27

provides the specifications for output of data in atabular format

Front 28

Form –

Back 28

customized manner of inputting data into a database(usually presents one record at a time)

Front 29

Data dictionary –

Back 29

document that contains a list of tables that are designed andmaintained for the business

Front 30

Primary key –

Back 30

field or fields which uniquely identify each record

Front 31

Foreign key –

Back 31

field in one table that also is stored in a different table as aprimary key

Front 32

Referential integrity –

Back 32

set of rules that ensures that data stored in related tables remain consistent as the data are updated. Also called validation

Front 33

Data redundancy –

Back 33

occurs when unnecessary duplicate information exists in database

Front 34

Common data types

Back 34

Long text-used for long messages or descriptions; can becombinations of numbers or words–Short Text-used for descriptive information –Date/Time-used for date and time data

–Currency-used for monetary data; can be used in calculations

–Number-used for any number; can be used in calculations

Front 35

Select Query-

Back 35

Basic

Front 36

Nested -

Back 36

building a query from a query rather than a table

Front 37

Crosstab –

Back 37

used for evaluating trends over a period of time byplacing data into a 2-dimensional table

Front 38

Advanced –

Back 38

using several comparison operators to expand thetypes of criteria

Front 39

Record set (data set) –

Back 39

the records that satisfy the query

Front 40

Guidelines for Good Table Design

Back 40

Include necessary data

Design for the next 100 years

Design in compliance with Sarbanes Oxley Act (SOX)

Store data in smallest parts and set up data types and properties asaccurately as possible

Remember that Access stores dates as serial numbers (like Excel)and can perform date arithmetic

Front 41

Labels –

Back 41

used to add descriptive information, like column headings

Front 42

Text boxes –

Back 42

used to display data or calculations, usually connected to a field or calculated field

Front 43

Custom fields –

Back 43

those that a created in the query, butare not in the table

Front 44

Calculated field –

Back 44

custom fields that contain theresults of a formula or function