Databases Flashcards
What is a wizard? [2]
Software that helps a user complete a specific task step-by-step
What is a query facility? [2]
A facility in a database that allows you to search for or select records which meet specified criteria
What is a relationship?
A link between two tables made using common fields
What are the advantages of linking tables in a database? [2]
- Reduces the amount of data stored
2. Makes searching and sorting of data more efficient
What are the four steps that are taken to create a mail merge?
- Create the letter
- Select the data source
- Select the appropriate merge fields
- Merge the data from the data source
What are the three steps that are taken to use the query facility of a database to find particular records?
- Select the table and appropriate fields
- Enter the criteria for the search
- Run the query and view the results
List three wizards available in database software
- Query wizards
- Form wizards
- Report wizards
A key field is also known as a what?
Primary key
Define a key field/primary key.
Uniquely identifies a record in a table.
List four data types in a database.
- Numeric
- Text
- Date
- Boolean
Define a record.
A unit of data made of a number of fields
Which type of database allows a user to set a key field for each table?
A relational database
What is the purpose of an input mask?
To define the format of the data being entered
Give an example of a default input mask
Postcode
List three things that validation ensures.
It ensures that data is:
- Present
- In the correct range
- In the correct format