Related Questions
What is the correct answer?
4
Which of the following is not a database object in MS Access?
What is the correct answer?
4
If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:
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
Unlike text data type, this can store up to maximum of 65, 535 characters.
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
The___ operator will cause a record to be selected only if two or more conditions are satisfied
What is the correct answer?
4
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
A. You need to delete the whole tablThere is no method to remove a particular field only.
B. Delete all the fields from third downwards and reenter the required fields again.
C. Select the third column in datasheet view then Delete
D. Select the third row in table design view then Delete
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
A __________ enables you to view data from a table based on a specific criterion
What is the correct answer?
4
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:
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
The size of a field with Number data type can not be
What is the correct answer?
4
Which of the following database object produces the final result to present?
What is the correct answer?
4
We can remove a relationship defined between two tables by
A. From Edit menu choose Delete Relationship
B. Select the relationship line and press Delete
C. Choose Delete option from Relationship menu
What is the correct answer?
4
Each record is constituted by a number of individual data items which are called
What is the correct answer?
4
The task of arranging data in order is called
What is the correct answer?
4
If you need to edit a relationship
A. Right click the relationship line and choose Edit Relationship
B. Double click the relationship line
What is the correct answer?
4
A part of database that stores only one type of data is
What is the correct answer?
4
Microsoft Access is a
D. Network database model
What is the correct answer?
4
A search value can be an exact value or it can be
What is the correct answer?
4
A composite key is
A. Required when a table does not have any unique fields in it
B. The primary key with AutoNumber as the field type
C. Made up of two or more fields to uniquely identify records
D. Is a foreign key that uniquely identifies records
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
Which of the following statement is true?
A. Foreign key fields dont allow duplicate values
B. In primary key field you can enter duplicate value
C. In an indexed field you may or may not enter duplicate value depending upon setting
D. All statements are true
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
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
What is the correct answer?
4
In a database table, the category of information is called ____________
What is the correct answer?
4
Which of the following creates a drop down list of values to choose from a list?
What is the correct answer?
4
A database object in MS Access that stores a question about the data in database?
What is the correct answer?
4
What does the show check box in query design window indicate
A. It indicates whether the field is to be used or not
B. It indicates whether the field is to be displayed in query result or not
C. It indicates whether the field names to be displayed in query result or not
What is the correct answer?
4
The database language that allows you to access or maintain data in a database