2006

Locate the record where the value of the MovieName field of the Movies table is set to MATRIX Reloaded and change it to MATRIX REVOLUTIONS.

On the same record change the value of the Retail Price field from 70 to 80. Save the record.

2007

Insert one more field named notes in the Movies table. Make sure the field is set to hold a text of 1000 or more characters. Save and close the table.

2018

Change the header text Customers Form of the open form to Partners and apply Times New Roman, 12pt, bold and italics font. Save and close the form.

2022

Delete all criteria of the current query. Save and close the query.

2030

Among the Microsoft Office applications which are open, terminate Microsoft Access only.

2035

Apply a validation rule to the RetailPrice field in the Movies table to allow entering only prices equal to or higher than 2 and equal to or lower than 100. When the user types different prices, the system will return the message Acceptable values from 2 to 100

Save and close the table.

2036

Delete the Movies table.

2037

Delete the All the customers query.

2048

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

2051

Save and close the report.

2061

Go to the previous record.

2074

Create a one-to-one relationship between the Code fields of the Products and the ProductsPhoto tables. Do NOT enforce the referential integrity.

2083

Use the open form to enter a new record with the following values:

Code: 888771

Description: All Time Classic

Price: 888772

Save the record but do not close the form.

2090

Open the ProductForm form and locate the record which displays a product Description which begins with VIPER 500.

2099

Create a new query that will use the Description and Price fields from the Products table and the FileRoot field of the ProductsPhoto table. Apply a criterion to the FileRoot field to retrieve all records which contain a photo. Make sure that when the query is executed the Description and Price fields only (following this order) are displayed. Save the query as q1 and close it.

2104

Apply sorting by Price in a descending order to the Products table. Save and close the table.

2113

Print the whole R_Products report to the default printer.

2190

Create a new table to display the following fields:

1st field:Name: Code,type of data: AutoNumber

2nd field:Name: FirstName,type of data: Text.

3rd field:Name: Information,type of data: Memo.

Save the table as Names and close it.

2809

Create a blank form named StartForm. Insert a button to display the text Customers, which will open the Customers form and will display all of its records, when the user clicks it. Insert another button to display the text Orders, which will open the Orders form.

2818

Export the Customers table to the IL-ates folder of your desktop, as data.xml, in xml format.

2842

Modify the Orders20 query that is already open to retrieve only the products of a price lower than or equal to 50 euros that have been ordered on 01/30/2004.

10004

How can we open the help of Microsft Access application?

10139

When we create a relationship between two tables we can ...

10893

A database is a(n)…

10894

A primary key allows the user to …

10905

A change in the length of a text field from 10 to 6 characters will

11382

Which is the fastest way to print a report to the default printer?

11758

Among the following, who can enter, preserve and retrieve data in a database?

11764

If you wanted to print selected information from a table or query, which of the following objects would you use?

11768

How would you reduce the number of duplicates in a database?