Database Design and Programming with Access, SQL and Visual Basic

Part 1 Introduction: how to develop a database application - what this book contains problem analysis; database design; query design; database programming; Visual Basic and Access; versions of Visual Basic and Access; compatibility between versions of Visual Basic and Access; exercises. Part 2 Problem analysis: the system life cycle; defining objectives; feasibility; analysis; dataflow diagramming; context diagrams; dataflow diagrams; sources and slinks of data; dataflow lines; processes; data stores; process specification; structured English and pseudo-code; business rules; decision tables and rule verification; exercises. Part 3 Database design: introduction; link to dataflow diagramming; entity modelling; entity types and relationships; replacing M - N; relationships with new entity types; replacing relationships involving more than two entity types with a new entity type; parallel relationships; mutually exclusive relationships; unnecessary relationships; relational modelling; selecting an initial set of attributes; terminology; primary keys; foreign keys; normalisation; first normal form; second normal form; third normal form; fourth normal form; fifth normal form; exercises. Part 4 Database schema design in Access: introduction; organising an application; the facilities of Access; creating a database; creating tables; in-built field; integrity checks; keys and indexing; creating relationships; referential integrity; join type; exercises. Part 5 Query design in Access: query by example - the query design Window; SQL with examples; single table queries; joins; subqueries; union queries; exercises. Part 6 Forms and reports in Access: Access form design; form Wizards; custom form design; Access report design; report Wizards; custom form design; Access report design; report Wizards; macros; modules; strengths and weakness of Access for process design; exercises. (Part contents).