In relational database schema each tuple is divided into fields known as?
Which is not a view for displaying a report object?
To sort records in a table
Which control type do you use to create a calculated control?
The basic elements of a form or a report are called:
What is the purpose of indexing?
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
The _____ function returns a string that has been converted to uppercase text.
Following is not a database model
Which of the following store command to retrieve data from database?
Which is not an option for customizing a datasheet window?
In a module, a(n) _______ is a series of commands and properties that perform a specific task.
A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
In the Relationship window, related fields from each table are connected by a(n) _______________.
In Datasheet View, what appears at the top of each column?
Which of the following is not a field type in access
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
-
-
-
-
In order to use dbms, it is important to understand
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.
A collection of related tables is called
To set a password for the database, select ____________ in the Microsoft Access open window.
The Search tool CANNOT be used on which major Access object?
In a datasheet, what does each column represent?
A primary key in any table has the properties
What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?
To print information from a table, the __________ tool is the best choice.
A(n) _______________ query locates data from one or more tables.
vWhich of the following store command to retrieve data from database?
What happens when a user selects a record in a form and presses [Delete]?
The complete picture of data stored in database is known as
The ascending order of data hierarchy is?
What does the show check box in query design window indicate
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
Data can be import into Access Database from
In MS Access, which data type is appropriate to store large text and numbers?
To create primary key for a table when in design view