Microsoft Access

Which one is not a valid data type in MS Access? Picture

MS-Access is program for______: Database

We can remove a relationship defined between two tables by______: Selecting the relationship line and press Delete

A search value can be an exact value or it can be______: Wild card character

Both conditions display on the same row in the design grid when ______ operator is in use: AND

The two form layout types will display multiple records at one time are tabular and______: Justified

The ______ operator will cause a record to be selected only if two or more conditions are satisfied: And

When a picture or other graphic image is placed in the report header section it will appear______: Once in the beginning of the report

To duplicate a control’s formatting you can use______: Painter

The ______ button on the toolbox displays data from a related table: Subform/Subreport

Which database object can be used if you need to mail the invoice to customers? A report

In Access, ______ displays the results of a calculation in a query: Calculated field

In Access, ______ operation copies a backup file from the storage medium back onto the computer: Restore

What is the maximum length a text field can be? 255

Which is not a database object? Relationships

What are the columns in a Microsoft Access table called? Fields

Which is not a type of Microsoft Access database object? Worksheets

Which stores command to retrieve data from database? Aes

Which database object produces the final result to present? Reports

Which 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

To create a new table, in which method you don’t need to specify the field type and size? Create table by entering data

When creating a new table which method can be used to choose fields from standard databases and tables? Create table using Wizard

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

The default and maximum size of text field in Access is______: 50 and 255 characters