MS Access Objective Questions

Access	Oracle follows only seven Codd's rule.	True	False			A
Access	Access is a true RDBMS.	True	False			B
Access	In a table records are stored in rows and fields in columns.	True	False			A
Access	Text type field stores maximum 256 characters.	True	False			B
Access	Memo field stores 64,000 characters.	True	False			A
Access	In Yes / No field -1 stands no and 0 stands for yes.	True	False			B
Access	The lostfocus event occurs when a form or control looses the focus.	True	False			A
Access	We can not set a background picture in a report.	True	False			B
Access	We can see the report preview from tools menu à layout preview.	True	False			B
Access	Report header / footer sections does not come normally.	True	False			A
Access	We can have subform within a subform.	True	False			A
Access	We can type new values in a list box.	True	False			B
Access	When referential integrity is enforced, you can't enter a value in the foreign key field of the related table that doesn't exist in the primary key of the primary table.	True	False			A
Access	When the cascade delete related records check box is set, deleting a record in the primary table deletes any related records in the related table.	True	False			A
Access	If you want to see the SQL code that is generated by the query select Tools à SQL view from the menu.	True	False			B
Access	If you give a format property and an input mask the input mask gets precedence.	True	False			B
Access	A primary key is a must in a table.	True	False			B
Access	Double data type takes 4 bytes of space.	True	False			B
Access	There is one-to-many relationship between mainform and subform.	True	False			A
Access	You can not specify default value for a field.	True	False			B
Access	Foreign key must be primary key of another table.	True	False			A
Access	If required field property is turned on the user must enter something in this field in order to save the data.	True	False			A
Access	In access you can copy the only structure of the table without the records.	True	False			A
Access	A macro can be run automatically when a database opens.	True	False			A
Access	A report can only be based on table.	True	False			B
Access	In access page footer comes before report footer in all pages.	True	False			B
Access	Currency is not a valid data type in access.	True	False			B
Access	In append query the table where the data will be appended should have the same structure and primary key.	True	False			A
Access	It is possible to enter a Null value in the foreign key.	True	False			A
Access	It is not possible to set two fields of a table as primary key.	True	False			B
Access	In access you can store the information of a video files in table.	True	False			A
Access	In access, sorting the records in a table changes the order in which the records are displayed.	True	False			A
Access	In access after you select all the fields necessary for the query, access builds the SQL in the background.	True	False			A
Access	To run a macro automatically, the name of the macro is	AUTOEXEC	AUTOEXEC.BAT	AUTO	None of the above	A
Access	In Validation rule <>0 means	entry is not null	entry must be a nonzero value	none of the above		B
Access	In input masks (999) 999-9999 means	(206) 555-0248	( ) 555-0248	both of the above	none of the above	C
Access	You can copy records from one table to another table in the current database or another database.	Update query	Append query	Maketable query		B
Access	To delete all orders placed in 1990 we have to use	Update query	Append query	Maketable query	Delete query	D
Access	To increase salary by 5% we have to use	Update query	Append query	Delete query		A
Access	In access relationships are	one-to-one	one-to-many	both of the above		C
Access	Access lets you set up following kinds of joins -	Only Inner join	Only outer join	Only self join	None of the above	D
Access	Extension of an access database is	.dbf	.mdb	.doc	.ppt	B
Access	It allows you to set the message that appears if the validation rule fails.	validation rule	validation text	default value	all of the above	B
Access	Primary key field must be	not null and unique	null and unique	not null and indexed		A
Access	You can store picture in a field of data type	picture	OLE Object	None of the above	a & b	B
Access	An example of calculated query is	label control	text control	both a & b		C
Access	Line control is a example of	bound control	unbound control	calculated control		B
Access	There is one-to-many relationship between mainform and subform.	True	False			A
Access	Access support full RDBMS concept.	True	False			B
Access	Using multiple row , we can not create primary key.	True	False			B