Ist

Question 1

When collecting data you must remember to make sure you have

Answer 1

Current and accurate data

Peoples privacy protected

Question 2

List some common data sources:

Answer 2

Transactions at atm/eftpos terminals
Application forms
Questionnaires

Question 3

What is a example of a primary source of data

Answer 3

Information collected directly from people

Question 4

What is a example of a secondary source of data

Answer 4

Sus Information collected from newspapers or research documents

Question 5

Why would people use secondary sources to collect data

Answer 5

Because it is a quicker and more convenient method

Question 6

Why should sources be documented?

Answer 6

To check the data
Allow it to be easy to find
Copyright issues must be respected

Question 7

Automated Data collection devices

Answer 7

Bar Codes
E-tags
Smart Cards
Magnetic stripe cards

Question 8

What have automated data collection devices enabled us to do

Answer 8

made data input fast

time is saved and errors are reduced

Question 9

What do automated input devices allow us to do

Answer 9

Reduces the chance of input errors going into systems

Question 10

What does a validation do

Answer 10

checks if the data is sensible or reasonable

Question 11

Give an example of a validation

Answer 11

E.g. If DOB for students were being entered a school, we could assume dates before 1980 are not valid.

Question 12

Where can you set a validation on MS Access

Answer 12

set in design view, and in the data dictionary

Question 13

What occurs during a verification process

Answer 13

A check to verify that the data is true.

Question 14

What does the system do during the verification process

Answer 14

It compares the data entered with the one in its database.

Question 15

Things to consider when organising your data

Answer 15

Which data goes into which table or field

How the tables will be linked

This must be decided at the design stages

Question 16

What are tables used for

Answer 16

separating data and reorganising it into specific groups

Question 17

What is a redundancy

Answer 17

The Repetition of data in a database

Question 18

How can a redundancy be caused

Answer 18

Adding new information causes a manual update to the database which can lead to a redundancy

Question 19

How to lower redundancys

Answer 19

Table relationships

Question 20

What is a relationship

Answer 20

A relationship is a when there is a link between two key fields in a two tables

Question 21

What are key fields used for

Answer 21

Key fields are used to link data between tables

Question 22

What is a key

Answer 22

A unique value in each record

Question 23

What is a primary key

Answer 23

What the data is identified as

Question 24

What are relational databases

Answer 24

Databases that are designed with links between separate tables

Question 25

What is a foreign key

Answer 25

the Primary key from one table appearing in another table for linking purposes

Question 26

List advantages of computerised databases

Answer 26

Storage Space More compact than piles of data sheets

Question 27

Advantages of storing databases on networks

Answer 27

Backups can be made every few minutes or hours Database can be accessed by many people from different workstations or countries.

Question 28

How do you protect your network from unauthorised people

Answer 28

Firewalls

Question 29

List some common storage devices

Answer 29

``` USB Drives Hard Drives Network Systems Thumb Drives Floppy Disk ```

Question 30

Once the data is entered into the database what can be done to the data

Answer 30

It can be Changed, Updated and Edited

Question 31

List ways your database can be soughted

Answer 31

Alphabetical order Number order Date/time Title name

Question 32

What does sorting data do

Answer 32

Makes it more convenient for the user

Question 33

Where can sorting be done

Answer 33

On The original table On The results of a search

Question 34

The way we see data displayed is not the same in memory or secondary storage True/False

Answer 34

True

Question 35

What is a query

Answer 35

A Search for data that meets certain criteria

Question 36

What can queries be used for

Answer 36

to run complex search criteria and can be stored for repeated use

Question 37

Give an example of mathematical calculations used on data

Answer 37

set up a calculated field to show the current age of the student by calculating the difference between the DOB and the current date

Question 38

What is a macro

Answer 38

a series of tasks that are grouped together

Question 39

What can you do with macros

Answer 39

automate a task or a series of task in a click of a button

Question 40

When do macros become useful

Answer 40

when tasks need to be constantly repeated | E.g. if you wanted to open a message before opening another form

Question 41

Things to remember about presenting information

Answer 41

The database should be as user friendly as possible

Question 42

What is a report

Answer 42

A way of presenting data as printed document

Question 43

Reports will usually

Answer 43

Contain a large volume of data Data may be generated from a table or the results from a queries from several tables

Question 44

Things in the design element

Answer 44

``` Text Pictures Lines Boxes Labels Grouping of Data Header Footer ```

Question 45

What does the design element do

Answer 45

enhances the appearance and improves communication of information

Question 46

What things are located in the header

Answer 46

Report name | Company logo

Question 47

What things are located in the footer

Answer 47

Page number | Date

Question 48

What are forms used for

Answer 48

viewing and /or editing one record at a time on the screen

Question 49

In order for something to be user friendly it needs to be

Answer 49

Simple Have labels Have clear instructions and directions

Question 50

What are some examples of media files

Answer 50

Graphics Sound Video clips

Question 51

Why is it better to establish a link between a database and a media file rather than just importing them by itself

Answer 51

Keeps the database files small but restricts portability of the application.

Question 52

What does delimited text mean

Answer 52

a text file contains words or fields that are separated by the ‘tab’ key press or by a comma, while records may be separated but the ‘Enter’ key press.

Question 53

What does expressing your data as a spreadsheet or in presentation software allow you to do

Answer 53

It allows data to be presented as charts and web pages

Question 54

What is a database

Answer 54

A organised collection of related data

Question 55

What is a data dictionary

Answer 55

A table that shows field names field size and validation rules for each file

Question 56

What is a field

Answer 56

A cell in a table that holds a singular piece of data

Question 57

What is a file

Answer 57

An alternative name for a field

Question 58

What is a flat file database

Answer 58

A stand alone table of data

Question 59

What does a form do

Answer 59

To display one record at a time

Question 60

What does a key field do

Answer 60

It holds the primary or foreign key

Question 61

What does the intranet allow you to do

Answer 61

To have private network for access by specific people

Question 62

What does the internet allow you to do

Answer 62

Search up and share information

Question 63

How does your computer link up to the internet

Answer 63

By communicating with each other using TCP/IP

Question 64

What does TCP/IP stand for

Answer 64

Transmission control protocol

Question 65

Ways if getting access to the internet

Answer 65

Direct connection Dial up connection Broadband connection

Question 66

How does direct connection work

Answer 66

Is a connection to the LAN

Question 67

What does LAN stand for

Answer 67

Local Area Network

Question 68

How does dial up connection work

Answer 68

Through the use of a modem and telephone line to connect to the internet

Question 69

What do you need to use the internet

Answer 69

A ISP

Question 70

What is a ISP

Answer 70

Internet service provider

Question 71

What does an ISP give to the user

Answer 71

Internet access for a small fee

Question 72

What where the dates of the main advances of the internet

Answer 72

``` 1969 1974 1979 1981 1982 1984 1986 1991 1993 ```

Question 73

What happened in 1969

Answer 73

Arpanet was created which was a intranet

Question 74

What does APARNET stand for

Answer 74

Advanced Research project Agency Network

Question 75

What happen in 1974

Answer 75

Telenet a commercial aparnet was invented

Question 76

What happened in 1979

Answer 76

Usenet was invented for news related things

Question 77

What happened in 1981

Answer 77

Bit net was invented which allowed for email services

Question 78

What happened in 1982

Answer 78

Arpanet adopted the tcp/ip standard

Question 79

What happen in 1984

Answer 79

The domain naming system was invented

Question 80

What happen in 1986

Answer 80

The national science foundation became the backbone of americas internet service

Question 81

What happen in 1991

Answer 81

The world wide wed was implemented with the help of http

Question 82

What does http stand for

Answer 82

Hyper text transfer protocol

Question 83

What happened in 1993

Answer 83

The world wide web managed to graphically display hypertext documents