Close the current database.


Create a new table to display the following fields:

1st field: name:CopyCode,data type: AutoNumber-Long Integer, primary key

2nd field: name:MovieName,data type: Text, number of characters: 50

3rd field: name:YearReleased,data type: Number-Long Integer

Save the table as Copies and close it.


Add the following records to the table Movies:


MATRIX Reloaded2003R70,00 €

Love left2001R55,00 €

Armageddon2002R60,00 €


Save the records.


Modify the RetailPrice field in the Movies table to display values in 3 decimal places. Save and close the table.


Create a one-to-many relationship between the CustomersCode fields in the Customers and Rents tables. Enforce the referential integrity and make sure cascade updating and deleting records are enabled.


In the current query insert the PC field after the Address field. Save and close the query.


Delete the CustomersReport report.


Open the RentingForm form and navigate to the record 123.


Move the textbox which displays the date =Now() within the open report, setting its possition in 0" from left and in 0" from top of the page footer.


On the text box which displays the text Customers Report in the current report change the font color of the text to black.


A form is already open. Change the view to Datasheet View.


Locate the record where the value of the MovieName field is set to DARK CITY and insert the following values in the respective fields:
field: Audience      value: R
field: Retail Price   value: 100

Save the record.


Set an index that will not allow duplicates in the Description field of the open table and change the Required property to Yes. Save and close the table.


Change the order of the columns as follows, without modifying the table structure:

1st column Description,

2nd column Price,

3rd column Code.

Save and close the table.


Create a one-to-one relationship between the Code fields of the Products and the ProductsPhoto tables. Enforce the referential integrity. Enable the Cascade Update Related Fields option. Do not enable the Cascade Delete Related Records one.


Use the open form to find the record where the value of the Description field contains the phrase 791XV

Then, change the value of the Price field from 50 to 1024. Save the record but do not close the form.


Apply a filter to the ProductForm form to retrieve only the records which display Price values ranging from (including) 80 and 1000 and Descriptions which begin with DIRECTED. Do NOT close the form.


Remove the filter from the open table. Do not close the table.


Create a new query based on the Products table that will display the Description and Price fields only (following this order). Sort the Description field in ascending order. Apply a criterion to the Price field which will return the records which display values equal or lower than 10. Save the query as q1 and close it.


Apply sorting by Description in descending order to the ProductForm form. Save but do NOT close the form.


Create a new report which will be based on the query r_orders in which all the fields will appear. Grouping level based on the field CustomersCode. Ascending ordering according to Description, with summary of sum of the field TotalValue and sum of the field Quantity (show detail and summary without percentage calculations). Save the report under the name r_orders and close it.


Print the pages 3, 4 and 5 of the R_Products report to the default printer.


Print pages 2 and 3 of the Products table to the default printer.


The data of the open report are grouped and sorted by CustomersCode in ascending order. Change the grouping field from CustomersCode to ItemCode and the sorting type from ascending to descending. Save and close the report.


Create a new query named myprice that will display the average of the product prices displayed in the Products table. Use avgprice as name for the calculated field.


Export the SizePhotoPath query to the IL-ates\Word folder on your desktop, as photos.xml, in xml format.


Insert a button in the Detail Section of the ProductForm form displaying the text Report
The button should open the R_Products report in print preview. Save the form.


Apply the appropriate index to the Description field of the Products table that will not allow the input of duplicates. Save the table.


Move the text box which displays the date, to the Report Footer of the R_Products report.


How many data items should a table field contain?