# Access Chapter 3

### 41 terms by Kenny_Sayre

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

Access Chapter 3 ITE 115

### Which of the following statements is true in reference to calculated fields

Calculated fields can be used as input for other calculated fields

### The PMT function is best suited to determine

The monthly payment on a car loan.

DateDiff

### Consider the table pictured above. The value of 150 in the totals Rows represents the total hours worked. How was this value calculated in theTotals Row?

The value is a result of the Sums Function being applied to the hours worked field

6+5

### You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. which of the following statements is true regarding the automatic naming of the calculated field.

Access assigns Expr1 to a calculated field without a name, and this name can be edited.

### All of the following are valid statements in reference to the iif function except:

iif functions work only with numeric values and not with text

Date

...

***aggregate****

DatePart

Num_periods

### Consider the table pictured above. The value of \$17.50 in the totals rows respresent the mean hourly wage. How was this value calculated in the totals row

This value is a result of the average function being applied to the Hourlywage Field.

### The built-in iif function evaluates a condition and displays ____.

one value when the condition is true and another value when the condition is false.

Colon

Date

Argument

### Consider the table pictured above. The value 4 in the totals row represents the number of employees listed in this table. How was this value calculated in the totals row?

This value is a result of the count function being applied to the lastname field

interval, date

Min

loan payment

Aggregate

### Access contains ____ that perform routine calculations

Built in fnctions

### Syntax can most accuratley be defined as the ____.

Set of language rules that access follows when evaluating expressions.

Setup group

0

### When designing a calculated field, complex formulas can be created with the ____.

Expression Builder

Macros

### All of the following are true in reference to Expression Builder EXCEPT:

Expression Builder can only be used with functions designed by the user and not with built-in functions.

### Consider the table pictured above. GrossPay is a calculated field. Which of the following expressions was used to calculate the data for the field?

[HoursWorked]*[HourlyWage]

Minimum

### Constants that are used as arguments in expressions can be defined as ____.

Values that do not change.

### All of the following are true in reference to built-in functions EXCEPT:

Built-in functions can only perform calculations on numberic data.

Avg

...

placeholders

### Which of the following statements is true about date formatting?

Date formatting changes the way a date is displayed without changing the value of the date.

### All of the following statements are true regarding functions arguments EXCEPT:

An argument can be the value of a label

### Which of the following statements offers the best method for ensuring that a database is recoverable in case of corruption?

Make a copy of the database before attempting to make changes to the database.

Example: