110 likes | 210 Views
Access Intermediate. Phil Pratt and Mary Last. Phil Pratt. 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
E N D
Access Intermediate Phil Pratt and Mary Last
Phil Pratt 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
Live Application Microsoft Access 2007 Slide Show Figures on CD-ROM Combination Switching between the two Teaching Tips
Use the Instructor’s Manual Teaching tips Classroom activities Lab activities Quick quizzes Data and solution files Chapter reinforcement exercises Resource Tips
Minimize Point and Click Maximize Interaction Question and Answer Experiment Improve Problem Solving Skills Project Planning Guidelines Plan Ahead Integrate Concepts Database Design Engage Your Students
Apply Your Knowledge Extend Your Knowledge Make It Right In the Lab Cases and Places Collaboration Challenge Your Students
Assign projects Personalize it Group work Learn It Online Emphasize Concepts Reflection/Critique Rubrics and annotated solution files Test bank Lab tests Assess Your Students
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 Grading Tips
Network printer Printer fonts Wizards not installed Graphics filters Incorrect relationships Compacting Troubleshooting Tips
Idea Exchange What do you do?