Showing how to understand databases, and then moving on to cover the creation of databases with Microsoft Access, this book is intended particularly for HNC/D Degree Computing or Business students. It is also considered suitable for adult-education classes, computing professionals, and courses which require an understanding of databases. After explaining the nature of databases and of information processing in general, the author proceeds to step-by-step guidance on building a database using Access, and provides detailed explanations of complex functions. Advantages and disadvantages of using certain Access features are illustrated. No previous experience of databases or any other database package is assumed. The sections on implementing the design using Microsoft Access assume some familiarity with the Windows 95 operating system.
Showing how to understand databases, and then moving on to cover the creation of databases with Microsoft Access, this book is intended particularly for HNC/D Degree Computing or Business students. It is also considered suitable for adult-education classes, computing professionals, and courses which require an understanding of databases. After explaining the nature of databases and of information processing in general, the author proceeds to step-by-step guidance on building a database using Access, and provides detailed explanations of complex functions. Advantages and disadvantages of using certain Access features are illustrated. No previous experience of databases or any other database package is assumed. The sections on implementing the design using Microsoft Access assume some familiarity with the Windows 95 operating system.
Reihe
Sprache
Verlagsort
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 246 mm
Breite: 174 mm
Gewicht
ISBN-13
978-1-85805-361-5 (9781858053615)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Part 1 The information age: information as an organizational resource; information processing; what is a database?; the tools that Microsoft Access provides for information processing; introduction to the case study. Part 2 Why is database design important?: problems that can result from poor design; benefits of good design; overview of the design process. Part 3 Determining requirements for a database system: collecting data about requirements; interviews; questionnaires; observations; existing system documentation; forms and other documents used in the organization; collecting data about the data. Part 4 Creating a data model using entity relationship diagrams: entities; relationships; cardinality; dependencies. Part 5 Ensuring the quality of the data model: normalization; functional dependencies; the normal forms; an example. Part 6 Documenting other requirements: entity life histories; documenting business rules; other integrity constraints. Part 7 Data design: purpose of data design; naming entities and attributes; data-encoding schemes. Part 8 Implementing the database design using Microsoft Access: creating a new database; creating a new table; creating relationships; reviewing the design. Part 9 Capturing data: importing data from another source; entering data directly into a table; sorting and filtering data in a form; using queries. Part 10 Introduction to structured query language: data-manipulation statements; data-definition statements. Part 11 Presenting information: using reports; outputting to other applications; integrating Access with other applications. Part 12 Legal and social issues of data processing: privacy and security; the Data Protection Act; health and safety issues. Appendices: evaluating Microsoft Access against Codd's "Twelve Rules for a Relational Database"; using expressions in Microsoft Access.
