What is a form in MS Access
It is a printed page where users will write their data to fill it up
It is an input screen designed to make the viewing and entering data easier
This is an important part of database used by analysts to draw conclusions
All of above
Correct Answer :
B. It is an input screen designed to make the viewing and entering data easier
Related Questions
To create queries in Access
You can drag and drop fields on query builders
you can type the SQL command in SQL view
You can use query wizard or design view
All of above
The size of a field with Number data type can not be
2
4
8
16
Which of the following expresses correct order?
Characters, Fields, Records, Tables, Files, Databases
Characters, Fields, Records, Tables, Database, Files
Databases, Tables, Files, Records, Field, Character
Files, Databases, Tables, Records, Fields, Characters
The___ operator will cause a record to be selected only if two or more conditions are satisfied
Or
If or
Range
And
Database Management Systems are featured with:
The facility to easy editing, spelling check, auto pagination, lay out and printing reports
The ability to store large amount of data to facilitate easy update, sort and retrieval
The ability to calculate efficiently with the help of built-in functions and analyze
All of above
What is a form in MS Access
It is a printed page where users will write their data to fill it up
It is an input screen designed to make the viewing and entering data easier
This is an important part of database used by analysts to draw conclusions
All of above
In one-to-many relationship the table in one side is called _______ and on many side is called _______
Child , Parent
Parent , Child
Brother , Sister
Father , Son
An Access database object that is used to enter, view or edit records
Table
Form
Query
Report
To create relationship between two tables
drag the primary key of a table into foreign key of another table
drag the foreign key of a table into the primary key of another table
drag any field from parent table and drop on child table
Any of above can be done to create relationship
When creating a new table which method can be used to choose fields from standard databases and tables
Create table in Design View
Create Table using wizard
Create Table by Entering data
None of above
Which of the following is NOT a type of Microsoft Access database object?
Table
Form
Worksheets
Modules
In table design view, which key can be used to switch between the field names and properties panels?
F3
F4
F5
F6
Which of the following statement is true?
Foreign key fields dont allow duplicate values
In primary key field you can enter duplicate value
In an indexed field you may or may not enter duplicate value depending upon setting
All statements are true
What is the maximum length a text field can be?
120
255
265
75
It is most common type of query. It retrieves records from one or more tables and then displays the
Parameter
Select
crosstab
All of above
We can remove a relationship defined between two tables by
From Edit menu choose Delete Relationship
Select the relationship line and press Delete
Choose Delete option from Relationship menu
All of above
If you need to edit a relationship
Right click the relationship line and choose Edit Relationship
Double click the relationship line
Both of above
None of above
Which is not a view to display a table in Access?
Datasheet View
Design View
Pivot Table & Pivot Chart View
None of above
To achieve AND effect when you are entering criteria in a query design window
write criteria values vertically one in a row
write criteria values horizontally
Write criteria values in same field separated with AND
Write criteria values in same field separated with &
The database language that allows you to access or maintain data in a database
DCL
DML
DDL
None of above
Which field type will you select when creating a new table if you require to enter long text in that field?
Text
Memo
Currency
Hyperlink
This key uniquely identifies each record
primary key
key record
unique key
field name
To sort records in a table
Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
Click the field heading to sort it ascending or descending
All of above
What are the columns in a Microsoft Access table called?
Rows
Records
Fields
Columns
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A relationship is created
Edit relationship dialog box appears
Error occurs
Nothing happens
When entering field name, how many characters you can type in maximum?
60
64
68
Any number of character
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Parameter
Select
crosstab
Append
Which of the following can be an example of a database?
Address book of all the suppliers of a company
Salary sheet of all the employees of a company
Records of daily sales transactions of a company
All of above
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
relationship
Join
Query
None of these
The task of arranging data in order is called
Searching
Sorting
Ordering
Shorting