Publication Details
|
| Intermediate Microsoft Access 2002 |
| Price: |
$99.00 |
| Business Focus: |
Computer Applications |
| Instructor: |
AlanSimpson |
| Course Code: |
na2 |
| Delivery Method: |
Instructor-led Online Course |
| Frequently Asked Questions |
|
|
| Course Overview: |
Virtually all modern businesses rely on databases to manage their information. In this hands-on, project oriented online course, youll learn the skills needed to build real world Microsoft Access 2002 databases with the features and capabilities needed in todays business climate.
Youll learn about designing tables and joining and working with multiple tables through queries. Youll learn how to create advanced, professional-quality forms and dialog boxes. Youll create advanced reports with totals, subtotals, business charts, and more. In addition, you will use macros to automate business processes. Youll see an example of using cut-and-paste to import Visual Basic code into your databases. And finally, youll learn how to pull all the pieces of your database together into an easy-to-use, fully functional database application.
|
| Instructor Biography: |
| Alan Simpson is the author of over 80 computer books published in a dozen languages, including Alan Simpson's Windows XP Bible and Mastering Access 2002. Alan writes about word processing, spreadsheets, databases, operating systems, Internet, Web design, and computer programming. He has also worked as a teacher and served as a consultant to everything from small businesses to huge government projects. He holds a Master's Degree in Experimental Psychology (Learning and Motivation). |
| Course Syllabus: |
| Lesson 1 Syllabus |
Creating a Database and Tables |
| Lesson 2 Syllabus |
Creating Custom Forms, Part 1 |
| Lesson 2 Objective |
Design and create the tables and fields for a database. |
| Lesson 3 Syllabus |
Creating Custom Forms, Part 2 |
| Lesson 3 Objective |
Create professional-quality forms using the Form Wizard and Form Design tools. |
| Lesson 4 Syllabus |
Creating Custom Forms, Part 3 |
| Lesson 4 Objective |
Enhance custom forms with calculated controls, pictures, and drop-down menus. |
| Lesson 5 Syllabus |
Working with Multiple Tables |
| Lesson 5 Objective |
Create custom dialog boxes with tabs, subforms, command buttons, and decorative boxes. |
| Lesson 6 Syllabus |
Working with Text and Numbers |
| Lesson 6 Objective |
Understand and implement one-to-many relationships between tables. |
| Lesson 7 Syllabus |
Awesome Access Automation |
| Lesson 7 Objective |
Use expressions to perform calculations and make decisions within a database. |
| Lesson 8 Syllabus |
Mastering Macros |
| Lesson 8 Objective |
Automate business processes with calculated fields and queries. |
| Lesson 9 Syllabus |
Intermediate Report Techniques |
| Lesson 9 Objective |
Automate business processes using macros. |
| Lesson 10 Syllabus |
More Reports and Business Charts |
| Lesson 10 Objective |
Create reports to print mailing labels, invoices, and receipts from multiple tables. |
| Lesson 11 Syllabus |
Introducing VBA |
| Lesson 11 Objective |
Use subreports, charts, and reports with totals and subtotals to provide instant access to information. |
| Lesson 12 Syllabus |
Pulling It All Together |
| Lesson 12 Objective |
Understand the purpose of Visual Basic for Applications (VBA) and incorporate VBA code into your own databases. |