|
GCSE Projects in Access 2000
This book is designed to help students on a GCSE ICT course complete a major database project. It includes step by step instructions on how to design, implement and document a data base system at GCSE level using MS Access 2000. Advice is included on choosing a project along with a complete sample project.
Part 1 - Analysis
Chapter
1 The system life cycle
Chapter 2 Choosing a project
Chapter 3 Consulting the users of the current system
Chapter 4 Describing the current system
Chapter 5 Drawing data flow diagrams
Chapter 6 Describing the possible solutions
Chapter 7 Describing and justifying the chosen solution
Chapter 8 System objectives and performance criteria
Chapter 9 Describing the current resources
Part 2 - Design
Chapter 10 Relational databases
Chapter 11 Choosing the software
Chapter 12 Describing the resource requirements
Chapter 13 Drawing a system flowchart
Chapter 14 Designing tables
Chapter 15 Describing the relationships between tables
Chapter 16 Designing a menu system
Chapter 17 Designing data entry input forms
Chapter 18 Designing reports
Chapter 19 Designing queries
Chapter 20 Preparing a test plan
Part 3 - Implementation
Chapter 21 Documenting the system implementation
Chapter 22 Creating a new database and tables
Chapter 23 Linking tables
Chapter 24 Entering data in tables
Chapter 25 Creating and customising data entry forms
Chapter 26 Using data entry forms
Chapter 27 Verification and validation
Chapter 28 Creating queries
Chapter 29 Creating and generating reports
Chapter 30 Creating the menu system
Chapter 31 Testing the system
Chapter 32 Preparing a User Guide
Chapter 33 Evaluating the system
Appendix A
Sample Project
Appendix B
Project Marking Criteria (AQA Specification)
Index
|
