Report And Big Data And Analytics And Marcos

Question 1

Report

Answer 1

A report allows a table and results from queries to be presented in a user friendly way. The layer of the report can be customised.

Question 2

2 Main ways to organise report results

Answer 2

Grouping
Sorting

Question 3

Grouping

Answer 3

Records can be groped by similar data eg school records , form class

Question 4

Sorting

Answer 4

Records can be sorted ascending and descending order eg number in order , names,alphabetically

Question 5

Marco

Answer 5

Marco is a set of compounds or instructions,recorded together, which when clicked or activated provide a shortcut to a task.

Question 6

Give examples of how marcos could be used in a database

Answer 6

Could be created which allows a user to click a button which then opens and prints a report , with the print setting all saved
Might be used to open a form and automatically takes the user to add a new record

Question 7

Big data

Answer 7

Is a term used to describe extremely large dat sets that traditional data applications cannot deal with, big data sets are often defined in terms of volume, variety and velocity

Question 8

Volume

Answer 8

The amount of data

Question 9

Variety

Answer 9

The number of types of data

Question 10

Velocity

Answer 10

The speed of data processing

Question 11

Data analytics

Answer 11

Applies algorithms to raw data in order to spot patterns relationships and trend.