Databases Flashcards

1
Q

What is a wizard? [2]

A

Software that helps a user complete a specific task step-by-step

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

What is a query facility? [2]

A

A facility in a database that allows you to search for or select records which meet specified criteria

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

What is a relationship?

A

A link between two tables made using common fields

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

What are the advantages of linking tables in a database? [2]

A
  1. Reduces the amount of data stored

2. Makes searching and sorting of data more efficient

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

What are the four steps that are taken to create a mail merge?

A
  1. Create the letter
  2. Select the data source
  3. Select the appropriate merge fields
  4. Merge the data from the data source
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What are the three steps that are taken to use the query facility of a database to find particular records?

A
  1. Select the table and appropriate fields
  2. Enter the criteria for the search
  3. Run the query and view the results
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

List three wizards available in database software

A
  1. Query wizards
  2. Form wizards
  3. Report wizards
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

A key field is also known as a what?

A

Primary key

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

Define a key field/primary key.

A

Uniquely identifies a record in a table.

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

List four data types in a database.

A
  1. Numeric
  2. Text
  3. Date
  4. Boolean
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Define a record.

A

A unit of data made of a number of fields

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

Which type of database allows a user to set a key field for each table?

A

A relational database

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

What is the purpose of an input mask?

A

To define the format of the data being entered

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

Give an example of a default input mask

A

Postcode

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

List three things that validation ensures.

A

It ensures that data is:

  1. Present
  2. In the correct range
  3. In the correct format
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

If data entered does not meet validation criteria, what happens?

A

An error message appears

18
Q

List five data validation checks.

A
  1. Presence
  2. Length
  3. Type
  4. Range
  5. Format
19
Q

List three types of relationship in a database.

A
  1. One-to-one
  2. One-to-many
  3. Many-to-many
20
Q

What is a mail merge?

A

The merging of records from a database onto standard documents.

21
Q

The results of a query are shown in…

A

table format

22
Q

Logical operators can be used to…

A

combine criteria in a query

23
Q

List three logical operators.

A
  1. AND
  2. OR
  3. NOT
24
Q

What can reports be created from? [2]

A
  1. Data in tables

2. Results of a query

25
Q

Reports are designed for…

A

printing

26
Q

Data in reports can be both…

A

grouped and sorted

27
Q

Reports should produce information that is…

A

accurate and complete

28
Q

Reports should be user…, to…

A

friendly, to make sure that the user can make good use of the information

29
Q

User friendly means that it is…

A

easy for users to understand and use

30
Q

Name two sources from which data can be imported into a database.

A
  1. Spreadsheet

2. Comma-separated variable (CSV) file

31
Q

Importing data into a database is usually done using a…

A

wizard

32
Q

List three ways you should a plan a database.

Requirements, tasks, data

A
  1. List user requirements in terms of input, processing and output. This will include any reports, queries and forms to be used in the system.
  2. Identify tasks the user will need to perform (e.g. Adding, deleting and updating records).
  3. Identify the data which needs to be collected.
33
Q

List three ways you should test a database solution.

Data capture forms, queries, reports

A
  1. Test data capture forms to ensure their data is valid and they are user friendly
  2. Run queries to ensure the criteria produce the correct results and that searches are efficient
  3. Ensure reports display the correct information in a suitable format
33
Q

List three ways a database solution should be evaluated.

A
  1. Assess fitness for purpose (e.g. How well it meets user requirements)
  2. Identify strengths and weaknesses (e.g. User friendliness of data capture forms and reports)
  3. Identify areas for improvement