How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
To achieve and effect when you are entering criteria in a query design window
This type of database contains multiple tables that are connected to produce combined output from all tables.
Which of the following Data Type is used to store picture in MS Access
Which of the following views displays the field name, description, and properties of a table?
What is the use of description field in table design window?
Which of the following views displays the field name, description, and properties of a table?
Which of the following views is used to graphically summarize and analyze data in a recordset?
The Table _______________ Wizard analyzes a database and recommends changes for normalization.
In order to use dbms, it is important to understand
How can a user open the Expression Builder dialog box?
This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
The ascending order of data hierarchy is?
This is the stage in database design where one gathers and list all the necessary fields for the database project.
Which data type is better to use for storing the price of an item?
Which of the following is NOT possible when printing Forms?
Database properties do NOT include ___________.
The report footer section is most useful for displaying:
A(n) _______ is major object that completes an action or a set of actions.
What is an intersection of a row and a column?
The complete picture of data stored in database is known as
What is a form in MS Access?
Which of the following is not a view for interacting with a form object?
The appropriate Data Type to store Time in MS Access?
What happens when a user selects a record in a form and presses [Delete]?
Which of the following is not a logical database structure?
To create primary key for a table when in design view
How to make a date field DOB store the dates like “2002/10/17” ?
In the form wizard dialog box, the fields from the selected table are displayed in this list box.
In MS Access query, which of the fields is derived field? Query: SELECT product.qty AS Quantity, product.rate AS Rate, product.qty*product.rate AS Amount FROM product;
Which of the following relationship is not valid in MS Access ?
Which of the following is use to get data from user?
SQL stands for __________.
A ________ is a unit of information in a ________
The task of arranging data in order is called
Which of the following is not an action query?
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?