Database Design and Management Using Access
Published on 29. October 1998
Book
Paperback/Softback
208 pages
978-1-85805-361-5 (ISBN)
Description
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.
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.
More details
Series
Language
English
Place of publication
London
United Kingdom
Target group
College/higher education
Professional and scholarly
Illustrations
illustrations
Dimensions
Height: 246 mm
Width: 174 mm
Weight
355 gr
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 Classification
Content
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.