Denver Area Access Users Group

General Meeting Presentation

Tuesday, April 6, 2010

Planning and Structuring Data

Crystal Long

Planning a database is often rushed in order to get the User Interface (UI) done faster. UI is the stick frame, paint, wallpaper, windows and skylights...what the homeowner sees in his new home. In database development, this is not where you start. The structure of a database is the foundation below that new home. It is what needs to be strong in order to support and enjoy everything else. This is the most important part of a database to get right. You are encouraged to bring your ideas for database applications so that we can discuss tables and relationships for different scenarios in Access and then contrast and compare them. What do they have in common? How do you approach design from a generic perspective and ensure that your application will be solid with flexibility for future growth? Bring your own laptop computer so you can look at and modify your own application and notes during the presentation.