Introduction.- A simple, single-table database.- Introduction to section 1.- Tables.- Forms.- Queries.- Reports.- Summary of section 1.- A multi-table, single-user database.- Introduction to section 2.- Bad news! single tables often cause serious problems.- Good news! - multiple tables cure serious problems!- What do you need to make multiple tables work together?- Getting the right data into the correct tables.- Relationships in the real world.- How are relationships modelled?- Revisiting the big four.- Integrity.- Building a database application - GUIs, macros and control languages.- Summary of section 2.- Section 3 - Multi-table multi-user databases.- What exactly is a relational database?- Codd's rules.- Getting the right data into the right tables - normalisation.- Keeping track of everything (the data dictionary).- More on queries (data manipulation).- SQL.- Domains.- Speeding up your database.- What does null mean?- Primary keys - scope and problems finding truly global ones.- Glossary (a 'bluffer's guide' to database terminology).
