Chapter 9-Using A Relational Database

Front 1

what is a database?

Back 1

an organized collection of related data

Front 2

how does an RDBMS store data?

Back 2

it stores related data in tables

Front 3

what is one benifit of dividing data into tables?

Back 3

it eliminates unnecessary data duplication, or data redundancy

Front 4

What is a database schema?

Back 4

a descrpition of the data and the organization of the data into tables in a relational database

Front 5

explain the considerations for dividing data into related groups.

Back 5

comsiderations for dividing data into related groups includes grouping information so that there is little or no data redundancy. However, each table must have data related to at least one other table,which will require data duplication. This is not considered data redundancy. A table with no relationship to any other table does not belong in the database

Front 6

what is a field?

Back 6

a column in a table. Used to store data

Front 7

explain why a field that stores more than one piece of data is considered poor design

Back 7

a field that stores more than one piece of data limits the sorting and searching capabilities of the database

Front 8

list 4 guidelines to follow when choosing field names

Back 8

1.make field names unique
2.choose the shortest possible name that accurately describes the contents of the field
3.use complete words instead of numbers or abbreviations
4.avoid special characters

Front 9

list nine types of data that can be stored in a field

Back 9

auto number, text number, data/time, currency, memo, yes/no, hyperlink, attachment, and lookup

Front 10

what does the size of a field indicate?

Back 10

the size of a field indicates the number of characters or the type of number it can store

Front 11

what field size is used when a field will store numbers with a decimal portion?

Back 11

single is used to store numbers with a decimal portion

Front 12

what field size is used when a field will store whole numbers?

Back 12

long interger is used to store whole numbers

Front 13

what does the format of a field determine?

Back 13

it determines how the data is displayed

Front 14

list four numeric field formats.

Back 14

general number, fixed, percent, standard

Front 15

list three date/time field formats.

Back 15

long (monday, april 19, 2010), medium (04/19/2010), short (4/19/2010)

Front 16

do text fields have a field format?

Back 16

no

Front 17

for each of the field names below, list the most appropriate data type (text, number, data/time, currency, memo, yes/no, hyperlink, and autonumber). use each data type only once.

Back 17

1.retail price-currency
2.order data-date/time
3.first name-text
4.product description-memo
5.email addresses-hyperlink
6.record ID-auto number
7.delivery time-data/time
8.peanut allergy-yes/no
9.quanity-number

Front 18

what is a record?

Back 18

a set of data for the fields in a table

Front 19

can a table contain duplicate records?explain.

Back 19

no, b/c a table has a field that is designated the priamry key. the primary key field must contain unique values

Front 20

what is used in a table to ensure that records are unique?

Back 20

to ensure that no two records in a table are the same, one field in each table must be designated to the primary key

Front 21

what msut be done to designate a priamry key?

Back 21

click anywhere in the primary key field and then click design --->primary key

Front 22

what is the required option used for?

Back 22

required option is used to ensure that each record has a priamry key entry

Front 23

what is a form?

Back 23

a form is a database object used for entering records into a table and for viewing existing records

Front 24

list three kinds of forms.

Back 24

simple, split, and multiple times

Front 25

why would a logo be added to a form?

Back 25

to give it a proffessional appearance and indicate it is an officail company form

Front 26

list three types of formatting that can be applied to a form.

Back 26

bold, font size, and predefined formats

Front 27

which view must a form be in to add records?

Back 27

its controls are located at the bottom of a form

Front 28

where are the record controls located?

Back 28

at the bottom of a form

Front 29

what are the record controls used for?

Back 29

they are used to display a specific record in a form or for displaying a new, empty record

Front 30

how does a form make entering records less error-prone?

Back 30

a form can make data entry less error-prone b/c only 1 record at a time is displayed

Front 31

what is a datasheet view?

Back 31

it views displays a table in a datasheet where fields are in columns and records in rows

Front 32

list 2 reasons for using datasheet view.

Back 32

it is useful for comparing records and often used when sorting and filtering data

Front 33

list one way to change a columns width.

Back 33

double-click the right column boundary