image
 
 
 
 
 

ECDL, ICDL Module 5 Sample Test 1 Preview

     

"The following sample test is based on working with a database called Herb Garden. In the sample test you will create a small table and enter some data, design queries that will extract information from the database, and create simple forms and reports." (ECDL Foundation)

Play Intro
Play Video
   

Q.
Play Video
1a

Which one of the following describes the content of a database?

a.    A collection of files with no particular link.                  
b.    A collection of data related to another application.    
c.    A collection of data related to a particular subject.     
d.    A collection of documents.
  Play Video  
1b

Which one of the following is NOT a common use of a large-scale database?

a.   Bank account records.                 
b.   Airline reservation systems.
c.   Driver licence records.   
d.   Personal address book.

     
1c

Which one of the following can result from reducing the size of a field in a table?

a.   A decrease in the number of records in the table.                
b.   An increase in the number of records in the table.
c.   Changes to reports which access the table.
d.   Loss or corruption of data in the table.

     
1d

Which one of the following is used to assign a unique identity to a record?

a.   A validation rule.              
b.   A form.
c.   A primary key.
d.   A filter. 

     
1e

Which one of the following is the purpose of relating tables in a database?

a.   To permit external data only to be viewed.              
b.   To allow data to be sorted before printing to a report.
c.   To enable mathematical calculations to be carried out more efficiently.
d.   To avoid duplication of data.

     
1f

Which one of the following prevents you adding a record to a related table when there is no associated record in the primary table?

a.   A primary key.      
b.   Relational integrity.
c.   A validation rule.
d.   An index.

     
1g

Which one of the following is responsible for recovering the database after a crash?

a.   A database administrator.           
b.   A database user.
c.   A database designer.
d.   A database architect.

     
2. Open the Herb Garden database from your Candidate Drive.          Play Video  
3. Create a new table with the 3 fields and their properties as shown below.

Field Name

Data Type

Field Size or Format

Herb ID

AutoNumber

Long Integer

Herb Name

Text

25

Price

Currency

Euro


  Play Video  
4. Set the Herb ID field as the primary key. Save the table as New Varieties
  Play Video  
5. Add the following records to the New Varieties table.  Save and close the New Varieties table.

Herb ID

Herb Name

Price

1

Basil Puck

€1.29

2

Golden Sage

€2.25


  This video is not available in the Preview Test  
6. Open the Customers table, add the field below and save the changes.

Field Name

Data Type

Field Size or Format

Telephone

Text

25


  This video is not available in the Preview Test  
7. In the Customers table move the Last Name field so that it appears between the First Name and the Type fields. Save and close the table.   Play Video  
8. In the Herb Stock table modify the Price field to show 2 decimal places for all records. Save the table.   This video is not available in the Preview Test  
9. Change the displayed width of all columns in the Herb Stock table to 25 and save.   This video is not available in the Preview Test  
10. Sort the Herb Stock table by the Price field in ascending order. Save and close the table.   This video is not available in the Preview Test  
11. In the Customers table delete the Last Name Western and replace with the Last Name Weston. Save and close the table.   Play Video  
12. Delete the Discontinued Herbs table.   This video is not available in the Preview Test  
13. Using all the fields from the Herb Stock table, create a new query that will show all herbs with a price greater than €2.  Save the query as More Than 2. Close the More Than 2 query.   Play Video  
14. Open the Customer Details query and delete the Town field.  Save and close the query.

  This video is not available in the Preview Test  
       
15. Open the Prices query.  Modify the query to extract herbs costing 1.99 or 2.25. Save and close the query.   This video is not available in the Preview Test  
16. Create a query using the First Name, Last Name and Town fields from the Customers table and the Route field from the Deliveries table. Save the query as Delivery Routes and close the query.   This video is not available in the Preview Test  
17. Create a simple form using all fields from the Customers table.  Accept default settings.  Save the form as Trade Customers and close the Trade Customers form.   This video is not available in the Preview Test  
18. Open the Seeds form and add the following record.  

Seed ID

Seed Name

10

Tarragon

  This video is not available in the Preview Test  
19. Use the Seeds form to change the Seed Name of the item with Seed ID 5 from Lovage to Seed Name Spearmint. Close the form.          This video is not available in the Preview Test  
20. Open the Herb Stock form and modify the header Herb Details to be red, size 14.  Save and close the Herb Stock form.     This video is not available in the Preview Test  
21. Create a report using all the fields from the Seeds table.  Accept default settings.  Save the report as Seeds and close.   This video is not available in the Preview Test  
22. Create a report using the First Name, Last Name, Town, Sales Rep and First Contact fields from the Customers table. Group the report by Town and sort the customer details in ascending Last Name order. The report orientation should be landscape. Save the report as CustList and close.   This video is not available in the Preview Test  
23. Select the Customers table. Export the Customers table in Microsoft Excel format as Customers.xlsx and save to your Candidate Drive.     This video is not available in the Preview Test  
24. Delete the Discontinued Herbs report.      This video is not available in the Preview Test  
25. Open the Herb List report and modify the header Herb Stock to read List of Herbs In Stock.  Save and close the Herb List report.   Play Video  
 

END OF TEST

     

This is a sample test for use by Candidates intending to take the ECDL / ICDL Certification Tests. The test aim is to give Candidates an opportunity to become comfortable with the style and structure of the Test. The sample tests must not, under any circumstances, be used in Certification testing.