·
It is a query that when run displays its own
dialog box prompting you for information, such as
a. Select
b. Crosstab
c. Parameter
d. Append
·
It is used to calculate and restructure data
for easier analysis of your data. It calculates the sum,
a. Parameter
b. Select
c. Crosstab
d. Append
·
It is a sign or symbol that specifies,
operator, and values that produce a result
a. Operator
b. Query
c. Expression
d. None of the above
·
Which of the following database object is
created first before any other created?
a. Table
b. Form
c. Report
d. Query
·
This
type of database contains multiple tables that are connected to produce
combined output from all tables.
a. Bound
b. Linked
c. Relational
d. Joined
·
The ‘filter by selection’ allows you to filter
those records
a. That match the selected
field
b. That match the criteria
specified
c. That meet any of several
criteria specified
d. All of above
·
The operation of checking input data against
specified criteria is known as?
a. Data verification
b. Data validation
c. Cross check
d. Data control
·
Some
rules are set in databases to check and permit only correct values. What is
this feature called?
a. Data verification
b. Auditing
c. Data filtering
d. Data validation
·
Database access levels are specified so as to
define who can access what in a database. It is identified through
a. User id
b. Password
c. Status
d. None of above
·
What it is called to present information in a
particular order based on numeric or alphabetical value?
a. Sorting
b. Searching
c. Arranging
d. Cropping
·
A collection of related records in database is
known as a
a. Table
b. Database
c. File
d. None of above
·
A part of database that stores complete
information about an entity such as employee, sales, orders etc.
a. File
b. Record
c. Field
d. Query
·
To create this, you enter an expression in the
design grid that instructs access to perform a calculation using the current
field values.
a. Formulated field
b. Numeric field
c. Formula field
d. Calculated field
·
The ascending order of data hierarchy is?
a. Bit – byte – field –
record – file – databse
b. Bit – byte – record –
field – file – database
c. Byte – bit – field –
record – file – database
d. Bit – byte – field –
record – database – file
·
Which of the following database object can be
used if you need to mail the invoice to customers?
a. A form
b. A query
c. A report
d. A table
·
When creating an input mask this character
does not require an entry, but if an entry is made it must be a letter from a-z
a. ?
b. !
c. #
d. \
·
In access, this displays the results of a
calculation in a query
a. Lookup field
b. Calculated field
c. Source field
d. Child field
·
In access, this operation copies a backup file
from the storage medium back onto the computer
a. Recreate
b. Restore
c. Copy
d. Structure
·
If you make an invalid entry in the input mask
wizard dialog box, this will display to advise you that the entry is not
correct
a. Text error
b. Validation error
c. Literal error
d. Entry error
·
In the form wizard dialog box, the fields from
the selected table are displayed in this list box.
a. All fields
b. All records
c. Available records
d. Available fields
·
This form displays the field name labels down
the left side of the column, with the data for each field just to the right of
its corresponding label.
a. Tabular
b. Justified
c. Columnar
d. Datasheet
·
This
form displays data in a table layout with field name labels across the top of
the page and the corresponding data in rows and columns under each heading.
a. Columnar
b. Justified
c. Datasheet
d. Tabular
·
This
form displays multiple records, one per row, in the form window
a. Datasheet
b. Tabular
c. Columnar
d. Justified
·
In this
form, a single record may appear in multiple rows in the form window in order
to fully display the field name label and data.
a. Datasheet
b. Tabular
c. Justified
d. Columnar
·
Which of the following is not a form style
available in the form wizard dialog box.
a. Blends
b. Standard
c. Stone
d. Highlights
·
You can move between fields in a form by using
any of these keys except
a. Tab
b. Enter
c. Shift+tab
d. Page up
·
Queries are based on this, allowing you to use
a query as the source for forms and reports
a. Filters
b. Tables
c. Records
d. Fields
·
This type of query summarizes large amounts of
data in easy-to-read, row-and-column format.
a. Crosstab
b. Columnar
c. Select
d. Action
·
Which of the following is not one of the
methods available in the new query dialog box to create queries?
a. Design view
b. Crosstab query wizard
c. Simple query wizard
d. Datasheet view
·
This query wizard will create a select query.
a. Crosstab
b. Find duplicates
c. Simple
d. Design view
·
The quickest way to add a field to the
selected fields list is to double-click its field name in this list.
a. Find fields
b. Search fields
c. Search record
d. Available fields
·
The result of a query is displayed in a
a. Record
b. Query datasheet
c. Query table
d. Form
·
Changing the order of this in the query
datasheet does not affect the field order in the table.
a. Record
b. Row
c. Column
d. Sort
·
In the second subform wizard dialog box you
specify the table to use as the data source and the
a. Records from the selected
form
b. Form from the selected
table
c. Fields from the selected
table
d. Content from the selected
form
·
This is not one of the sections of the form
design window
a. Form footer
b. Form content
c. Form header
d. Form detail
·
When you select this control, its associated
text control is also selected and the two controls will act as one when
manipulated.
a. Text
b. Form
c. Label
d. Field
·
In access, this view is used to create and
modify the structure of a form.
a. Normal
b. Datasheet
c. Form design
d. Control
·
To set a password for the database, select
____________ in the Microsoft Access open window.
a. Open read only
b. Open write only
c. Open explicit
d. Open exclusive
·
To enter the input mask wizard
a. Click on the three dots
to the right of the caption entry field
b. Click on the three dots
to the right of the format entry field
c. Click on the input mask
toolbar
d. Click on the three dots
to the right of the input mask entry field
·
Saving a database in access is done
a. At the beginning of the
database
b. The first time you save
data
c. When closing the
application
d. During auto save
·
The file extension for an access 2003 database
is
a. Exe
b. Doc
c. Exc
d. Mdb
·
Which
of the following best describes the grouped report?
a. A part of report that can
be generated by the report wizard
b. A report that displays
data that has been sorted in ascending or descending order
c. A report that displays
data grouped by fields you specify
d. None of a the above
·
What is the use of description field in table
design window?
a. The description will be
displayed on status bar when entering data in datasheet view
b. The description will be
displayed on status bar when entering data in form
c. Both of above
d. None of a the above
·
How can you display the related records from other
tables in datasheet view?
a. Click on the expand
indicator next to the record
b. Double click on the
record to expand it
c. Apply filter by command
to display related records
d. All of above
·
Which of the following query type is best
suitable to analyze data?
a. Cross tab queries
b. Parameter queries
c. Action queries
d. None of above
·
Which of the following is a database
management system?
a. Ms word
b. Ms excel
c. Oracle
d. Lotus 1-2-3
·
In relational database schema each tuple is
divided into fields known as?
a. Relations
b. Queries
c. Records
d. Domains
·
Which of the following columns does not exist
in macro design window?
a. Arguments
b. Comments
c. Conditions
d. Actions
·
What is the type of query that extracts data
from a table and puts them into separate table?
a. Parameter query
b. Make table query
c. Update query
d. Put table query
·
What
type of control in a form can display data from database table?
a. Bound control
b. Unbound control
c. Both of above
d. None of above
·
To display value from table for a label
control
a. Set teh control source
and record source prom property panel
b. Choose the databse,
table, field and select data value to display
c. Look at the table and
type value in the caption
d. Set the record source
property and then control source
·
Which of the following is not a section in
report design window?
a. Report header section
b. Page header section
c. Summary section
d. Report footer section
·
You can not import data into access database
from
a. Dbase iii database files
b. Excel spreadsheets
c. Comma delimited text
files
d. None of the above
·
Which control does access use to link data
access page components to Access data?
a. Microsoft dynamic data
control
b. Microsoft data connection
control
c. Microsoft office data
source control
d. None of the above
·
which program do you use to edit code for data
access pages?
a. Microsoft script editor
b. Microsoft code editor
c. Microsoft data access
pages editor
d. None of above
·
the way a particular application views the
data from the database that the applicaton uses is a
a. Module
b. Relational model
c. Schema
d. Sub-schema
·
which of the following is a database
management system?
a. Ms-word
b. Lotus 1-2-3
c. Oracle
d. None of above
·
what is
the corresponding text for the <#1/1/95# validation rule setting?
a. Neter a value less or
more than 1,195
b. Value must be less than
95 characters
c. Enter a date before 1995
d. All of above
·
what is the name of the visual basic editor
utility that allows you to view the Microsoft Access type library’s available
objects and members?
a. Object viewer
b. Object browser
c. Type library spy
d. None of above
·
a computer language for informing the dbms
regarding the data structure used is
a. Pascal
b. Ddl
c. Prolog
d. Fortran
·
which
of the following is not a data type
a. Picture/graphic
b. Data/time
c. Texst
d. Number
·
the executive responsible for the data
processing function in an organization is
a. Pm
b. Dbms
c. Dp
d. Dpm
·
which of the following is not a type of
Microsoft Access database object?
a. Queries
b. Workbooks
c. Forms
d. Tables
·
a file containing relatively permanent data is
a. Random file
b. Transaction file
c. Master file
d. Sequential file
·
the complete picture of data stored in
database is known as
a. Record
b. Scheme
c. System flowchart
d. Dbms
·
a subset of characters within a data field is
known as
a. Record
b. File
c. Data string
d. Byte
·
data
items groped together for storage purposes are called a
a. Record
b. Title
c. List
d. String
·
which of the following terms does not describe
a database structure used by a dbms to link data from several files?
a. Relational
b. Structural
c. Network
d. All of the above
·
in a
relational schema, each tuple is divided into fields called
a. Relations
b. Domains
c. Queries
d. All of the above
·
how do you filter by selection?
a. Right click the field
value and select filter by selection from the shortcut menu
b. Find and double click the
value on which you want to base the filter
c. Find and select the value
on which you want to base the filter and select tools>filter by selection
from the menu
d. None
471. what is a fast way t
adjust the width of a column?
a. Right click the left side
of the column heading
b. Double click the left
side of the column heading
c. Double click the right
side of the column heading
d. Select tools>adjust
column width from the menu
·
what
are the columns in a Microsoft Access table called?
a. Rows
b. Fields
c. Cells
d. Records
·
how do you update pivot table report data
after changes are made to the source data?
a. Save your changes, close
the workbook, and then reopen it.
b. Select the pivot table
worksheet and press f9 on the keyboard
c. Click the report, and on
the pivot table toolbar, click the refresh data button
d. All of the above
·
In access, the best types of queries to use
for data analysis are:
a. Select queries
b. Parameter queries
c. Action queries
d. All of the above
·
How can you add a table to the relationship
window?
a. Select tools>add table
from the menu
b. Select the table from the
table list on the toolbar
c. Click the show table
button on the toolbar
d. Select edit>add table
from the menu
·
What is the first step in creating a form or
report with the form wizard or report wizard?
a. Selecting the fields that
you want to appear in the form or report
b. Selecting the underlying
table or query on which you want to base the form or report
c. Reading several screens
of mostly useless information and clicking next
d. Selecting how the form or
report should be formatted
·
Which action will optimize your database
performance?
a. Set the record set type
to snapshot
b. Use the compact and
repair database tool
c. Create a replica of the
database
d. All of the above
·
The arranging of data in a logical sequence is
called
a. Sorting
b. Classifying
c. Reproducing
d. Summarizing
·
According to access help, what’s a good way to
design a database?
a. Start from data access
pages and work backward
b. Sketch the design of your
database using a pencil and paper
c. Use the table analyzer to
reverse-engineer your flat source data.
d. None of above
·
If a piece of data is stored in two places in
the database, then a
a. Storage space is wasted
b. Changing the data is one
spot will cause data inconsistency
c. It can be more easily
accessed
d. Both a and b
·
A relational database management (RDBMS)
package manages data in more than one file at once. How does it organize these
file? As
a. Tables
b. Relations
c. Tuple
d. Both a and b
·
Which of the following database objects asks a
question of information in a database and then displays the result?
a. Tables
b. Reports
c. Queries
d. Forms
·
What data type should yo choose for a zip code
field in a table?
a. Text
b. Number
c. Memo
d. All of above
·
In order to use dbms, it is important to
understand
a. The physical schema
b. All sub schemas that the
sytem supports
c. One sub schema
d. Both a and b
·
A list consists of last names, first names,
address and pin codes if all people in the list have the same last and the same
pin code, a useful key would be
a. The pin code
b. The last name
c. A compound key consisting
of the first name and the last name
d. All of the above
·
What happens when you add the asterisk (*)
from any field list ot a query?
a. The table will not
include any fields from the table
b. The query sorts the
table’s record in the order you specify
c. The query will include
every field from the table
d. The query uses the
records from the table without displaying them
·
Which
editor was provided for use with access basic?
a. The visual basic 1.0
editor
b. Notepad
c. The quickbasic editor
d. All of above
·
The filter by selection feature allows you to
filter:
a. Those records that match
an entity in a field
b. Records based on a
criterion you specify
c. Records that meet any of
several criteria you specify
d. All of above
·
What is the memo data type field used for?
a. To add table
b. To store objects created
in other programs
c. For long text entries
d. For shout text entries of
no more than 255 characters
·
What is the purpose of the description column
in table design view?
a. To define the data type
applied to each field within the table
b. To describe the data that
should be entered in each field
c. To enter lookup data that
the field should refer to.
d. None of the ablve
·
What is the propose to a sub datasheet?
a. To provide a hierarchial
view of related tables or queries in a single window
b. To display grouped data
in a report
c. To display summarized
data.
d. All of the above
·
Which of the following is not a selection
technique
a. To select a word, double
click the word
b. To select an entire table
click the empty bosx to the left of the field names
c. To select a row, click
the record selector box to the left of the row
d. To select a column,
double click anywhere in the column
·
How can you display pivot table report summary
data in a currency format?
a. Use custom calculation
b. Type in the currency
symbol
c. Modify the field settings
d. None of the above
No comments:
Post a Comment