Students can extend a basic knowledge of Microsoft® Access to an advanced level with this practical guide. Advanced Applications Using Microsoft® Access 2003 combines theoretical examples and practical exercises to encourage the development of advanced Database skills in various subjects including, relational database design, multiple table queries, customising forms and reports, automation of tasks using macros and VBA and database customisation using switchboards.
A basic understanding of Microsoft Access 2003, and a familiarity with the Microsoft® Windows operating system environment is required.
*Due to copyright price in SA will vary.
Contact customer service for details.
Features and Benefits
top
* Easy to follow instructions and structured outcomes
* Exercises that develop concepts through simple explanations
* Objectives clearly stated at the start of each chapter
* Screen shots throughout, illustrating key points
* Summary of key terms
* Review questions at the end of each chapter
* Glossary of key terms
Table of Contents
top
Chapter 1
Introduction & basic review
Chapter 2
Relational databases
Chapter 3
Queries with multiple tables
Chapter 4
Forms and fields
Chapter 5
Customise forms
Chapter 6
Reports
Chapter 7
Macros, and more on forms
Chapter 8
More macros
Chapter 9
Develop an application with menu
Chapter 10
Customise an application
About the Authors
top
Developed and supported by the staff of the Information Technology workgroup of TAFESAs Douglas Mawson Institute of Technology, South Australia.
Target Audience
top
For students wishing to grasp some of the advanced features of Microsoft® Office Access 2003. The book has been written with competency training in mind and solidly underpins: Develop macros and templates for clients using standard products; the impact of new technology on existing techniques; customisation of software and using advanced features of computer applications.
Supports the competency units
ICAB3018A
Develop macros and templates for clients using standard products
ICAU3028A
Customise packaged software applications for clients
ICAU3126A
Use advanced features of computer applications
