Related Questions
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 table design view what are the first column of buttons used for
What is the correct answer?
4
To achieve AND effect when you are entering criteria in a query design window
A. write criteria values vertically one in a row
B. write criteria values horizontally
C. Write criteria values in same field separated with AND
D. Write criteria values in same field separated with &
What is the correct answer?
4
Queries in Access can be used as
A. view, change and analyze data in different ways
B. a source of records for forms and reports
What is the correct answer?
4
What is the maximum length a text field can be?
What is the correct answer?
4
In one-to-many relationship the table in one side is called _______ and on many side is called _______
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
A primary key in any table has the properties
What is the correct answer?
4
Database Management Systems are featured with:
A. The facility to easy editing, spelling check, auto pagination, lay out and printing reports
B. The ability to store large amount of data to facilitate easy update, sort and retrieval
C. The ability to calculate efficiently with the help of built-in functions and analyze
What is the correct answer?
4
When creating a new table which method can be used to choose fields from standard databases and tables
A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
What is the correct answer?
4
This data type allows alphanumeric characters and special symbols.
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
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
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
What do you mean by one to many relationship between Student and Class table?
A. One student can have many classes
B. One class may have many student
C. Many classes may have many students
D. Many students may have many classes
What is the correct answer?
4
A __ name must be unique within a database
What is the correct answer?
4
It is a sign or symbol that specifies, operator, and values that produce a result
What is the correct answer?
4
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
What is the correct answer?
4
In a database table, the category of information is called ____________
What is the correct answer?
4
What are the columns in a Microsoft Access table called?
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
Which of the following store command to retrieve data from database?
What is the correct answer?
4
Which of the following is not a database object in MS Access?
What is the correct answer?
4
It is most common type of query. It retrieves records from one or more tables and then displays the
What is the correct answer?
4
Which of the following is not a field type in Access
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
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
The two form layout types will display multiple records at one time are tabular and___
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