Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

morning > Ist > Flashcards

Ist Flashcards

1
Q

When collecting data you must remember to make sure you have

A

Current and accurate data

Peoples privacy protected

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

List some common data sources:

A

Transactions at atm/eftpos terminals
Application forms
Questionnaires

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

What is a example of a primary source of data

A

Information collected directly from people

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

What is a example of a secondary source of data

A

Sus Information collected from newspapers or research documents

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

Why would people use secondary sources to collect data

A

Because it is a quicker and more convenient method

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

Why should sources be documented?

A

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

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

Automated Data collection devices

A

Bar Codes
E-tags
Smart Cards
Magnetic stripe cards

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

What have automated data collection devices enabled us to do

A

made data input fast

time is saved and errors are reduced

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

What do automated input devices allow us to do

A

Reduces the chance of input errors going into systems

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

What does a validation do

A

checks if the data is sensible or reasonable

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

Give an example of a validation

A

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

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

Where can you set a validation on MS Access

A

set in design view, and in the data dictionary

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

What occurs during a verification process

A

A check to verify that the data is true.

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

What does the system do during the verification process

A

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

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

Things to consider when organising your data

A

Which data goes into which table or field

How the tables will be linked

This must be decided at the design stages

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

What are tables used for

A

separating data and reorganising it into specific groups

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

What is a redundancy

A

The Repetition of data in a database

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

How can a redundancy be caused

A

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

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

How to lower redundancys

A

Table relationships

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

What is a relationship

A

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

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

What are key fields used for

A

Key fields are used to link data between tables

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

What is a key

A

A unique value in each record

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

What is a primary key

A

What the data is identified as

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

What are relational databases

A

Databases that are designed with links between separate tables

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

What is a foreign key

A

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

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

List advantages of computerised databases

A

Storage Space

More compact than piles of data sheets

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

Advantages of storing databases on networks

A

Backups can be made every few minutes or hours

Database can be accessed by many people from different workstations or countries.

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

How do you protect your network from unauthorised people

A

Firewalls

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

List some common storage devices

A 
USB Drives
Hard Drives
Network Systems
Thumb Drives
Floppy Disk
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

It can be Changed, Updated and Edited

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

List ways your database can be soughted

A

Alphabetical order
Number order
Date/time
Title name

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

What does sorting data do

A

Makes it more convenient for the user

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

Where can sorting be done

A

On The original table

On The results of a search

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

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

A

True

35
Q

What is a query

A

A Search for data that meets certain criteria

36
Q

What can queries be used for

A

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

37
Q

Give an example of mathematical calculations used on data

A

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

38
Q

What is a macro

A

a series of tasks that are grouped together

39
Q

What can you do with macros

A

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

40
Q

When do macros become useful

A

when tasks need to be constantly repeated

E.g. if you wanted to open a message before opening another form

41
Q

Things to remember about presenting information

A

The database should be as user friendly as possible

42
Q

What is a report

A

A way of presenting data as printed document

43
Q

Reports will usually

A

Contain a large volume of data

Data may be generated from a table or the results from a queries from several tables

44
Q

Things in the design element

A 
Text
Pictures
Lines
Boxes
Labels
Grouping of Data
Header
Footer
45
Q

What does the design element do

A

enhances the appearance and improves communication of information

46
Q

What things are located in the header

A

Report name

Company logo

47
Q

What things are located in the footer

A

Page number

Date

48
Q

What are forms used for

A

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

49
Q

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

A

Simple
Have labels
Have clear instructions and directions

50
Q

What are some examples of media files

A

Graphics
Sound
Video clips

51
Q

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

A

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

52
Q

What does delimited text mean

A

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.

53
Q

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

A

It allows data to be presented as charts and web pages

54
Q

What is a database

A

A organised collection of related data

55
Q

What is a data dictionary

A

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

56
Q

What is a field

A

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

57
Q

What is a file

A

An alternative name for a field

58
Q

What is a flat file database

A

A stand alone table of data

59
Q

What does a form do

A

To display one record at a time

60
Q

What does a key field do

A

It holds the primary or foreign key

61
Q

What does the intranet allow you to do

A

To have private network for access by specific people

62
Q

What does the internet allow you to do

A

Search up and share information

63
Q

How does your computer link up to the internet

A

By communicating with each other using TCP/IP

64
Q

What does TCP/IP stand for

A

Transmission control protocol

65
Q

Ways if getting access to the internet

A

Direct connection
Dial up connection
Broadband connection

66
Q

How does direct connection work

A

Is a connection to the LAN

67
Q

What does LAN stand for

A

Local Area Network

68
Q

How does dial up connection work

A

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

69
Q

What do you need to use the internet

A

A ISP

70
Q

What is a ISP

A

Internet service provider

71
Q

What does an ISP give to the user

A

Internet access for a small fee

72
Q

What where the dates of the main advances of the internet

A 
1969
1974
1979
1981
1982
1984
1986
1991
1993
73
Q

What happened in 1969

A

Arpanet was created which was a intranet

74
Q

What does APARNET stand for

A

Advanced Research project Agency Network

75
Q

What happen in 1974

A

Telenet a commercial aparnet was invented

76
Q

What happened in 1979

A

Usenet was invented for news related things

77
Q

What happened in 1981

A

Bit net was invented which allowed for email services

78
Q

What happened in 1982

A

Arpanet adopted the tcp/ip standard

79
Q

What happen in 1984

A

The domain naming system was invented

80
Q

What happen in 1986

A

The national science foundation became the backbone of americas internet service

81
Q

What happen in 1991

A

The world wide wed was implemented with the help of http

82
Q

What does http stand for

A

Hyper text transfer protocol

83
Q

What happened in 1993

A

The world wide web managed to graphically display hypertext documents

morning (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions