About designing a database
1. Determine the purpose of your database 2. Determine the fields you need in the database 3. Determine which table each field belongs to 4. Determine the relationships between tables 5. Identify the field or fields with unique values in each record 6. Determine the relationships between tables 7. Refine your design 8. Enter data and create other database objects 9. Use Microsoft Access analysis tools