Midterm Flashcards Preview

Access > Midterm > Flashcards

Flashcards in Midterm Deck (47):
1

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

Field

2

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

1. Moving to another record
2. Closing the table/form

3

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

Pencil

4

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

Common field

Acceptable answer:
Primary - Foreign Key

5

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

Primary Key

6

What 4 database objects are created in Module 1?

Tables, queries, forms, and reports

7

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

Form

8

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

Relational Database Management System (RDBMS)

9

The specific content of a field is referred to as the

Field Value

10

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

Common field

11

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

Date/Time

12

A table can be created in which two views

Datasheet and design view

13

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

External Data

14

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

m/dd/yy

15

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

Yes/No

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?

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

17

The default character length for the Short Text data type is

255 characters

18

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

Description

19

What are some examples of comparison operators?

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

20

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

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

small invoice

21

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

Or

22

What is wrong with the following concatenated column?

PatientName FirstName, Lastname

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

23

The sort priority for a query is

Leftmost sort first

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

Maintaining

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?

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

26

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

Z to A

27

Statistical information such as totals and averages are calculated using

Aggregate functions

28

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

Common

29

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

Like

30

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

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

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

Input mask

32

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

Like "*704*"

33

How does the Lookup Wizard hide the column of key values

By setting the column's Width property to 0"

34

Which wildcard symbol represents a single numerical digit

#

35

What is the purpose of a parameter query?

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

36

A criterion may be negated by using the ___ logical operator

Not

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?

999/-000/-0000

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

Like "*" & [Please enter a city] & "*"

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

39

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

Anomalies

40

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

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

41

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

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

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

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

43

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

Repeating Groups

44

What are specific examples of domain integrity constraints?

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

45

List three desirable characteristics of a primary key

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

46

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

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

47

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

Partial dependencies