АКТ 161-185

MS Access: Datasheet view: is a windows that displays data from___.

• a table, view, or stored procedure in a row-and-column format;

• a table, query, view, or stored procedure in a row-and-column format;

• a table, form, query, view, or stored procedure in a row-and-column format

• a table, form, query, view;

• a table only.

MS Access: You can use the navigation toolbar to ____.

• move through the records in a datasheet;

• create a database;

• navigate database through the internet;

• move through the fields in a datasheet;

• move through the list of tables.

MS Access: A select query:

• deletes data from one or more tables and displays the results in a datasheet;

• retrieves data from forms and displays the result in a datasheet;

• retrieves data from one or more tables and displays the results in a datasheet;

• refreshes data from one or more tables and displays the results in a form;

• updates data in database.

MS Access: An action query is a query that:

• makes changes to or moves many records in just one operation;

• creates new databases, erase files, or refreshes data from one or more tables:

• retrieves data from one or more tables and displays the results in a datasheet;

• updates data in database:

• deletes data from one or more tables and displays the results in a datasheet.

MS Access: Find a correct SOL commands:

• select, update, delete, create, follow;

• select, update, delete, order by, where, from, and;

• select, update, delete, order by, count, read, write;

• add, select, update, where, and, or, there is no;

• update, total;

MS Access: What does the following query do: select * from students, library where student.book_id=library .book_id?

• retrieves all the data from students and library tables, only for those students with books

• retrieves all the records from library table;

• selects all the data from students and library tables;

• updates all the data from students and library tables, only for those students with books fi

• counts all the data from students and library tables, only for those students with books fro

MS Access: Access file has____ extension:

• mdb

• exe

• com

• bmp

• bas

Linked objects in documents. Information (the object) that is created in one file___, and interested into another file__, while maintaining a connection between the two files. The linked object in the ____ can be updated when the__ is updated. A linked object___ become part of the destination file.

• Source file, destination file, destination file, source file, does not;

• Source file, destination file, destination file, source file, does;

• Destination file, source file, destination file, source file, does not;

• Destination file, source file, destination file, source file, does;

• Destination file, source file, source file, destination file, does;

Embedded object. Information (the object) inserted into a file__. Once embed, the object ____part of the destination file. When you double-click an embedded object, it opens in the program ___, it was created in. Any changes you make to the embedded object are_____in the destination file.

• Destination file, becomes, source program, reflected;

• Source file, does not become, source program, reflected;

• Source file, does not become, destination program, reflected;

• Destination file, does not become, source program, not reflected;

• Destination file, becomes, source program, not reflected;

Integrated software packages____the functions of the most important PC software packages,such as word processing, spreadsheets, presentation graphics, and data management. This___ provides a general-purpose software tool and_____redundant data entry and data maintenance.

• Combine, integration, eliminates;

• Lack, integration, eliminates;

• Lack, disintegration, increases;

• Combine, disintegration, eliminates;

• Combine, integrat