Module 5 practice tests

							                            European Computer Driving Licence

                                          Module 5 Sample Test 2

                                               (syllabus version 4)


          You are managing a database of customer accounts for a car dealership. In the
          test you will work with the Autos database and will add and edit data in the
          database and create forms. You will then use queries and reports to extract
          information from the database. Remember that all your work should be
          saved on the candidate disk.




Tasks
1. Open the M5answerfile on your Candidate Disk and answer Questions 1,2,3 and 4. Save          (4
and close the Answer file.                                                                    Marks)
2. Open the Autos database from your Candidate Disk. Open the Sales Reps table and add
the following fields after the Sales Rep Name field:
Field Name              Data Type           Field Size or Format                                (2
                                                                                              Marks)
Telephone Number        Text                10
Date Started            Date

3. Using your knowledge of databases, select the most appropriate field for the primary key    (1
and create a primary key for the table. Save the Sales Rep table with your changes.           Mark)
4. Add the following data to the correct records in the Sales Rep table.
Sales Rep ID            Telephone Number Date Started
3                       04638590            12/01/1999                                         (1
5                       03264784            23/11/1996                                        Mark)


Close the table.
5. Open the Car Sales table. Find the record for the BMW Z3 and change the purchase price      (1
to £14,999                                                                                    Mark)

6. The customer has decided not to buy the car. Delete the record for Nissan Micra.            (1
                                                                                              Mark)
7. In the Car Sales table modify the Purchase Price field so it has no decimal places. Save    (1
and close the table.                                                                          Mark)
8. Again in the Car Sales table, create an index on Make and Model. Allow for duplicate        (1
names in the index.                                                                           Mark)

9. Again in the Car Sales table, delete the Part Exchange field. Save and close the table.     (1
                                                                                              Mark)
                                                                                               (1
10. Open the Car Sales table and sort the table by the Purchase Price field in descending
                                                                                              Mark)
order.

11. Delete the Accounts table.                                                                  (1
                                                                                               Mark)
12. Customers may buy more than one car. Use the Customer Number field in the
Customers and the Car Sales tables to build a one-to-many relationship between the              (1
Customers and Car Sales tables.                                                                Mark)

                                                                                                (1
13. Apply referential integrity to the relationship.
                                                                                               Mark)
14. Create a simple form using all the fields from the Car Sales table. Save the form as Car    (1
Sales Input Form                                                                               Mark)
15. Use the form you have just created to add the following record:
Sale         Date of    Customer      Sales                      Reg         Purchase           (1
                                             Type Make and Model        Year
Reference    sale       Number        Rep ID                     Number      Price             Mark)
03/130       3/9/2003 40              5                Jaguar XK                  12999

16. Use the Customers and Car Sales tables to create a query that will show the Customer
Number, Initials and Last Name of all Customers who have bought a Hatch car. Save the            (2
query as Hatch                                                                                 Marks)

17. Using both tables again, create another query using all the fields from the Customers
table to display those customers who have bought a car with a Purchase Price greater than        (2
£10,000.00. Save the query as More than 10,000                                                 Marks)

18. Open the Sales Rep Grade query and edit it so that only sales reps on Grade 2 will be       (1
displayed. Save the query.                                                                     Mark)

19. Print one copy of the result of the Sales Rep Grade query.                                  (1
                                                                                               Mark)

20. Delete the Query 1 query and the Reps List report.                                          (1
                                                                                               Mark)
21. Create a report using all the fields from the Customers table. Save the report as           (1
Customer Report.                                                                               Mark)
22. Create a report using all the fields from the Car Sales table grouped by the Sales Rep ID   (2
field and showing the total sales for each Rep. Save the report as Grouped Car Sales.         Marks)

23. Open the Grouped Car Sales report and modify the header to read Car Sales by Rep.           (1
                                                                                               Mark)

24. Change the margins of the Grouped Car Sales report to 2 cms all round.                      (1
                                                                                               Mark)
25. Move the date field from the footer of the Grouped Car Sales report so it prints at the
top of the report only. Do not obscure any other objects in the report. Close the database      (1
application.                                                                                   Mark)

Total Marks                                                                                     (32
                                                                                               Marks)