R. Craig Collins >
BCIS 1305/ITSC 1309 >
Office Test 3 Review
Test 3 Review ©
R. Craig Collins, 2005/6
Please note, this test has more short essay and fill in the blank questions, requiring
mastery of this review
Access 1
- Define input, process, and output in database terms.
- Define rows and columns in database terms.
- Databases are composed of ...?
- Compare and contrast a database, and a DBMS
- What is the biggest difference between an Access starting window, and other
Office products?
- How do you design in control of redundancy? Basic validation?
- What are the recommended steps in creating a full database? Include relationships
and primary keys
- How To: Access Lab 7
- How
To: Access Lab 7 Tips table in design view, set key field, wizard to create
form to populate, create relationships, query criteria to retrieve, and report
Access 2
- Discuss queries
- What two areas in the design view of a query do most of the work?
- List the steps in creating a query
- What can go in a query? Logical operators text, numbers,
wild cards
- After you modify a query, how do you run it?
- Describe compound criteria (think search engines) AND,
OR, NOT
- If you save a query, what is actually saved?
- Why do some queries use calculator functions?
Access 3 (Only items covered in my lab, and chapter review, and discussion)
- Name a few ways to locate a record. form's [<]/[>],
query, etc
- Can a query ever change a table?
- Is a deleted record deleted? If so, when?
- Describe the pitfalls of restructuring a table
- Describe the pitfalls of changing field characteristics
- Can you change the contents of a cell? If so, how?
- Discuss various validation methods.
PowerPoint 1
- PowerPoint and Word share what basic foundation?
- Name two ways to add a new slide
- Name two ways to move in and out of the outline
- What is a transition?
- What is custom animation?
- What is a design template?
- Name at least three predetermined slide layouts
- Presentations are normally delivered using presentation software and ___?
- Name three ways to look at a ppt file, and mention the two options for the
editing window
- In this class, what four content slides should you include?
- Name at least three design tips
- Compare and contrast projection and printouts
- Describe at least three items that can be printed by PowerPoint
- Name two ways to start a presentation
PowerPoint 2
- Name several ways to customize a presentation?
- How can you alter a presentation, without really changing it? Think slide
sorter view.
- Compare and contrast transitions and custom animation.
PowerPoint Tips