MIS Access Questions

How does Access store a "Yes" response for the Yes/No data type? −2 −1 0 1 2

-1

The maximum size of a Short Text field is: 255 characters. 64 characters. Unlimited characters. 96 characters. 244 characters.

255 characters

You need to design a new Access database. The first step is to organize the smallest to largest data, also called: A. Alphabetical design. B. Detail structure. C. Data design. D. Hierarchy of data. E. Logical order.

D. hierarchy of data

The formula for a calculated field is in which of the following formats: FieldName:Expression FieldName:Constant FieldName:Generic FieldName:Default FieldName:Calculation

FieldName: Expression

Access provides a variety of pre-built procedures that perform specific tasks and are called: Database formulas. Functions. Expressions. Filters. Criteria.

Functions

This convenient Access feature steps you through the process of quickly creating a report. Report Designer Report Template Report Wizard Report view Report layout

Report wizard

Which of the following symbols must you use when defining a parameter query? ( ) [ ] { } / / " "

[ ]

In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called: An entity. A cell. A field. A row. A fact.

a field

An Access object you can use to create an interface to easily view, add, update, and delete data in a database is called: A summary. A report. A query. A table. A form.

a form

​An object you can use to create an organized and professional output of the data is called: A report. A form. A query. A table. A summary.

a report

A pre-designed database that contains various pre-built objects is called: A template. A form. A layout. A table. A key.

a template

When used in an expression, the asterisk (*) represents any string of characters and is also called: A generic symbol. A placeholder. A wildcard character. A star 8. A universal locator.

a wildcard character

The last row in an Access table is called the: Append Row. Auto Row. Selector Row. Hanging Row. Exit Row.

append row

Click this tab to move a control in a report from one part of the layout to another. Shift Select Highlight Arrange Replace

arrange

This control is used to perform an action such as Close Form, Open Form, Delete Record, etc.: Command Button Master Control Input Box Label Control Check Box

command button

If you need to find both a particular product type AND a price, you can do this through: compound criteria. double entry. find fields. related records. contiguous cells.

compound criteria

​To help focus your viewer's attention to certain records in a report, use: Conditional formatting. Format highlights. Custom expressions. Filters. Value rules.

conditional formatting

In Access, the fields, labels, buttons, and so forth are all known as: Tools. Controls. Data input. AddOns. Widgets.

controls

Which of the following tabs do you use to create a query? File Home Create Database Tools Layout

create

Which of the following is used to enter records into a table? Datasheet view Design view Lookup view Validation view Object View

datasheet view

When you want to add fields to a query that you have created, put the fields into the: Form Wizard. Design grid. Field Guide. Query window. Table.

design grid

When you need to change field properties in an existing table, open: Datasheet view. Field view. Database Tools. Design view. A new table.

design view

When you need to create a new table from scratch in your database, use: Design view. Datasheet view. Lookup view. Table view. Object view.

design view

Which of these should be used to write criterion for a query? Criterion composer Like comparison Wildcard symbols Expression Formula

expression

When you set field properties, the available properties vary based on the: Field length. Field target type. Field name. Field data type. List properties.

field data type

When you limit entries to a certain range of values or make sure entries match a specified format, you use: Field Validation rules. Datacheck. Parameters. Access rules. Navigators.

field validation rules

When you want to view only certain database fields such as product type, use this function: Sort Filter Find Data view Enable content

filter

The field in common between two tables is called the: Common denominator. Identifier. Linking field. Foreign key. Memo field.

foreign key

When you need to create an interface to view, add, update, and delete data in Access, you should use a: Form. Query. Report. Worksheet Layout.

form

Which of the following properties indicates the way a field displays in a table? Format property Lookup property Required property Caption property Cell property

format property

To add a date and time to your report, go to: Header/Footer Print Preview Grouping Properties Application Parts

header/ footer

When you first open a table in Datasheet view, Access uses the first field to sort the data records: Alphabetically. In descending order. In ascending order. By most recent entry. By oldest entry.

in ascending order

Which of the following must you do before adding a field between existing fields? Enter a field name in the field list. Enter a data type. Select a primary key. Insert a new row in the field list. Insert a new column in the field list.

insert new row in the field list

When entering a criterion expression, which of the following tools helps suggest a list of possible values? Query Design Wizard Parameter query Aggregate function Expression match IntelliSense

intelliSense

In this view, you can alter the design of a form and see the effects of the changes in real time. Form view Layout view Backstage view Table view Report view

layout view

This operator can help you find records containing data that is similar to the criterion value: Like comparison Parameter value Dialog box Custom Filter Expression

like comparison

The overall descriptions about what the different data fields represent and their formats is called: Details. Validation. Metadata. Summary. Primary data.

meta data

Tables and forms are examples of database: Entities. Reports. Entries. Objects. Views.

objects

​Which of the following requires you to enter the specific criteria value when you run the query? Simple query Summary query Parameter query Expression Builder Exact query

parameter query

In a database, the special field that contains a unique value for each record is the: Primary field. ID type. Product number. Master cell. Primary key.

primary key

Which of the following contains a unique value for each record? primary key lookup field input mask metadata cell number

primary key

To ensure that your report prints as desired, review it in: Layout view. Design view. Backstage view. Print Preview. Page Setup.

print preview

Which of the following finds data in your database by allowing you to ask a question? calculated field compound criteria query parameter filter

query

In Access, the most common way to create queries is with: Datasheet view. Query Design. Field Layout. Query Setup. Form Design.

query design

The property which specifies that a user must enter a value in a field is called: Mandatory. Complete. Required. Primary. Limited.

required

Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text? Sans serif Unicode Rich Text Font style Editable type

rich text

To see the results of a query, you need to click: Seek. Go. View. Run. Solve.

run

​​​In Access, the most common type of query is a: Select query. Custom query. Basic query. Object query. Form query.

select query

To make the data contained in a report easier to read and understand, a good option is: Arranging. Highlighting. Sorting. Stacking. Tabulating.

sorting

This form option lets you view data in two ways on the same form by combining both a columnar display and a datasheet display. Freeze Pane Alt+Tab Window view Design view Split Form

split form

Each major subject or grouping of information you will store in your database should have a separate: Form. Row. Sheet. Column. Table.

table

Access is a relational database, which means that the data are organized into a collection of related: Workbooks. Datasheets. Tables. Fields. Pages.

tables

This report layout displays the fields in a table (row and column) format: Stepped Compact Tabular Delimited CSV

tabular

Which of the following displays the contents of a field and also allows the user to type a value into that field? Input field Lookup field Text box Input mask Combo box

text box

When importing data records from Excel, which of these must be true? The Excel file must have been created by the same user. The Excel file must contain the same number of fields as in the Access file. The first row of the Excel file must contain the same number of fields as in the Access table. The Excel fine must be delimited. The first row of the Excel file must contain the field names from the Access table.

the first row of the excel file must contain the field names from the access table

This option in the Group, Sort, and Total pane changes the wording in the label of the grouping field. Rename Title Define Field Data Ungroup

title

A form that contains no data but has buttons that perform different actions is referred to as: Bound. Unbound. Linked. Autonomous. Utilitarian.

unbound

Set the following property in order to have Access evaluate the fields in the query and avoid including duplicated values: Parameter Filter Unique Values Match=Null Exact Return

unique values

If you change the Required property of a field from No to Yes, Access: Deletes the empty fields. Flags the empty fields. Accepts the change without error. Automatically runs a data integrity test. Warns that data integrity rules have changed.

warns that data integrity rules have changed

If any of your database columns display the ###### symbols, you need to: Delete the contents. Widen the column. Reformat the text. Change to Design view. Change to Data view.

widen the columns