Databases - General Flashcards

1
Q

What is a computed field? Give example syntax

A

When a field carries out a calculation based in information from other fields in the same record

NewField: [Field1] + [Field2]

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

What can an Object (OLE) field store in Access?

A

A word document or a paint graphic

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

What is the conditional formula? Give example syntax

A

It allows you to do one thing if a condition is true, and another if a condition is false

Field1: IIf([Field2] > condition, “Yes”,”No”)

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

What does a navigation form do?

A

It makes it easy to switch between the various forms and reports in the database

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

What is a Database Management System (DBMS)?

A

The computer application we use to work with the database

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

What are macros? Give an example

A

A set of instructions that is executed when a function key is pressed or when a screen button is clicked (Find a record)

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