Exam 8: Data Validation and Data Analysis: Hands On Exercise Videos

data type that enables you to quickly link to any file on your computer or any Web page on the Internet

is used it to attach multiple files of any format and then launch those files from within Access

enables you to copy external data into your database without linking it to your source file

uses a comma to separate one column from another, enabling the receiving software to distinguish one set of field values from the next

allocates a certain number of characters for each field

has a new group tab

to access the Switch Windows button in the Window group

contain the Publish button

to customize the Ribbon

contain the Page Color button in the Page Background group

Variance of a population including logical values and text

Descriptive statistic function in Excel that determines the frequency distribution of a dataset.

Standard deviation of a sample

Helps determine the strength of a relationship between two variables

Variance of a sample including logical values and text

converts all objects on a slide to a single layer

flexible file format used for storing and exchanging structured information

secure format by Adobe that preserves document formatting

format created by Microsoft that preserves document formatting

standard file format accessible across platforms

helpful when distributing to others without PowerPoint

uses lossless compression and provides print-quality images

makes records and documents accessible across platforms and applications

outputs presentation as a video clip file

uses lossy format and creates smaller file sizes

comments and annotations that display in a document

markings on a slide

examines a presentation

text notes attached to a file

comments in PowerPoint