3 different approaches to data analysis by query
Summarize & group
Construct calculations
Cross Tab query
Used when u need info on groups of records taken as a whole
summary query
Adds a more complex expression to a field
calculated field
Computes sum, avg, count, min, max, etc
predefined totals calc
Displays summarized values from one field in a table
crosstab query
Brings together specific info from diff tables
custom forms
Summarizes information available in the tables connected to forms
calculated controls
Formula that is used to calc a value w/in a control
control source
Constructs a calc control on a forum
expression builder
Square brackets identify _____ when creating an expression
field
3 areas of a form
Header, detail, footer
Aligns form controls to a grid
snap to grid
A permanent part of the database
embed
An external part to the database
link
Complex system of interconnected networks
internet
______ is a collection of info available on the internet that's connected by
______
web, hyperlinks
Traditional networking paths to identify remote data
universal naming convention
address to which progs can jump
hyperlink
hyperlinks use ______ to ident remote data
uniform resource locator
set of rules used to access data
protocol
plain text and commands
tags
markup language
hypertext markup language (html)
combo of text and html tags
hypertext
web docs viewed with
browser
internal comms system that uses WWW protocol
intranet
simplest way to add hyperlink in access using data types
hyperlink
saved in html format
published
html page with ability to maintain a live link to a data source
data access page