6505

Among the OpenOffice.org applications which are open, terminate OpenOffice.org Base only.

6511

Hide the Form Controls toolbar and show the Tools toolbar.

6515

Delete the Movies table.

6522

Go to the previous record.

6545

Create a new table displaying the following fields:

1st field: Code,type of data: BigInt, PrimaryKey, AutoValue

2nd field: Name,type of data: Text [VARCHAR]

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

 

Save the table as Names and close it.

6555

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

6563

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

ID: 888771

Description: All Time Classic

Price: 888772

 

Save the record but do not close the form.

6567

Search for the first record which contains the text wrong in the Notes field.

6571

Open the FormProducts form and apply a filter to retrieve only the records which display a Description beginning with CLIFFORD. Do NOT close the form.

6581

Insert the appropriate criteria in the current query so that it returns only the customers whose PC begins with 54. Save and close the query.

6584

Modify the current query so that it displays the CName and PC fields only for the customers whose PC begins with 54. Save and close the query.

6587

Create a new query that will use the Description and Price fields from the Products table and the FilePath field of the ProductsPhoto table. Apply a criterion to the FilePath field to retrieve all records containing 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.

6598

Apply sorting by Price in a descending order to the Products table. Close the table.

6606

Save and close the report.

6619

Print only the fifth page of the R_Products report to the default printer.

6630

Create a new query named product_count to retrieve the total number of records displayed in the Products table. Use mycount as name for the calculated field. (use the ID field to meet the needs of the query)

6636

Delete the relationship between the Products and Orders tables. Save the changes.

12024

If you edit, organize and display _______ within a frame, the resulting output will be_______.

12033

Who of the following can enter, preserve and retrieve data in a database?

12037

A database consists of …

12045

Which of the following are examples of database?

12046

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

12048

Which of the following processes can be accelerated by the use of an Index?

12060

Changing the length of a text field from 10 to 6 characters will …

12062

Every field has associated properties like…

12069

What are the referential integrity rules between related fields, assure us?

12070

What is the purpose of creating a relationship between tables?

12073

A report is used …

12075

What is the fastest way of printing a report to the default printer?

12076

Which of the following ways allows printing 10 copies of a report to the default printer?