view, modify, insert and delete data

view, modify and insert but not delete data

view but not modify, insert or delete data

Restructuring table records and objects, and then stores them in successive memory blocks.

Restores table records into their primary key order, if a primary key exists in the table

Reduces the physical size of your database by making an exact duplicate of the database.

All users have the query owner's permission to view or run the query

Only the query owner can save changes to the query and other networked users cannot use the open database simultaneously

Only the query owner can change the ownership of the query

Select count(amount) as total from students

Select total from students

Select * from students

This utility splits a Microsoft Access database into three files

This utility breaks up the information in the tables into a compacted format for faster retrieval

All of these

Add a text box to the group's Page Footer, and its control source to "=Count(*)"

Add a text box to the group's Footer section, and its control source to "=[RecordCount]"

Add a text box to the group's Report Footer, and its control source to "=[RecordCount]"

Len

Trim

Left

It can perform heterogeneous queries across a variety of data sources

It supports temporary tables or links to other data sources beyond the single SQL Server database

The second user will receive the 'Permission denied' message

The second user can make changes to the file that has been opened by the first user, and the first user will receive the "File is being modified by another user" message

Both users will receive the 'Permission denied' message

Encapsulation, inheritance

Polymorphism

Reusability