Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Access > Midterm > Flashcards

Midterm Flashcards

1
Q

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

A

Field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A
  1. Moving to another record

2. Closing the table/form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Pencil

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

Common field

Acceptable answer:
Primary - Foreign Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Primary Key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What 4 database objects are created in Module 1?

A

Tables, queries, forms, and reports

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

Form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

Relational Database Management System (RDBMS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The specific content of a field is referred to as the

A

Field Value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

Common field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

Date/Time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

A table can be created in which two views

A

Datasheet and design view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

External Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

m/dd/yy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

Yes/No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

The default character length for the Short Text data type is

A

255 characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

Description

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What are some examples of comparison operators?

A

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

20
Q

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

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

A

small invoice

21
Q

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

A

Or

22
Q

What is wrong with the following concatenated column?

PatientName FirstName, Lastname

A
  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
Q

The sort priority for a query is

A

Leftmost sort first

24
Q

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

A

Maintaining

25
Q

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?

A
  1. A totals query

2. A query that uses four or more tables

26
Q

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

A

Z to A

27
Q

Statistical information such as totals and averages are calculated using

A

Aggregate functions

28
Q

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

A

Common

29
Q

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

A

Like

30
Q

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

A
  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
Q

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

A

Input mask

32
Q

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

A

Like “704”

33
Q

How does the Lookup Wizard hide the column of key values

A

By setting the column’s Width property to 0”

34
Q

Which wildcard symbol represents a single numerical digit

A

#

35
Q

What is the purpose of a parameter query?

A

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
Q

A criterion may be negated by using the ___ logical operator

A

Not

37
Q

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?

A

999/-000/-0000

38
Q

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

A

Like “” & [Please enter a city] & “”

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

39
Q

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

A

Anomalies

40
Q

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

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

What are the formal names for:

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

What are the naming conventions for the following Access objects/ controls?

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

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

A

Repeating Groups

44
Q

What are specific examples of domain integrity constraints?

A
  1. The data type for a field

2. Utilize validation rules for a field

45
Q

List three desirable characteristics of a primary key

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

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

A
  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
Q

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

A

Partial dependencies

Access (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions