computer science excel and access

Describe four ways of viewing the context on and Excel workbook

1. Normal view shows the columns and rows of the worksheet. 2. Page layout view shows the layout of the worksheet as it appears on a page. 3. Page Break Preview shows the page breaks within the worksheet. 4. Formula views shows formulas rather than the value returned by the formulas.

query

A _______ is a question you ask about the data stored in a database.

explain how the saving process in Access is different from saving in other Office programs?

Access saves changes to the active database to disk automatically when a record is charged or added or when you close the database. You can use the save button in Access only to save changes to the design of an object, such as a table, or to the format of a datasheet but not to save the database file.

adjacent ranges contain a rectangular block of cells; nonadjacent ranges contain a collection of adjacent ranges

Describe the two types of ranges in excel

icon

In the navigation pane, each database object as a unique _________ to its left that identifies the objects type

Backing up

___________ a database is the process of making a copy of the database file to protect the database against loss or damage

compacting

___________ a database rearranges the data and objects in a database to decrease its file size.

condition

a criterion, or rule, that determines which records are selected for a query datasheet

what is an aggregate function?

a function that performs an arithmetic opp on selects records in a database

how are a table datasheet and a query datasheet different?

a table datasheet shows the permanent data in the table and a query datasheet is temporary

how are page breaks indicated in Page break preview?

as dotted lines

how do you rename a worksheet??

double click the sheet tab, and then type a new name on the sheet tab

true or false: when you define multiple sort fields in design view, the sort fields must be adjacent to each other

false

true or false: you can copy records from any Access database table and paste them in another table.

false; the tables must have the same structure. they must contain the same fields with the same characteristics in the same order

In datasheet view, what is the difference between navigation mode and editing mode?

in Navigation mode, the entire field value is selected, and anything you type replaces the field value. in editing mode, you can insert/delete characters in a field value based on the location of the insertion point

in the design grid, where do you place the conditions for 2 different fields when you use the and logical operator? the Or logical operator?

in the same criteria row; in different criteria rows

select query

is a general query in which you specify the fields records you want access to select

filter

is a set of restrictions you place on the records in an open datasheet or form to isolate a subset of records temporarily.

field

is a single characteristic of a person, place, object, event, or idea

navigation pane

is the area of the Access window that lists all the objects in a database, and it is the main control center for opening and working with database objects

for a date/time field, how do the records appear when sorted in ascending order?

oldest to most recent

how do you display the formulas used in a worksheet?

press the ctrl+keys (grave accent key located above the tab button) to switch to formula view

primary key, foreign key

the _________ whose values uniquely identify each record in a table, is called a ________ when it is placed in a second table to form a relationship between the 2 tables

group by

the ___________ operator divides selected records into groups based on the values in a field

describe the field list and the design grid in the query window in design view.

the field list contains the table name and the top of the list and the tables fields listed in the order in which they appear in the table. the design grid displays columns that contain specifications about a field you'll use in query

what does a star symbol at the beginning of a record represent?

the next row available for a new record

form tool

the quickest way to create a form is to use the _______

what does a pencil symbol at the beginning of a record represent?

the record being edited

how are a table datasheet and a query datasheet similar?

they look the same appearing in datasheet view and can be used to update data in a database.

why would you scale a worksheet?

to force a worksheet to print on one page

expression

to perform a calculation in a query, you define a _________ containing a combination of database fields, constants, and operators

print preview

to see the total number of pages in report and navigate through the report pages, you need to display the report in __________

=B4+B5+B6

what formula would you enter to ass the values in cells B4, B5, B6?

=SUM (B4:B6)

what function would you enter to achieve the same result?

object type

what is the default category for the display of objects in the navigation pane?

A3:G5

what is the range reference for cells A3 through G5

J3:M5

what is the range reference for cells J3 through M5

expression builder

which access tool do you use to create an expression for a calculated field in a query?

ID field

which field does Access create, by default, as the primary key field for a new table in Datasheet view?

Add and delete

which group on the fields tab contains the options you use to ass new fields to a table?

common field

you connect the records in 2 separate tables through a ________ that appears in both tables