Using DatabasesUsing Databases

By Lucy BoultBy Lucy Boult

What is a database?What is a database?

A data base is an organised collection of A data base is an organised collection of data usually stored on a computer data usually stored on a computer

We use databases because:We use databases because:

It Is quickIt Is quick Easy to storeEasy to store Easy to find particular dataEasy to find particular data ConvenientConvenient Doesn't get lost Doesn't get lost

What is a query?What is a query?

A query is a collection of data grouped A query is a collection of data grouped together by similarities e.g. hair colour or together by similarities e.g. hair colour or town they live in. town they live in.

We use queries because:We use queries because:

It means We can see similar data more It means We can see similar data more clearlyclearly

It is Quicker than manually looking for dataIt is Quicker than manually looking for data And Useful for surveys e.g. what kind of And Useful for surveys e.g. what kind of

person is a costumerperson is a costumer

What is a report?What is a report?

A report is a collection of data which is A report is a collection of data which is grouped together in categories and grouped together in categories and presented nicely.presented nicely.

We use reports because:We use reports because:

It is a Fancy/neat way of presenting dataIt is a Fancy/neat way of presenting data Has a clear layoutHas a clear layout Easy to useEasy to use And Easy to group any data And Easy to group any data

What is mail merge?What is mail merge?

Mail merge is used to insert personal data Mail merge is used to insert personal data into a general e.g. letter.into a general e.g. letter.

We use mail merge because:We use mail merge because:

it is easyit is easy quickquick Saves someone manually typing it allSaves someone manually typing it all And You can add any data from any file in And You can add any data from any file in

your documentsyour documents