Midterm

Question 1

A meaningful category of information, such as FirstName or HireDate, is called a

Answer 1

Field

Question 2

Two different actions that cause Access to automatically save changes you’ve made to the current record

Answer 2

1. Moving to another record

2. Closing the table/form

Question 3

On an access datasheet, which symbol indicates a dirty record?

Answer 3

Pencil

Question 4

To connect records from one table to records in another table, you must use this type of field

Answer 4

Common field

Acceptable answer:
Primary - Foreign Key

Question 5

A table’s ___ uniquely identifies each record in the table

Answer 5

Primary Key

Question 6

What 4 database objects are created in Module 1?

Answer 6

Tables, queries, forms, and reports

Question 7

Which Access object is used to view and edit data on the screen in a customized layout?

Answer 7

Form

Question 8

Data organized as a collection of tables created this type of data system?

Answer 8

Relational Database Management System (RDBMS)

Question 9

The specific content of a field is referred to as the

Answer 9

Field Value

Question 10

A field used to connect one table logically with another table is called a

Answer 10

Common field

Question 11

Which data type would be the best logical data type for a field named PaidDate

Answer 11

Date/Time

Question 12

A table can be created in which two views

Answer 12

Datasheet and design view

Question 13

To begin importing data from an Excel Spreadsheet, click on the ___ tab on the ribbon

Answer 13

External Data

Question 14

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

Answer 14

m/dd/yy

Question 15

The ___ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition

Answer 15

Yes/No

Question 16

Before creating a relationship between a primary key in one table and a foreign key in a related table, what two things must be true regarding those fields, so the relationship can be established?

Answer 16

Both fields must be the same data type and the same size

Question 17

The default character length for the Short Text data type is

Answer 17

255 characters

Question 18

The ___ property allows the database designer to explain the purpse of a field or how a field is used

Answer 18

Description

Question 19

What are some examples of comparison operators?

Answer 19

=, <>, , >=, Between…And, In, and Like

Question 20

InvoiceMessage: IIF([InvoiceAmt] >= 100, “large invoice”, “small invoice”

If the value in InvoiceAmt is $99, what will be displayed in the InvoiceMessage field?

Answer 20

small invoice

Question 21

Selection criteria that are placed in different rows in the query design grid indicate an ___operator

Answer 21

Or

Question 22

What is wrong with the following concatenated column?

PatientName FirstName, Lastname

Answer 22

1. There needs to be a colon (:) between PatientName and FirstName
2. There needs to be an ampersands (&) between FirstName and LastName
3. There should be two double quotations and a space between the ampersands.

It should look like this:

PatientName: FirstName & “ “ & Lastname

Question 23

The sort priority for a query is

Answer 23

Leftmost sort first

Question 24

The process of adding, modifying, and delteing records in a database to keep the records current and accurate is referred to as _______ a database

Answer 24

Maintaining

Question 25

For most queries, you can updat the information in their datasheets. What two types of queries don't allow you to update the data within them?

Answer 25

1. A totals query | 2. A query that uses four or more tables

Question 26

A field with the Short Text data type sorted in descending order will display the data in which order

Answer 26

Z to A

Question 27

Statistical information such as totals and averages are calculated using

Answer 27

Aggregate functions

Question 28

Queries based on more than one table, must have a _____ field

Answer 28

Common

Question 29

The ____ comparison operator is used to select records by matching field values specific to a pattern that includes one or more wildcard characters

Answer 29

Like

Question 30

Using a find unmatched query is useful for doing 2 specific things, what are they?

Answer 30

1. Finding records in one table that do not have matching records in a related table 2. Finding the cause of data violation error when trying to create a relationship between two tables/trying to enforce referential integrity

Question 31

An ___ is a predefined format used to define a pattern for data to be entered into a field and control the values a user can enter into a field

Answer 31

Input mask

Question 32

Which of the following pattern match selection criteria would return zip codes with the characters 704 anywhere within the field

Answer 32

Like "*704*"

Question 33

How does the Lookup Wizard hide the column of key values

Answer 33

By setting the column's Width property to 0"

Question 34

Which wildcard symbol represents a single numerical digit

Answer 34

#

Question 35

What is the purpose of a parameter query?

Answer 35

To provide a prompt for users to see and then type in a vlaue that will be used as a criterion value when the query is run

Question 36

A criterion may be negated by using the ___ logical operator

Answer 36

Not

Question 37

Which of the following examples shows an input mask for a telephone number with the first three digits optional and dashes separating the parts of the telephone number?

Answer 37

999/-000/-0000

Question 38

Create a parameter criteria for a City field that prompts a user to "Please enter a city" but will return every record if the user doesn't enter a value

Answer 38

Like "*" & [Please enter a city] & "*" Another acceptable answer (less-preferred): Like [Please enter a city] & "*"

Question 39

Problems caused by data redundancy and by partial and transitive dependencies are called

Answer 39

Anomalies

Question 40

How is a many-to-many table relationship resolved?

Answer 40

1. By creating third table (junction/intersection/ link table) to serve as a bridge between the two many-to-many tables

Question 41

What are the formal names for: 1. Table 2. Record/Row 3. Field/Column

Answer 41

1. Table: Relation 2. Record/Row: tuple 3. Field/Column: Attribute

Question 42

What are the naming conventions for the following Access objects/ controls? 1. Report 2. Image 3. Text Box 4. Combo Box 5. Command Button

Answer 42

1. Report: rpt 2. Image: img 3. Text Box: txt 4. Combo Box: cbo 5. Command Button: cmd (or btn)

Question 43

A table is in first normal form once any ___ have been removed

Answer 43

Repeating Groups

Question 44

What are specific examples of domain integrity constraints?

Answer 44

1. The data type for a field | 2. Utilize validation rules for a field

Question 45

List three desirable characteristics of a primary key

Answer 45

1. Unique 2. Minimal (Doesn't contain any unnecessary extra columns) 3. Static (Must not change in value)

Question 46

List 3 different reasons to create a one-to-one relationship between tables?

Answer 46

1. If the table has a large number of fields (to overcome Access 255 field limit in tables) you can divide it into two tables with a 1-to-1 relationship. 2. For security reasons (to control field access - one department may have permission to view some of the fields and another a seperate set of fields) 3. To avoid space waste created by null field values

Question 47

A table is in Second Normal Form once any ___ have been removed

Answer 47

Partial dependencies