Hi there, I'm a new member of this site, and in dire need of some access help!
I've been on a Basic level access course with my work a few months ago, so I have a rough idea of how to begin, but I'm having trouble with knowing what information to put in which table and how many to create.
I've attached the excel sheet I'm practicing with - basically, it is a sheet to record all the guarantee claims of a ship and its equipment - there are 20 ships in total all with their own sheet - however I'm keeping it simple with starting with just one.
We want to transfer the form to Access, and want to be able to create forms and reports based on criteria such as the ships name, identification number, date the claim was closed, manufacturer, area of equipment- all of which are found in the excel sheet, eg - I want to see all the claims for all the ships that are in the Fuel System area - that sort of thing.
I know its a lot but could anyone help me with what info to put in tables - at least to give me a head start. Many thanks in advance!
Access Claim Tracker.zipAccess Claim Tracker.zipAccess Claim Tracker.zip