1. Import: csv (comma separated value file) (known as standardised format for all computers, can be read by all computers) (when opening in an exam, save as excel workbook)
2. Absolute and relative references (Absolute means it will absolutely always refer to that cell) (relative means it change if a formula is copied and pasted dependant on where it has been pasted) (use '$' sign to make a reference absolute)
3. Named cells, named ranges (A named cell is an automatic absolute reference) (Named ranges is naming a cell) (This makes reading formulae easier)
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup
5. Perform searches using AND, OR, NOT, LIKE (cuts down searches like search engine "Google")
6. Perform search using wildcard (wildcard is a *) (It broadens searches)

Why woul u back up?

A file backup is a copy of a file that is stored in a separate location from the original. You can have multiple backups of a file if you want to track changes to the file. Backing up your files helps to protect them from being permanently lost or changed in the event of accidental deletion, a worm or virus attack, or a software or hardware failure. If any of those things occur and your files are backed up, you can easily restore those files. 

Questions and answers for storage devices

Backing storage : 
Name two items which are storage media.
Flash memory card      Graph plotter       Magnetic disc       OCR          OMR            Touch pad

Explain why the following are used with PCs.

Pen drives- To transfer smaller files

Blu-ray- For storage of up to 50gb and can hold HD movies

Fixed hard disc drives- Used in computers to store the permanent files

Ring two items which are output devices.

Blu-ray disc

Optical mark reader

Graph plotter

Projector

Web cam

Graphics tablet

Complete the following sentences using the most suitable storage device or medium listed

below.

(a)memory stick

(b)fixed hard disk drive

(c)DVD R

A student taking his coursework home to develop would use a  memory stick

A company selling copies of games would use a DVD R

An office worker who never took her work home would store her work on a fixed hard disk drive

Acess

Acess makeing a query into a report:

Starting query:

 Open Report Wizard and transferre all the fields that you need/want:

 Fields Transferred:

 Field grouping levels (which fields have priority):

Placeing in ascending order (nothing needs to be changed):

Change to landscape (nothing else needs to be changed):

Name the report if you need to otherwise leave it alone:

 

Finished report:



Makeing a Query (search)
Query 1 finished(like a search)

Starting info list

				Show/hide parts	of q

DATA BASES