SCI2009 AccessIntermediate by HC120808215728

VIEWS: 0 PAGES: 11

									Access Intermediate


Phil Pratt and Mary Last
                Access Topics
Creating Reports and Forms
• Layout View

Creating Multi-Table Forms
• Using Yes/No, Date, Memo, OLE Object, Attachment and
Hyperlink data types

Using Macros, Switchboards, PivotTables,
PivotCharts
Understanding SQL
            Teaching Tips
• Live Application
  – Microsoft Access 2007
• Slide Show
  – Figures on CD-ROM
• Combination
  – Switching between the two
             Resource Tips

• Use the Instructor’s Manual
  – Teaching tips
  – Classroom activities
  – Lab activities
  – Quick quizzes
• Data and solution files
• Chapter reinforcement
  exercises
       Engage Your Students
• Minimize Point and Click
• Maximize Interaction
  – Question and Answer
  – Experiment
• Improve Problem Solving Skills
  – Project Planning Guidelines
  – Plan Ahead
• Integrate Concepts
  – Database Design
      Challenge Your Students

•   Apply Your Knowledge
•   Extend Your Knowledge
•   Make It Right
•   In the Lab
•   Cases and Places
•   Collaboration
       Assess Your Students
• Assign projects
  – Personalize it
  – Group work
  – Learn It Online
  – Emphasize Concepts
  – Reflection/Critique
• Rubrics and annotated solution files
• Test bank
• Lab tests
              Grading Tips
•   Use digital dropbox
•   Copy query results (Word, OneNote)
•   Add name to form header
•   Add name to report footer
•   Add initials to table names
•   Use last name for database
•   Document properties
          Troubleshooting Tips

•   Network printer
•   Printer fonts
•   Wizards not installed
•   Graphics filters
•   Incorrect relationships
•   Compacting
Idea Exchange




What do you do?

								
To top