Database Applications

Question 1

a table

Answer 1

consists of a number of records

Question 2

a field

Answer 2

part of a record that stores a single data item, represented by a column.

Question 3

a key field

Answer 3

uniquely identifies one record

Question 4

a query

Answer 4

searches and filter data in a database that satisfies the query criteria

Question 5

forms

Answer 5

used to collect data to create a new record, modify an existing record or view records already stored in a table.

Question 6

reports

Answer 6

used to present results from queries in an effective matter. the layout can be customised, such as grouping similar data or presenting data in ascending or descending order.

Question 7

macros

Answer 7

small programs that are written to perform a repetitive database task automatically. They can be used to add functionality to forms and reports

Question 8

database relationships

Answer 8

link two or more tables in a database using a relationship type. These are one-to-one, one-to-many or many-to-many.

Question 9

data type

Answer 9

defines the type of data associated with the field

Question 10

A database

Answer 10

A structured, organised collection of data that is normally organised into tables of rows and columns.

Question 11

Flat file database

Answer 11

Only contains one table where data is repeated. Disadvantages- redundancy; when data is repeated unnecessarily. Integrity; data is less likely to be correct because is has been repeated unnecessarily.

Question 12

Text

Answer 12

Text and data that is a mixture of text and numbers

Question 13

Number

Answer 13

Numeric data that requires a mathematical calculation

Question 14

Date/time

Answer 14

Dates and times

Question 15

Currency

Answer 15

Monetary data; includes two decimal places

Question 16

Auto number

Answer 16

To create a key field, the computer generated sequential numbers that are automatically inserted for each new record created

Question 17

Yes/no (Boolean)

Answer 17

Data that has two possible values

Question 18

OLE object

Answer 18

Object linking and and embedding; objects created using a software package other than a database

Question 19

Hyperlink

Answer 19

A link to web address (URL)

Question 20

Attachment

Answer 20

A file attached to a record

Question 21

Calculated

Answer 21

The result of a calculation produced from another field in the record

Question 22

Lookup wizard

Answer 22

A value can be selected from a predefined list and entered into the field

Question 23

Data validation

Answer 23

Involves automatic checking of data at the input stage to ensure it is reasonable, sensible and within acceptable limits. It guarantees that data is present, and of the correct type, range or length

Question 24

What are the data validation types

Answer 24

Presence check, length check, type check, format check and range check

Question 25

Presence check

Answer 25

Ensures the data is present; the field cannot be left blank

Question 26

Length check

Answer 26

Ensures data is the correct number of characters

Question 27

Type check

Answer 27

Ensures data is of the correct type

Question 28

Format check

Answer 28

Ensures data matches a predetermined pattern

Question 29

Range check

Answer 29

Ensures data is within a lower and upper limit

Question 30

Logical operators

Answer 30

Denoted by the words AND,OR and BETWEEN

Question 31

Big data

Answer 31

Can be described as the 3vs; volume, variety and velocity

Question 32

Volume

Answer 32

Refers to the amount of data stored by organisations. Organisations now store large amounts of data from different sources; requiring large storage capacity hardware.

Question 33

Variety

Answer 33

Refers to the different types and varieties of data. Data is now stored in many formats. Data can be structured, semi-structured or unstructured.

Question 34

Velocity

Answer 34

Refers to the speed at which data can be processed. Due to large volumes of data, there us a need to use more powerful computers to process the data more quickly

Question 35

Data analytics

Answer 35

Involves analysing large volumes of data to produce useful information. This is beneficial for making decisions and planning for future growth.

Question 36

Input mask

Answer 36

Defines the format of the data being entered.

Question 37

Advantages of linking tables in a database

Answer 37

Reduces Redundancy or repeated information; Increases Integrity

Question 38

What would you use to display information on a database

Answer 38

A report