Which of the following is not a type of relationship that can be applied in Access database
This type of database contains multiple tables that are connected to produce combined output from all tables.
Which of the following is not a logical database structure?
This data type allows alphanumeric characters and special symbols.
Which is NOT an option of the Picture Size Mode property?
What is the type of query that extracts data from a table and puts them into separate table?
How many relations may exist between tables in databases?
This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
Which of the following SQL query deletes Product table from Store database?
What is the purpose of indexing?
What is the difference between ‘open’ and ‘open exclusively’
Which Form tool creates a new form that show both a form and datasheet views?
Which of the following statements about a tab control in a form is incorrect?
What is the use of description field in table design window?
What is a form in MS Access?
The database language that allows you to access or maintain data in a database
Which control type do you use to create a calculated control?
Which of the following is not a legitimate section for form objects?
A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be
What does the show check box in query design window indicate
The Search tool is best used when searching for ______ data.
According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
How can you display pivot table report summary data in a currency format?
In a datasheet, what does each column represent?
Which criteria return only those addresses beginning with the letter “K”?
Which of the field has width 8 bytes?
The__ button on the tool box display data from a related table
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______.
The command center of access file that appears when you create or open the MS Access database file.
Which of the following is the DBMS type
Which of the following statements does NOT hold true for the Top Values property?
This form displays multiple records, one per row, in the form window
You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
The _____ Smart Tag launches Microsoft Outlook to schedule an appointment or display a calendar.
Which of the following statement is true?
In MS Access “Lookup Wizard” is used to
In a database table, the category of information is called __________
Which setting you must modify to print a report using letterhead?
You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
It is a sign or symbol that specifies, operator, and values that produce a result