Comp Applications

Front 1

Compare the features available in Access to the features available in Excel.

Back 1

Excel/Access
~Layout~
-->provides natural tabular layout for easy data entry
-->provides natural tabular layout AWA ability to create customized data entry screens

~Storage~
-->limited to 65,000 records per sheet
-->stores any # of records up to 2GB

~Linked Tables~
-->manages single lists of info
-->allows links betw. lists of info to reduce data redundancy

~Reporting~
-->limited to current spreadsheet arrangement of data
-->creates and saves multiple presentations of data

~Security~
-->limited to file security options SA marking file “read-only” or protecting a range of cells
-->allows users to access only the records and
fields they need

~Multi-user Capabilities~
-->does not easily allow multiple users to simultaneously enter and update data
-->allows multiple users to simultaneously enter and update data

~Data Entry~
-->provides limited data entry screens
-->provides ability to create extensive data entry screens called forms

Front 2

What Access object provides an easy-to-use data entry screen?

Back 2

Form

Front 3

In Navigation mode, press [Tab] or what keystroke to move to the next field within the same record?

Back 3

[Enter] or [-->]

Front 4

What key/s will help you delete unwanted data in Edit mode?

Back 4

[Backspace] or [Delete]

Front 5

What keystroke combination inserts the data from the same field in the previous record into the current field?

Back 5

[Ctrl][‘]

Front 6

While editing a record, what does pressing [Esc] once accomplish?

Back 6

Undoes the change to the current field

Front 7

Which editing keystrokes switches to Edit mode from Navigation mode?

Back 7

[F2]

Front 8

What Help menu option analyzes a database for possible data corruption?

Back 8

Detect and Repair

Front 9

How many characters will a Memo data type field store?

Back 9

up to 65,535 characters

Front 10

Which data type should be used for a birthdate field?

Back 10

Date/Time

Front 11

What data type is used to sequentially order each record added to a table?

Back 11

AutoNumber

Front 12

What does the descending and ascending sort buttons all perform?

Back 12

Sort Ascending: sorts records based on the selected field in ascending order (0-9, A-Z)

Sort Descending: sorts records based on the selected field in descending order (Z-A, 9-0)

Front 13

The wildcard character that stands for a single number digit is …?

Back 13

Pound Sign (#)

Front 14

What are operators and what functions do they serve in Access?

Back 14

Comparison Operators: Characters SA > and < that allow you to find and filter data based on specific criteria.

Front 15

Identify the following in

query selection process Criteria cells,
datasheet view,
field list,
and the design grid.

Back 15

~Query: a database object that creates a datasheet of selected fields are records from one or more tables

~Criteria: rules or limiting conditions you set

~Datasheet View: a view that lists the records of the object in a datasheet

~Field List: a list of the available fields in the table or query that it represents

~Design Grid: (Query Design Grid) the bottom pane of the Query Design View window in which you specify the fields, sort order, and limiting criteria for the query

Front 16

What control is used to display “yes” or “no” answers for a field?

Back 16

Check Box: display “yes” or “no” answers for a field; if the box is checked, it means “yes”

Toggle Button: display “yes” or “no” answers for a field; if the button is pressed, it means “yes”

Front 17

What control is used to provide consistent descriptive text as you navigate from record to record?

Back 17

Label

Front 18

What control is used to display OLE data?

Back 18

Bound Object Frame

Front 19

What would you most likely use to display a Yes/No field on a form?

Back 19

Check Box

???

Front 20

After making modifications in Form Design View, click the … View button to view the form and enter data

Back 20

Form View

Front 21

Click the … button in Form Design View to open the properties sheet for the chosen control

Back 21

Properties Button

???

Front 22

Determine what would NOT be considered a graphic image when setting up a form?

Back 22

examples of Graphic Images: pictures, logos, clip art

examples of Non-Graphic Images: (other)

Front 23

What would be some common uses for an Access report?

Back 23

used to create professional printouts. multiple fonts and colors, extra graphical elements SA clip art and lines, and multiple headers and footers. are also very powerful analysis tools. can calculate subtotals, averages, counts, or other statistics for groups of records

Front 24

What control is most commonly placed in the Report Header section?

Back 24

Label Controls

Front 25

A text box control that contained a grand total for all records would most likely be found in what report section?

Back 25

Report Footer

Front 26

In what location/section of a report would the

page header,
grouper header,
detail,
and report header most likely be found?

Back 26

Page Header: at the top of every page (but below the Report Header on pg. 1)

Group Header: before every group of records

Detail: once for every record

Report Header: at the top of the 1st page of the report

Front 27

What is an expression, in Access, and where would you find it?

Back 27

Expression: a combination of field names, operators (SA +, -, /, *) and functions that calculates a single value.

Access expressions start w/ an equal sign and are placed in a text box in either Form Design View or Report Design View.

Front 28

The Group Header and Group Footer section can be turned on or off in which dialog box?

Back 28

Sorting and Grouping dialog box

???

Front 29

What program is an integrated desktop information management program?

Back 29

Microsoft Office Outlook 2003

Front 30

What are some of the things you would not send using e-mail?

Back 30

Confidential or sensitive material

If your e-mail account is a company account, it’s a good idea to learn whether your company permits the sending of personal messages

Front 31

What are some of the different ways to connect to the Internet?

Back 31

If you have an Internet connection and communications software, you can connect your computer at home to the computers at your office. you can also sign up with an ISP (Internet service provider). You can connect to the Internet using a telephone line or other, faster technologies including satellite, DSL (Digital Subscriber Line) cable, ISDN (Integrated Services Digital Network), T1, or T3.

Front 32

What are some of the benefits of using electronic mail?

Back 32

~Provides a convenient and efficient way to communicate
~Allows you to send large amounts of information
~Lets you communicate with several people at once
~Ensures delivery of information
~Lets you communicate from a remote place
~Provides a record of communications
~Allows you to store information

Front 33

When composing e-mail messages it is not appropriate to use all capital letters because this is the e-mail equivalent of …?

Back 33

shouting

Front 34

If you want to be notified when the recipient of your message has read the message you must click the …

Back 34

[Request a read receipt for this message] check box

Front 35

When composing e-mail, what do the following icons refer to: Bcc, Cc, To?

Back 35

Bcc: (blind courtesy copy) is used when the sender does not want to reveal who he or she has sent courtesy copies to.

Cc: (courtesy copy) typically sent to message recipients who need to be aware of the correspondence between the sender and the recipients.

To: to whom you are sending the message

Front 36

Where would the address of a recipient be placed in order to be hidden from other recipients?

Back 36

Bcc

Front 37

Identify the following on the tool bar distribution list icon: send attachment icon and the address book icon.

Back 37

~Attachment: a file, SA a Word document, graphic image, or Excel spreadsheet, that is sent w/ an e-mail message

~Address Book: a collection of usernames and e-mail addresses you can access to quickly address an e-mail message

Front 38

Where can you edit the text of a presentation?

Back 38

Text Placeholders, Outline Tab

Front 39

Identify the following:

Standard Toolbar,
Menu Bar,
Formatting Toolbar,
and the Task Pane

Back 39

~Standard Toolbar: the toolbar containing the buttons that perform some of the most commonly used commands such as Cut, Copy, Paste, Save, Open, and Print

~Menu Bar: the bar below the title bar that contains the names of menus, that when clicked, open menus from which you choose program commands. menu bars can change depending on the view

~Formatting Toolbar: a toolbar that contains buttons for frequently used formatting commands

~Task Pane: an area located on the right side of the screen in each program that lets you complete common tasks

Front 40

What does the AutoContent Wizard do?

Back 40

The quickest way to create a presentation. A wizard is a series of steps that guides you thru a task. Using the AutoContent Wizard, you choose a presentation type from the wizard’s list of sample presentations. Then you indicate what type of output you want. Next, you type the information for the title slide and the footer. The AutoContent Wizard then creates a presentation with sample text you can use as a guide to help formulate the major points of your presentation.
AutoContent Wizard: a wizard that helps you get a presentation started by supplying a sample outline and a design template

Front 41

Which PowerPoint view has no view button?

Back 41

Notes Page

Front 42

To preserve the look of a presentation when it is opened on any computer, what should you do?

Back 42

You can save, or embed, the fonts in your presentation. Click File on the menu bar, then click Save As. The Save As dialog box opens. Click Tools, click Save Options, then click the Embed TrueType Fonts check box in the Save Options dialog box. Click Ok to close the Save Options dialog box, then click Save.

Front 43

Identify the following: the Outline Tab, Slides Tab, and the Title Bar.

Back 43

~Outline Tab: the section in Normal View that displays your presentation text in the form of an outline, without graphics

~Slides Tab: the section in Normal View that displays the slides of your presentation as small thumbnails

~Title Bar: the bar at the top of the program window that indicates the program name and the name of the current file, web page, or open folder

Front 44

Based on your knowledge of headers and footers, what are some of the things that would be appropriate footer text?

Back 44

the slide number, the date, your name

Front 45

In most cases, how many design templates would you apply to your presentation?

Back 45

one template to an entire presentation

Front 46

What are some of the common commands you can perform from the Formatting Toolbar?

Back 46

font, font size, bold, italic, underline, shadow, align left, center, align right, numbering, bullets, increase font size, decrease font size, decrease indent, increase indent, font color, slide design, new slide

Front 47

What can you find and replace in PowerPoint?

Back 47

replacing text and attributes

Front 48

Are you able to recolor a graphic object with the .tif file extension in PowerPoint?

Back 48

NO!!!

Front 49

Identify the difference between a

Data Series,
Data Label,
and a Data Series Marker in an embedded chart in PowerPoint.

Back 49

~Data Series: each column and row of data in the datasheet

~Data Label: information that identifies the data in a column or row in a datasheet

~Data Series Marker: a graphical representation of a data series, such as a bar or column

Front 50

Which axis does the Value axis represent?

Back 50

Vertical Axis