Chapter 11

to view a table in design view in the view group

view button & click design view

one purpose of a report is to ?

display fields and records from a table in an easy to read format

to organize your database objects you must use the

navigation pane

the advantage of using a template when starting a new database is that database objects are

already created

one purpose of a form is to simplify

data entry in a table

the characteristic that defines that kind of data you can enter into a field

data type

before populatiing a table, you should create and name the ?, ? the database, and create and name the ?

database > save > table

access view that displays the table data in columns and rows

datasheet view

the access view that displays data in columns and rows like an excel worksheet

datasheet view

to create a query using the simple query wizard, you choose the data source and

field names

not related to any other collection of data

flat database

raw data that has been organized so as to become useful is known as

information

this allows you to make quick changes to a report prior to printing it

layout view

an access record is saved when ?

move to the record

conserving space, reducing errors, and the doesnt have to remember where data is stored are all benefits

of avoiding redundancy in a database

student ID in a college registration database is a good candidate for ?

primary key

the field that uniquely identifies a record in a table

primary key

a database object that retrieves specific data from one or more tables

query

object that retrieves specific data and then displays only the data that you specify

query

each table row contains all the categories of data pertaining to one entity

record

info repeated in a database in a manner that indicates poor design is

redundant

the object that displays fields and records from a table or query in a printable format

report

to rename a table, you can

right-click the table name in the navigation pane

all data is stored in one or more

tables

the most common database objects are

tables, forms, queries, and reports