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
Overview
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 ...