2003

Close the current database.

2004

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.

2005

Add the following records to the table Movies:

MovieNameYearReleasedAudienceRetailPrice

MATRIX Reloaded2003R70,00 €

Love left2001R55,00 €

Armageddon2002R60,00 €

 

Save the records.

2009

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

2013

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.

2024

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

2027

Delete the CustomersReport report.

2041

Open the RentingForm form and navigate to the record 123.

2043

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.

2044

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

2049

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

2057

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.

2067

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.

2073

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.

2076

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.

2085

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.

2094

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.

2095

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

2098

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.

2105

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

2111

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.

2116

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

2119

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

2126

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.

2130

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.

2819

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

2839

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.

2843

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

2844

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

11755

How many data items should a table field contain?