Hi Folks,
I am a newbie at Access. I have uploaded an Access 2013 file and an Excel 2013 file to show what I am trying to do. (I also incorrectly uploaded this question under QUERIES - since marked there as 'Solved")
The Access tables that I have created are meant to mirror the individual fields on the Excel spreadsheet.
On the Excel spreadsheet, I would enter data in the rows as the data becomes available.
The Access file contains the excel fields as tables. Some of the table fields consist of only one field and others have many fields.
I have created Primary Keys in all the tables. But I don't understand the process well at this point in time.
I need to know how to create proper relationships, and then, to create a query or a form to enter new data as it becomes available so that I can keep adding rows of data (query to enter and update data) and subsequently run queries to analyze the data
Any help with creating the correct relationships and a query that lets me update all the data for new cases, as an individual row (like on an excel spreadsheet) is much appreciated.
Thank You