OCR-Estate Agents

Copy the Database

Starter

Task 1(Pass)

Inserting and Deleting Rows

Task 2(Pass)

Changing Data

Task 3(Pass)

Queries

Task 4(Merit/Distinction)

Complex Queries

ICT Challenge 1

Now create a query of your own. Think of a question a customer may ask then create the query for it. Ensure you print screen your query into work then fully explain it.

ICT Challenge 2

Create a Data Collection form to help input new clients data into the Database

Forms

Task 5(Merit/Distinction)

Reports

Task 6(Distinction)

Address Labels

Task 7 (Distinction)

Sort a query on two fields

ICT Challenge 3

You need to consider how the Estate agents Database could be improved. Consider what things a customer may require in a property that the Database will not tell them. Visit the website below for help, then complete the Database planning form.

http://www.battandbrown.co.uk/

Planning Form

Extension 1

-Add the new fields to your Database

Extension 2

-E-Safety

Click on the links below and read the information about how companies can keep customers personal information secure.

http://ezinearticles.com/?How-To-Keep-Your-Personal-Information-Safe-From-Identity-Thieves&id=283423

http://www.ftc.gov/infosecurity/

In word explain how companies can help protect their customers personal details

Functional Skills

Given Purpose 3 (1.1,1.2i)