Category Archives: Design and Tables

An Access Project, Part 1: Requirements

In this series of articles, David Irvine walks through the process of creating a complete Access application. While the application itself is a valuable tool in a developer’s toolkit, David will concentrate in each article on using some feature of … Continue reading

Posted in Design and Tables | Tagged | Leave a comment

Working in the Real World

I’d like to talk about something that you all know: the real systems development cycle. This is significantly different from the cycle discussed in most systems design books. All projects begin with a kick-off. This can range from a visit … Continue reading

Posted in Design and Tables | Tagged | Leave a comment

Data Modeling for the Access Newcomer, Part 2

In part 1, Glenn Lloyd started outlining his approach to data modeling. This month, he finishes his discussion of the rules that ensure that your database will actually work after you’ve built it. Last month I had developed a data … Continue reading

Posted in Design and Tables | Tagged | Leave a comment

Data Modeling for the Access Newcomer, Part 1

Thorough, thoughtful, and accurate data modeling should be the starting point of detailed database design. But a surprising number of developers have little or no understanding of data modeling and shy away from what sounds like a non-profitable and time-consuming … Continue reading

Posted in Design and Tables | Tagged | Leave a comment