Forum Discussion
Need help building a form that allows for several rows of entries per column (Excel style)
I am creating a database through Access for employee end of shift reports. Currently these reports are not being stored in a database and instead are filled out on an Excel file. The Excel format wor...
Emilyharp The "elegant solution" to which you refer is, in fact, the process of creating a relational database application. You will need to invest some time learning about the process of Normalization, which lays out the guidelines for designing the various tables needed.
As you've already learned, Excel and Access are two very different things. Unfortunately, much of what we come to rely on in Excel is flat out contrary to good relational database application design.
Start with a search for database normalization. Learn about it. Develop the tables you need. The forms will come later.
