Databases are often viewed as the end product rather than as a tool in the work place. This book has been written to address this need, using straightforward examples and assessing different ways of storing information. It is a practical guide to collecting data and using Microsoft Access to transform it into useful information.
Written for both Business Studies students and professionals, it adopts a functional approach which teaches theory by practical example. 'Jargon buster' sidebars explain the terminology related to database theory, while the revision questions at the end of each unit aid comprehension. This straightforward approach means that the text is ideal for self-study.
1 Introduction
2 Beginning the design process
3 Determining requirements for a database system
4 Creating the data model
5 Using normalisation to ensure design quality
6 Creating the physical data model
7 Data design
8 Implementing the database design using Microsoft Access
9 Capturing data
10 Using forms
11 Using queries
12 Totals queries
13 Advanced queries
14 Presenting information using reports
15 Presenting information graphically using charts
16 Optimising database performance
17 Social issues of information processing
Appendices
Index