This is the stage in database design where one gathers and lists all the necessary fields for the database project.
data definition
data refinement
establishing relationship
none of the above
Correct Answer :
A. data definition
Related Questions
To create a new table, in which method you dont need to specify the field type and size?
Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above
Cascade update option
means do not change the value in the primary key field if that record has related records in another table
means change all the related records in child tables if the record in parent table is changed
Both of above
None of above
When entering field name, how many characters you can type in maximum?
60
64
68
Any number of character
The default and maximum size of text field in Access
50 and 255 Characters
8 and 1 GB
266 characters & 64000 characters
None of above
What is the maximum length a text field can be?
120
255
265
75
If you write criteria values vertically (one in a row) it will mean
OR conditions
AND conditions
NOT condition
None of above
A composite key is
Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records
The__ button on the tool box display data from a related table
Sub form sub report
Relationships
Select objects
More controls
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
You can set a controls border type to make the border invisible.
Transparent
Invisible
Do not display
No border
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
The two form layout types will display multiple records at one time are tabular and___
columnar
justified
date sheet
pivot table
Microsoft Access is a
RDBMS
OODBMS
ORDBMS
Network database model
It is an association established between common fields of two tables.
line
relationship
primary key
records
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
Which of the following is a method to create a new table in MS Access?
Create table in Design View
Create Table using wizard
Create Table by Entering data
All of above
A small button with three dots usually displayed at the right of field properties box
Make button
Expression button
Build button
None of above
How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
Input mask
Validation Rule
Indexed
IME Mode
Referential integrity means
Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
Do not enter a value in the primary key field of child table if that value does not exist in the primary key of the parent table
Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
All of above
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
Foreign key
Native key
Composite key
Primary key
Which field type can store photos?
Hyperlink
OLE
Both of these can be used
Access tables cant store photos
Which of the following database object produces the final result to present?
Forms
Reports
Queries
Tables
A part of database that stores only one type of data is
Report
Field
Query
Record
You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
Clicking
Right clicking
Double clicking
None of the above
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
You need to delete the whole tablThere is no method to remove a particular field only.
Delete all the fields from third downwards and reenter the required fields again.
Select the third column in datasheet view then Delete
Select the third row in table design view then Delete
The command center of access file that appears when you create or open the MS Access database file.
Database Window
Query Window
Design View Window
Switchboard
Which of the following is not a type of relationship that can be applied in Access database
One to One
One to Many
Many to Many
All of above can be applied
Which of the following statement is true
Reports can be used to retrieve data from tables and calculate
Queries can be printed in well formatted manner and presented as the information
Queries can include calculated fields that do not exist in table
Reports and forms are similar but forms are use to print but reports to display on screen only
It is a database object to view, change, and analyze data in different ways
query
form
report
None of the above
A database language concerned with the definition of the whole database structure and schema is ________
DCL
DML
DDL
All of above