Database Development
Collecting, organising and storing data
Methods of Processing and analysing data
Methods of presenting information
Integration
100
What is a database?
Collection of data
100
Can databases save automatically?
Yes
100
What symbol do you use to start a mathematical calculation? Hint: Think formulas
=
100
Are reports interactive?
No they are not interactive
100
Can data be exchanged between databases and spreadsheets?
Yes data can be exchanged between databases and spreadsheets
200
What is a data dictionary?
A description of every field in the database
200
Give an example of a primary and secondary source of data?
Primary: Interviews, Surveys, Census
Secondary: Books, Statistics, Newspaper, Media
200
What is the purpose of macros? Hint: What tasks do they preform?
Preform repeditive tasks
200
What are three presentation features of a report? Hint: Think body parts
Header, Body/Text, Footer
200
Data can be: Hint: E********, E*******, I*******
Exchanged, Exported, Imported
300
What are the components of a database? Hint: There are 4
Queries
Reports
Tables
Forms
300
List three examples information should be: Hint: Characteristics of information
Accurate
Verifiable: photo, pin number
Timely: up to date
Organized
Accessible
Useful
Cost effective
300
What is editing? What actions can you preform on data Hint: Actions include I*****, D*****, M*****
The process of changing data.
Actions preformed on data include, inserting, deleting, moving
300
What can you do in the layout view? Hint: Think editing features
Pick themes
Change fonts
Change colours
Change size
300
What are the three stages of importing a graphic into a database?
Hint: Think importing an image in any program. S***** image, O*** image, L***** image
Select, Open, Locate
400
What are the inputs of a data system? Hint: F***, R*****, F****, C********
File
Record
Field
Character
400
What components are saved when you save your data? Hint: R******, D*****, T*****, R******, F****, D*** D*********
All data including: records, designs, tables, dictionary, reports, forms
400
What is sorting? What are ways of sorting data? Hint: a********, d*********, a***********
Allows you too arrange data
Ways of sorting data are: ascending, descending, alphabetical
400
What are forms? Can you edit and enter data in forms Hint: What information do they present
A way presenting data from an individual record
Yes you can edit and enter data in forms
400
Where can data be exported too? Hint: think excel, think microsoft, think google
Spreadsheet, Word Proccessed Documents, Webpages
500
What are the 5 data types? T*** N***** Y**/N* C******* D***
Text
Number
Yes/No
Currency
Date
500
What is the difference between validation and verification checks of data?
Validation is the checking of errors
Verification is the checking of accuracy
500
What is searching? What are the two commands you can use? Hint: F***, S*****
Is the process of locating data and information
The two commands are find and search
500
What are the three features reports contain? List examples of what is contained in each section.
Header: The header is used to show the title
Body: Contains the information
Footer: Contains the date or report page number
500
Data can be moved in three different ways? List these ways and provide examples. Hint: E********, E*******, I*******
Exchanged between databases and spreadsheets
Exported from databases to word processed documents
Imported from data entry forms
M
e
n
u