Which of the following is the default join between two recordsets?
What is the full form of SQL?
Dcl provides commands to perform actions like
You created a query with two tables that have relationship of One-To-Many with referential rulesapplied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
A Smart Tag can be set using the _____ tab in the property sheet.
In Access 2007, to set a table to open as a document tab, you need to go to the ____.
Which criteria return only those addresses beginning with the letter “K”?
This data type allows alphanumeric characters and special symbols.
The command center of access file that appears when you create or open the MS Access database file.
We can remove a relationship defined between two tables by
An organized collection of logically related data is known as
A(n)_______ is a major object that can run independent of a control.
What happens when a user selects a record in a form and presses [Delete]?
The __________ field is used to hold a yes or no answer.
What do you call a primary key field included in another table?
Which of the following is not a database object in MS Access?
If you need to edit a relationship
Which is the valid data type in Access?
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
When adding an image, which size mode will change the height or width of the image fit the control?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
-
-
-
-
Which query do you use to answer the question “What is the average salary of the employees”?
Which of the following Format supports for Data Type Yes/No?
Which of the following methods CANNOT be used to delete records from a table?
In Datasheet View, new records are added to a table ____.
What determines a table’s sort order?
If you need to edit a relationship
Changing the order of this in the query datasheet does not affect the field order in the table.
To store your picture in a database requires a(n) __________ field.
The ______ is a wild card that represents one or more characters.
In MS Access, Text Data type may contain maximum character of
In MS Access, Text Data type may contain maximum character of
Referential integrity means
Which of the following is not a form style available in the form wizard dialog box.
A _____name must be unique within a database
All attachment fields display as a(n) ____ in Datasheet View.
In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
This option allows you to build a new table by entering data directly into the datasheet.
Which of the following database objects extracts information from one or more tables or queries?
Which report section prints once at the bottom of every printed page?