GCOM-Microsoft Access Test -24

Which action will optimize your database performance?

1 Mark(s)

Set the record set type to snapshot
Use the compact and repair database tool
Create a replica of the database
All of the above

What is the first step in creating a form or report with the form wizard or report wizard?

1 Mark(s)

Selecting the fields that you want to appear in the form or report
Selecting the underlying table or query on which you want to base the form or repor
Reading several screens of mostly useless information and clicking next
Selecting how the form or report should be formatted

in a relational schema, each tuple is divided into fields called?

1 Mark(s)

Relations
Domains
Queries
All of the above

How can you add a table to the relationship window?

1 Mark(s)

Select tools>add table from the menu
Select the table from the table list on the toolbar
Click the show table button on the toolbar
Select edit>add table from the menu

what is a fast way t adjust the width of a column?

1 Mark(s)

Right click the left side of the column heading
Double click the left side of the column heading
Double click the right side of the column heading
Select tools>adjust column width from the menu

According to access help, what’s a good way to design a database?

1 Mark(s)

Start from data access pages and work backward
Sketch the design of your database using a pencil and paper
Use the table analyzer to reverse-engineer your flat source data.
None of above

which of the following terms does not describe a database structure used by a dbms to link data from several files?

1 Mark(s)

Relational
Structural
Network
All of the above

data items groped together for storage purposes are called a__________?

1 Mark(s)

Record
Title
List
String

In access, the best types of queries to use for data analysis are:

1 Mark(s)

Select queries
Parameter queries
Action queries
All of the above

how do you filter by selection?

1 Mark(s)

Right click the field value and select filter by selection from the shortcut menu
Find and double click the value on which you want to base the filter
Find and select the value on which you want to base the filter and select tools>filter by selection from the menu
None

the executive responsible for the data processing function in an organization is_________?

1 Mark(s)

Pm
Dbms
Dp
Dpm

which of the following is not a data type?

1 Mark(s)

Picture/graphic
Data/time
Texst
Number

a subset of characters within a data field is known as__________?

1 Mark(s)

Record
File
Data string
Byte

how do you update pivot table report data after changes are made to the source data?

1 Mark(s)

Save your changes, close the workbook, and then reopen it
Select the pivot table worksheet and press f9 on the keyboard
Click the report, and on the pivot table toolbar, click the refresh data button
All of the above

If a piece of data is stored in two places in the database, then

1 Mark(s)

Storage space is wasted
Changing the data is one spot will cause data inconsistency
It can be more easily accessed
Both a and b

the complete picture of data stored in database is known as__________?

1 Mark(s)

Record
Scheme
System flowchart
Dbms

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

1 Mark(s)

Queries
Workbooks
Forms
Tables

a file containing relatively permanent data is__________?

1 Mark(s)

Random file
Transaction file
Master file
Sequential file

what are the columns in a Microsoft Access table called?

1 Mark(s)

Rows
Fields
Cells
Records

The arranging of data in a logical sequence is called?

1 Mark(s)

Sorting
Classifying
Reproducing
Summarizing

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