10 Cue Card Homework

Question 1

What are the formats and conventions in Reports

Answer 1

3 Tier Heading
Fields
Correct Buttons (should all be the same size, reasonable and in chronological order

Question 2

What are the formats and conventions in Forms

Answer 2

3 Tier Heading
Correct fields i.e correctly spaced
Correct Buttons
Links to and from main menu
Colors need to be readable 
Data needs to be sorted

Question 3

What are general formats and convention in Databases?

Answer 3

2 Decimal places
Right aligned numbers
Left aligned text
(name conventions such as tblEmployeeWages)

Question 4

What are some design tools for Databases?

Answer 4

Mockups - Forms, Queries and Reports

Data Dictionary - Table

Question 5

What are some design tools used for Webpages/Dreamweaver?

Answer 5

Site Map
Story Board
Layout Design

Question 6

Why do we protect sections of sheets in a spreadsheet?

Answer 6

To protect an entire sheet from changes or accidental deletion of parts.

Question 7

What is meant by convention?

Answer 7

Convention is a way of doing something that is widely accepted and everyone is used to doing it so becomes a rule. It isn’t classed to be illegal but foreign to try something different as it easier to follow the conventional ways.

Question 8

What is an IF statement?

Answer 8

To identify if a condition is true or false. E.g = if(A1>25, “larger”,”smaller”)

Question 9

What is relative addressing?

Answer 9

When we copy or adjust data from one cell to another For example, sum(e1:e2)

Question 10

What is the purpose of a Macro?

Answer 10

For various programs Steps to be easily repeated