Related Questions
What is the correct answer?
4
To create queries in Access
A. You can drag and drop fields on query builders
B. you can type the SQL command in SQL view
C. You can use query wizard or design view
What is the correct answer?
4
When entering field name, how many characters you can type in maximum?
D. Any number of character
What is the correct answer?
4
The size of Yes No field is always
What is the correct answer?
4
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A. A relationship is created
B. Edit relationship dialog box appears
What is the correct answer?
4
DCL provides commands to perform actions like
A. Change the structure of tables
B. insert, update or delete records and data values
C. authorizing access and other control over database
What is the correct answer?
4
Query design window has two parts. The upper part shows
A. Name of fields, field type and size
B. Tables with fields and relationships between tables
What is the correct answer?
4
The size of a field with Number data type can not be
What is the correct answer?
4
The database language that allows you to access or maintain data in a database
What is the correct answer?
4
Following is not a database model
A. network database model
B. relational database model
C. Object Oriented database model
What is the correct answer?
4
To duplicate a controls formatting you can use___
What is the correct answer?
4
To create primary key for a table when in design view
A. Type PRIMARY in field type box when creating required field
B. Mark the Primary check box in field name of required field
C. Click the Primary Key button in Design ribbon when the cursor is in required field
What is the correct answer?
4
The command center of access file that appears when you create or open the MS Access database file.
What is the correct answer?
4
A __ name must be unique within a database
What is the correct answer?
4
An Access database object that is used to enter, view or edit records
What is the correct answer?
4
A small button with three dots usually displayed at the right of field properties box
What is the correct answer?
4
It is a database object to view, change, and analyze data in different ways
What is the correct answer?
4
A database language concerned with the definition of the whole database structure and schema is ________
What is the correct answer?
4
To create relationship between two tables
A. drag the primary key of a table into foreign key of another table
B. drag the foreign key of a table into the primary key of another table
C. drag any field from parent table and drop on child table
D. Any of above can be done to create relationship
What is the correct answer?
4
A primary key in any table has the properties
What is the correct answer?
4
Which field type will you select when creating a new table if you require to enter long text in that field?
What is the correct answer?
4
You can set a controls border type to make the border invisible.
What is the correct answer?
4
Both conditions display on the same row in the design grid when ___operator is in use
What is the correct answer?
4
To create a new table, in which method you dont need to specify the field type and size?
A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
What is the correct answer?
4
In table design view, which key can be used to switch between the field names and properties panels?
What is the correct answer?
4
If you write criteria values vertically (one in a row) it will mean
What is the correct answer?
4
Microsoft Access is a
D. Network database model
What is the correct answer?
4
When a picture or other graphic image is placed in the report header section it will appear____
A. Once in the beginning of the report
B. At the top of every page
C. Every after record break
D. On the 1st and last pages of the report
What is the correct answer?
4
This is the stage in database design where one gathers and lists all the necessary fields for the database project.
C. establishing relationship
What is the correct answer?
4
Which of the following database object produces the final result to present?
What is the correct answer?
4
Which of the following can be an example of a database?
A. Address book of all the suppliers of a company
B. Salary sheet of all the employees of a company
C. Records of daily sales transactions of a company