Databases - General Flashcards
What is a computed field? Give example syntax
When a field carries out a calculation based in information from other fields in the same record
NewField: [Field1] + [Field2]
What can an Object (OLE) field store in Access?
A word document or a paint graphic
What is the conditional formula? Give example syntax
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”)
What does a navigation form do?
It makes it easy to switch between the various forms and reports in the database
What is a Database Management System (DBMS)?
The computer application we use to work with the database
What are macros? Give an example
A set of instructions that is executed when a function key is pressed or when a screen button is clicked (Find a record)