Category Archives: Design and Tables

What’s in a Table?

Stu Alderman explores the structure of your Access database and discusses the relationship between Access objects and System tables. I’m currently developing an application that imports several files from mainframe sources at the State of Nevada. The application uses a … Continue reading

Posted in Design and Tables | Leave a comment

Renaming Tables – and SQL Linked Tables

Renaming a Bunch of Tables I am working on a conversion database that requires linking to lots of tables in lots of databases with exactly the same tables. I then need to rename the linked tables to remove the Suffix … Continue reading

Posted in Design and Tables | Leave a comment

Querying a Customer Survey Table

Peter Vogel answers a question about querying a customer Survey table.          I have a table that lists our customers. Some customers have agreed to participate in a survey and others haven’t. I need to calculate the number of participants who … Continue reading

Posted in Design and Tables | Leave a comment

Managing State Transitions

This month, Rebecca Riordan looks at two simple techniques for expanding the standard Lookup tables. First, she shows you how Lookup tables can handle hierarchies, but then she moves on to show how to manage state transitions–the movement of an … Continue reading

Posted in Design and Tables | Leave a comment

Managing Lookup Tables

Chris presents the Lookup Table Manager — a one-stop utility that allows data to be added into and removed from any of the lookup tables that populate your Access databases. I build a lot of systems that use combo boxes … Continue reading

Posted in Design and Tables | Leave a comment