Add the following records to the table Movies:
MovieNameYearReleasedAudienceRetailPrice
MATRIX Reloaded2003R70,00 €
Love left2001R55,00 €
Armageddon2002R60,00 €
Save the records.
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.
Delete the Movies table.
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.
Delete the record where the value of the MovieName field is set to MATRIX Reloaded.
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.
The system has made a change in the table. Undo it.
Go to the next record.
Go to the previous record.
Go to the first record.
Go to the last record.
Go to record 147.
Change the size of the Description field in the open table to 20 characters. Save and close the table.
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.
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.
Export the Products table to the IL-ates\Files folder of your desktop, in text file format, and save it as PR.txt.
Export the Products table to the IL-ates\Files folder of your desktop, in XML file format, and save it as PR.xml.
Export the Customers table to the IL-ates folder of your desktop, as export.txt, in txt format.
Export the Customers table to the IL-ates folder of your desktop, as export.csv, in csv format.
Export the Customers table to the IL-ates folder of your desktop, as data.xml, in xml format.
Export the SizePhotoPath query to the IL-ates\Word folder on your desktop, as photos.xml, in xml format.
Export the SizePhotoPath query to the IL-ates\Word folder on your desktop, as attention.csv, in csv format.
Export the SizePhotoPath query to the IL-ates\Excel folder on your desktop, as data.txt, in txt format.
What will happen to the data of a record we edited, if we navigate to another record of the same table?
Which of the following objects would you use to export and analyze data?
____________ is used to export and analyze data.