COPA - Module 9 : Database Management Systems

What is the maximum number of characters allowed in text field is access?

• 255

• 256

• 64000

• 65000

Answer explanation

The maximum number of characters allowed in a text field is 255. This is the correct choice among the options provided.

What is the expansion of OLE in Access?

• object linking and embedding

• object linking and encrypting

• object linking and editing

• object linking and encapsulation

Answer explanation

The expansion of OLE in Access is object linking and embedding.

What is the maximum length of the field name in Access?

• 16 characters

• 32 characters

• 64 characters

• 128 characters

Answer explanation

The maximum length of the field name in Access is 64 characters, making it the correct choice out of the given options.

Which view is used to arrange table data in different graphical layouts to summarize data?

• Table view

• Design view

• Data sheet view

• Pivot chart view

Answer explanation

Pivot chart view is used to arrange table data in different graphical layouts to summarize data.

Which view allows to modify table’s structure in Access?

• Design view

• Datasheet view

• Pivot table view

• Pivot chart view

Answer explanation

Design view allows modifying a table's structure in Access, making it the correct choice.

Which object stores information about related data?

• Document

• Table

• Page

• Screen

Answer explanation

Tables store information about related data by organizing it into rows and columns, making it easy to access and manage the data efficiently.

Which key stoke is used to move the active cell towards right, in access table?

• Ctrl + Tab

• Alt + Tab

• Tab

• Shift + Tab

Answer explanation

To move the active cell towards right in an Access table, you can use the Tab key.

Which key stoke moves the active cell towards left in Access table?

• F2

• F5

• Tab

• Shift + Tab

Answer explanation

The correct key stroke to move the active cell towards left in an Access table is Shift + Tab.

Which combination of key zooms the content of active cell in Access table?

• Ctrl + F2

• Ctrl + F5

• Shift + F2

• Shift + F5

Answer explanation

The correct combination of keys to zoom the content of the active cell in an Access table is Shift + F2.

Which combination of key allows user to move to the first field in the first record in Access table?

• Ctrl + Tab

• Shift +Tab

• Shift + Home

• Ctrl + Home

Answer explanation

Ctrl + Home allows the user to move to the first field in the first record in an Access table.