GCOM-Microsoft Access Test -19

After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?

1 Mark(s)

You need to delete the whole table. There 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

To create queries in access__________?

1 Mark(s)

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

Which of the following is not a type of Microsoft Access database object?

1 Mark(s)

Table
Form
Worksheets
Modules

What is the difference between ‘open’ and ‘open exclusively’

1 Mark(s)

Open statement opens access database files and open exclusively opens database files of other program like oracle
Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
Both open and open exclusively are same
Open exclusive command does not exist in MS Access

Which of the following is a method to create a new table in MS Access?

1 Mark(s)

Create table in design view
Create table using wizard
Create table by entering data
All of above

Which of the following database object produces the final result to present?

1 Mark(s)

Forms
Reports
Queries
Tables

Which of the following is not a field type in access__________?

1 Mark(s)

Memo
Hyperlink
Ole object
Lookup wizard

Which field type can store photos?

1 Mark(s)

Hyperlink
Ole
Both of these can be used
Access tables can’t store photos

In table design view, which key can be used to switch between the field names and properties panels?

1 Mark(s)

F3
F4
F5
F6

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

1 Mark(s)

A doctor’s sign
Thin + sign
Outline rectangle
None of above

Which of the following statement is true?

1 Mark(s)

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

The default and maximum size of text field in access

1 Mark(s)

50 and 255 characters
8 and 1 gb
266 characters & 64000 characters
None of above

What do you mean by one to many relationship between student and class table?

1 Mark(s)

One student can have many classes
One class may have many student
Many classes may have many students
Many students may have manu classes

Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command?

1 Mark(s)

File menu
View menu
Database menu
Tools menu

When entering field name, how many characters you can type in maximum?

1 Mark(s)

60
64
68
Any number of character

Queries in access can be used as_________?

1 Mark(s)

View, change and analyze data in different ways
A source of records for forms and reports
Only a
Both a and b

Which of the following database object hold data?

1 Mark(s)

Forms
Reports
Queries
Tables

What are the columns in a Microsoft Access table called?

1 Mark(s)

Rows
Records
Fields
Columns

Which of the following store command to retrieve data from database?

1 Mark(s)

Forms
Reports
Queries
Tables

What is a form in MS Access____________?

1 Mark(s)

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

GCOM-Microsoft Access Test -19 : Question 1 of 20