1.   A file that consists of one or more tables and the supporting objects used to get data into and out of the fields

1.   a computer application, such as Microsoft Access, that is used to store data and convert it into information

1.   Data are grouped into similar collections, called tables, and the relationships between tables are formed by using a common field

1.   data contained in a single page or sheet

1.   a complete set of all of the data about one person, place, event, or idea; All the fields on my class roster about one student.

1.   the field that makes each record in a table unique; ex. Student ID number

1.   an interface that enables you to enter or modify record data

1.   a printed document that displays information professionally form a database

1.   Practicing good file management in Access:

a.   Avoid damaging data by copying data and renaming the file.

b.   Access speed –the amount of time it takes for the storage device to make the file content available for use

c.    Access runs best from a hard drive or network drive because those drives have sufficient access speed to support the software.

a.   the data is the lifeblood of an organization.

a.   creates a duplicate copy of the database

a.   when new information is added, the database is being viewed, queries are created or run, or filters are applied and removed.

a.   any growth creates problems.

a.   Reduces the size of the database and eliminates wasted space.

                                              i.     Acts like a disk defragmenter utility. It finds related file sectors and reassembles them in one location if they become scattered from database use.

                                            ii.     You should compact and repair your database each day when you close the file.

                                          iii.     This step often will decrease the file size by _50% or more_.

1.   a grid containing columns and rows where you add, edit, and delete records in a database table

1.   displays the infrastructure of a table, form, or report without displaying the data

1.   exists when each record in the first table may match one, more than one, or no records in the second table

1.   permit data changes to travel from one table to another.

1.   searches the database and deletes all of the related records; ex.  Delete a customer and all his orders will be deleted, too.

1.   connects a primary key change to the tables in which it is a foreign key

1.   ascending) provides an alphabetical list of text data or a small-to-large list of numeric data. (Descending) arranges the records with the highest value listed first

1.   These operations can be done in either order.

1.   displays a chart of the associated PivotTable view

1.   displays when you select a query’s Design view; it divides the window into two parts

Drop zone – 

Row field (Row drop zone)

Column field (Column drop zone) –

 Detail or totals field –

Drill button 

  Filter field (Filter drop zone) – 

Crossfooting

def - Adds the values together

ex - Total contributions for a political campaign by state

def -Counts the non-null items

ex-The number of students who earned an A in ISDS 2001

def - Returns the highest value

ex -The student with the highest GPA

def - Calculates the arithmetic mean – the mean obtained by adding several quantities together and dividing the sum by the number of quantities. It ignores null values.

ex - The average cost of a three-bedroom house in Tulsa.

def - Measures how widely spread the values are from the average when the data describe an entire population

ex - If the average percent salary increase were 3 and the standard deviation were 5, these pay increases differ more than if the average were 3 and the standard deviation were 2. The range is more varied in the sample distribution.

def -Measures the square of the population standard deviation

 ex - Spread or dispersion of salaries for employees in similar positions in an organization.

                                              i.     Line in 2D and 3D, Area in 2D and 3D, and XY Scatter  

                                            ii.     Example:  Plot volunteer hours donated by month; Display sales data by quarter

a.   Pie Charts:  

Pie chart

Doughnut chart

ex - Shows proportion of last week’s revenue generated by product line

 a variation of a scatter chart to show how sets of things compare according to various factors. The sizes of the bubbles show the relative size of the data being plotted.

                                              i.     Example:  Salaries by job title with the size of the bubble representing the percentage of the total salary budget.

 - legend

- axes

- gridlines

- chart title

- plot area

1.   Calculations in a PivotTable

Calculated detail field

Calculated total field

Calculated total field

– a data field used to customize aggregated data