Test 1

Question 1

Negatives of Excel

Answer 1

-inefficiency with large amounts of data
-not good with different data types
-no clear relationships
-limited tools for combining data
-data redundancy (hard to fix/identify)

Question 2

Database Positives

Answer 2

-Efficiency with large amounts of data
-enforces data types
-designed for relationships
-designed for combining data easily
-reduces redundancy

Question 3

Units of Data

Answer 3

-field
-record
-table
-file

Question 4

Field

Answer 4

-Place for a piece of information
-smallest
-collum (attribute)
-Ex: Customer name

Question 5

Record

Answer 5

-group of fields
-row (entity)
-Ex: Customer info

Question 6

Table

Answer 6

-group of records
-file

Question 7

Relational database

Answer 7

-organized in tables
-Ex: table of customers

Question 8

Primary Key

Answer 8

-field that uniquely identifies each record
-avoid duplicates
-avoid missing data
-Ex: Social Security number

Question 9

Criteria (queries)

Answer 9

-limit the number of records shown

Question 10

Field list (queries)

Answer 10

-what can be seen in query design view

Question 11

entering/editing data (queries)

Answer 11

-same as you would in a table datasheet
-any edits made are permanently stored and updated all other views
-do not edit the results in the data sheet view

Question 12

Criteria in Access

Answer 12

-“like” is automatically added
-quotation marks around text is automatically added
-pound signs for date are automatically added
-number, currency, yes/no fields are not surrounded by any characters

Question 13

Searching for blank fields

Answer 13

-not null
-null

Question 14

Is Null

Answer 14

-finds all records where no entry has been made

Question 15

Is not null

Answer 15

-finds all records where any entry has been made

Question 16

<>

Answer 16

not equal to

Question 17

Between (operation)

Answer 17

between

Question 18

Query wildcards

Answer 18

-can be used to search for a pattern; represents any character
-?/*

Question 19

?

Answer 19

-search for a single character
-(a?)

Question 20

*

Answer 20

-search for any number of characters

Question 21

“Samford*”

Answer 21

-records that start with Samford

Question 22

“*edu”

Answer 22

-find all that end in edu

Question 23

“south”

Answer 23

-find all that contain south

Question 24

And/Or (criteria)

Answer 24

-tests/limiting conditions which restrict retrieval

Question 25

Or (criteria)

Answer 25

-any one criteria must be true

Question 26

And (criteria)

Answer 26

-all criteria must be true

Question 27

And/Or combinations

Answer 27

-need to use multiple rows

Question 28

Double (data type)

Answer 28

-Precise numbers you can take the average of

Question 29

Short text (data type)

Answer 29

-things you cant take the average
-Ex: Name

Question 30

Long integer (data type)

Answer 30

-a very large whole number