2005

Add the following records to the table Movies:

MovieNameYearReleasedAudienceRetailPrice

MATRIX Reloaded2003R70,00 €

Love left2001R55,00 €

Armageddon2002R60,00 €

 

Save the records.

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.

2036

Delete the Movies table.

2055

Delete the values of the Audience and RetailPrice fields from the record where the value of the MovieName field is set to MATRIX Reloaded. Save the record.

2056

Delete the record where the value of the MovieName field is set to MATRIX Reloaded.

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: Audiencevalue: R
field: Retail Pricevalue: 100

Save the record.

2058

The system has made a change in the table. Undo it.

2060

Go to the next record.

2061

Go to the previous record.

2062

Go to the first record.

2063

Go to the last record.

2064

Go to record 147.

2065

Change the size of the Description field in the open table to 20 characters. Save and close the table.

2150

Export the PhotoSizeWithPath query as text file, in tab delimited export format. Do not include Field Names. Set the Text Qualifier to None. Save the query as PhotoSizeWithPath.txt to the Desktop\TEST4UFolder.

2764

Export the Products table to the IL-ates\Files folder of your desktop, in Excel 97 - Excel 2003 Workbook file format, and save it as book1.xls.

2765

Export the Products table to the IL-ates\Files folder of your desktop, in text file format, and save it as PR.txt.

2766

Export the Products table to the IL-ates\Files folder of your desktop, in XML file format, and save it as PR.xml.

2816

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

2817

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

2818

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

2819

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

2820

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

2821

Export the SizePhotoPath query to the IL-ates\Excel folder on your desktop, as data.txt, in txt format.

10136

What will happen to the data of a record we edited, if we navigate to another record of the same table?

11750

Which of the following objects would you use to export and analyze data?

11763

____________ is used to export and analyze data.