Transcript Microsoft Access Exam Review Project Guidelines

FINAL EXAM REVIEW
1
EXAM PROCEDURES
• 10 minutes to review project before starting
• 120 minutes to complete the exam, although
most students finish in 75-90 minutes
• In this presentation, suggested timing
guidelines are assigned to each step
– Use these as a guide to indicate how far along in
the project you should be at each step.
– Consider practicing and re-doing steps for which
you do not complete within the timing guideline.
2
10-MINUTE EXAM REVIEW
PERIOD
• Read the Background Information and
Project Statement sections of the
instructions.
• Look over the xml tables to get an idea of
what kind of data is being used in this project.
• The slides of this presentation will serve as a
guideline to completing the project.
• At the next slide, the clock starts. The slides
will automatically progress per the timing
guidelines.
Time: 10 minutes
3
STEP 1: DOWNLOAD XML FILES
• Access the XML files at the following URL:
http://cs101.wvu.edu/resources/exam
/review-projects/
• Exam review: Know how to download the
data files, and that if they are packaged, they
need to be unzipped.
• Keep these files handy! You’ll need them
later.
Time: 1 minute
4
MICROSOFT ACCESS
5
STEP 2: CREATE DATABASE
• Know how to launch Access and save a
new (blank) database with the given
name.
• Know how to use Save Database As
command if necessary.
Time: 1 minute
6
STEP 3: IMPORT XML FILES
• Know how to import XML files in Access.
• Be sure to verify the imported tables
briefly, by opening them up just to be sure.
• You cannot import XML files if they are still
in a zipped package. They must be
extracted first.
Time: 3 minutes
Points: 3 points
7
STEP 4: RELATIONSHIPS
• Know how to specify relationships
– Drag-and-drop fields to create relationship “lines”
• Instructions will indicate the tables of a relationship
– It’s up to you to understand what fields are
related!
– Relate fields of same data, (usually of same
name.)
• Problems here will lead to problems in your
queries!
Time: 3 minutes
Points: 5 points
8
STEP 5: QUERIES
Queries are important for completing whole test. Practice them!
1. Read over and select tables, fields.
2. Add Calculated Fields, using the Builder tool. Don’t forget about
Aliasing.
3. Need a Totals Row? Look for keywords such as sum, average,
number of.
4. Advanced features: Join Properties? Query-specific
relationships?
5. Use the Criteria Row to restrict results by specifying criterion. Be
able to use and and or criteria.
6. Format fields using the Property Sheet. May need to Run the
query first.
7. Sort results using Sort Row.
8. Run the query to test.
Time: 10 minutes
Points: 6 points each
9
STEP 6: FORM WIZARD
• Practice with the Form Wizard.
– Most important part is to select the right fields
from the right tables or queries.
• Don’t forget to name both the Form and SubForms, however.
Time: 4 minutes
Points: 5 points
10
STEP 7: REPORT WIZARD
• Don’t forget to name your report at the last
step of the report wizard.
• Read the NOTE in the Instructions: Use Layout
View to modify the column widths so all fields
are visible.
– Know how to do this! (Don’t waste time if you
are stuck.)
Time: 4 minutes
Points: 5 points
11
STEP 8: COMPACT & REPAIR
• Know how to Compact and Repair a
database.
– It is simply a menu option.
• After you click the menu option, Access
will need to save and close all open
objects.
Time: 1 minute
12
MICROSOFT EXCEL
13
STEP 9: CREATE WORKBOOK
• Know how to launch Microsoft Excel
• Know how to save your workbook and
supply the indicated filename.
Time: 1 minute
14
STEP 10: ADJUSTING SHEETS
• Excel workbooks come with three default
sheets
• Know how to work with sheets:
–
–
–
–
Creating new
Renaming
Deleting
Moving
• Also, understand how to navigate sheet tabs
Time: 2 minute
Points: 3 points total
15
STEP 11: IMPORT QUERY DATA
• Know how to Import an Access query
– Typically, will need to have your database closed.
(But make sure it is saved.)
– Know where you have saved your database.
• This step requires that your queries are
correct!
– If you need to go back and edit the query, you
need to close Excel first.
Time: 4 minutes
Points: 7.5 points total
16
STEP 12: FORMATTING CELLS
• Formatting covers a wide variety of topics
–
–
–
–
–
–
–
Insert text to a cell
Working with data tables, inserting table-columns
Formatting cells as certain number type
Applying styles, changing appearance, etc.
AutoFit cell width
Merging cells
Conditional formatting
Time: 2 minutes
Points: 5 points total
17
STEP 13: INSERT A CHART
• Know how to:
– Insert a standard chart
– Apply chart titles, labels (with descriptive
texts)
– Formatting values, rotating axes, etc
Time: 2 minutes
Points: 7.5 points
18
STEP 14: PIVOTCHARTS AND
PIVOTTABLES
• Understand:
– All PivotTables have an associated PivotTable
– How to create a new PivotChart and PivotTable
• Know how to work with PivotTables
– Adding to fields, summarizing figures
– Using the filters, and the “Group by” feature
• Know how to work with PivotCharts
– PivotCharts are charts, too
– Know how to work with chart labels, axis labels, etc
– Know how to format axes; rotating, etc
Time: 6 minutes
Points: 10 points total
19
MICROSOFT WORD
20
STEP 15: CREATE DOCUMENT
• This should not be a hard step.
– Launch Microsoft Word from Start Menu
– Know how to use Save As command
Time: 1 minute
21
STEP 16: INSERT A COVER PAGE
• Insert ribbon has this option
– Know where to find the option
– Style indicated on instructions
– Fill out the text boxes as indicated on
instructions
Time: 3 minutes
Points: 7.5 points
22
STEP 17: INSERT TEXT FILE
• Another copy-and-paste step:
– Know that you can just copy-and-paste the
contents, via opening the .txt file in notepad.
• See those “<>” symbols? They indicate
instructions for formatting the word document
in the next several steps.
– Know how to work with and apply the indicated
instructions.
Time: 3 minutes
Points: 5 points
23
STEP 18: INSERT CHART
• This should be an easy step too:
– Just copy-and-paste!
• Grab the chart from your Excel file by opening it up.
Need to right-click carefully to get a copy-option.
– Paste at the comment-instruction in your word file.
• Click the inserted chart for formatting options:
– Format ribbon for Size options
– Right-click the chart to add Captions
Time: 2 minutes
Points: 5 points
24
STEP 19: BIBLIOGRAPHY
• Bibliographies must have their source
bank populated prior to insertion.
– Use Source Manager to add sources first!
– Then, you can insert the bibliography, at the
proper place.
Time: 5 minutes
Points: 10 points total
25
STEP 20: FORMATTING
• This step entails a lot of different, similar things:
– Modifying Styles
– Adding, and working with Headers & Footers
• Inserting Page Numbers
• Know about the: Start from Page 0 Trick?
– Indenting Paragraphs, using Tab key
– Paragraph Dialog Box:
• Line spacing, before & after spacing
– Changing Margins of pages
– General tidying up: delete unneeded spaces
Time: 5 minutes
Points: 9.5 points total
26
MICROSOFT POWERPOINT
27
STEP 21: CREATE SLIDESHOW
• Another simple step:
– Know how to launch PowerPoint
– Know how to Save, or Save As
Time: 1 minute
28
STEP 22: ADD SLIDES
• Know how to add a slide
– Also, how to add slides of different type
• (Title, Title & Content, etc.)
• Insert charts from Excel
– You can just copy-and-paste the charts, in the
exact same way you did for Word.
Time: 3 minutes
Points: 9 points total
29
STEP 23: ANALYSIS QUESTIONS
• Analysis Questions are worth 20% of
your grade.
– Try to allot at least 12 minutes to do them
– You have 120 minutes on the Final Exam, so
you can afford to put them off, just this once
– But generally, if you’re behind, consider
prioritizing these!
• Answer one question per slide.
Time: 15 minutes
Points: 7.5 points each
30
STEP 24: FORMATTING SLIDES
• A topic with wide variety. Things to know:
– How to apply slide transitions
– How to add animations to objects
– Adding headers and footers
• Dates, slide numbers, footers
– Editing Slide Masters
– Inserting images and clip art
Time: 6 minutes
Points: 5 points total
31
SUBMIT YOUR PROJECT
• Finally, submit your files one at a time.
– Submit four different files!
• Be absolutely sure you do NOT submit the
wrong Microsoft Access database file; i.e.
with an L in the extension (*.*laccdb)
– The correct file is one with a name such as
filename.accdb
Timer: 2 minutes
32