access 2013

profilevivinana8591

Top Frame TabsTab List tableHomeTab 1 of 3 (active tab)My CoursesTab 2 of 3How to VideosTab 3 of 3

 

Current Location

 

Introduction to ComputersCGS1000CG3-A10262015 

 

 Week 3 Take Test: 2013 Access test

 

Menu Management Options

 

Course Menu:

 

Introduction to Computers (CGS1000CG3-A10262015)

 

Meet Your InstructorHomepageSyllabusStudent ResourcesProgram ResourcesDiscussionKeiser Live!EmailStart HereWeek 1Week 2Week 3Week 4GradebookGroupsToolsHelp

 

Take SurveySurvey Keiser University Survey Undergrad - C15FC-1M has been made available to this course. Only one submission will be accepted per respondent.

 

Take Test: 2013 Access test 

 

ContentAssistive Technology Tips [opens in new window]

 

Test Information

 

InstructionsDescriptionInstructionsTimed TestThis test has a time limit of 1 hour.This test will save and submit automatically when the time expires.

Warnings appear when half the time, 5 minutes, 1 minute, and 30 seconds remain.Multiple AttemptsNot allowed. This test can only be taken once.

 

Remaining Time: 58 minutes, 57 seconds.

 

 Question Completion Status:

 

 

 

Question 1

 

Which view does not display the data, but allows you to change the field properties?

 

Datasheet view

 

Form view

 

Design view

 

Layout view

 

  

 

Question 2

 

Constants, functions, operators, and identifiers are combined to create this. 

 

Formula

 

Action query

 

Expression

 

Control

 

   

 

Question 3

 

This view displays exactly how a report will look when printed and can be used to modify the page layout.

 

Layout view

 

Design view

 

Print Preview

 

Reading view

 

 

 

Question 4

 

The 348 area code has been changed to a new 704 area code. To quickly update all your records, use this feature. 

 

Drag and Drop

 

Hide and Seek

 

Cut and Paste

 

Find and Replace

 

 

 

Question 5

 

A symbol or word in an expression that indicates the operation to be performed is called a: 

 

variable

 

operator

 

value

 

symbol

 

   

 

Question 6

 

You can change the column order in a query datasheet by: 

 

choosing Edit/Columns/Order

 

choosing Format/Display Order

 

using drag and drop

 

right-clicking the column header and choosing Move

  

 

Question 7

 

The smallest unit of information about a record in a database is called a: 

 

query

 

field

 

cell

 

record

 

  

 

Question 8

 

If you want your database to perform optimally, you should do this on a regular basis.

 

Restart it

 

Re-format it

 

Clean it

 

Compact it

 

   

 

Question 9

 

Which of the following is NOT an example of a comparison operator? 

 

*

 

=

 

>

 

<>

 

   

 

Question 10

 

The Page Up and Page Down keys can be used to move between ________ in a form.

 

fields

 

New (blank) records

 

records

 

controls

 

   

 

Question 11

 

This data type is a unique, sequential number that is automatically incremented by one whenever a new record is added to a table

 

Number

 

Linked Number

 

Field Number

 

AutoNumber

 

  

 

Question 12

 

A _____ establishes the association between common fields in two tables. 

 

line

 

hyperlink

 

relationship

 

ScreenTip

 

   

 

Question 13

 

Which of the following CANNOT be accomplished using a query? 

 

viewing data in different ways

 

creating new data

 

analyzing data

 

changing existing data

 

   

 

Question 14

 

Which of the following report-building methods guides you through step-by-step? 

 

Report Tool

 

Blank report Tool

 

Report Design

 

Report Wizard

 

 

 

Question 15

 

A request for specific data contained in a database is called: 

 

Sort

 

Filter

 

Criteria

 

Query

 

  

 

Question 16

 

This database object is used to make displaying and changing records easier.

 

Query

 

Report

 

Table

 

Form

 

  

 

Question 17

 

The Sales Person table contains one record for each sales person. The related Client table contains one record for each client. A particular sales person is assigned to several clients records but each of the clients only have one sales person. This is an example of a ________ relationship. 

 

one-to-many

 

many-to-many

 

one-to-one

 

parent-to-child

 

   

 

Question 18

 

This object must be created first, before any other types of objects are created, since it is the basic unit of a database.

 

Table

 

Query

 

Report

 

Form

   

 

Question 19

 

The professional-appearing output generated from tables or queries is called: 

 

Record

 

File

 

Report

 

Form

 

 

 

Question 20

 

A field name can be up to ___ characters. 

 

16

 

32

 

64

 

128

 

 

    • 8 years ago
    • 8
    Answer(1)

    Purchase the answer to view it

    blurred-text
    • attachment
      acess_vivi.docx