Hi Everyone
I am new to the forum and already require help if at all possible on the following:
Firstly, I have
Office 97 with developer tools
Office XP 2002 developer edition
Office Pro 2003
Office Pro 2010
Which of these would be my best option for the following
I want to build an access database with a separate set up / install so you do not have to have access installed on the PC
I am building a spotter’s database for buses, lorries and train fleet numbers etc and have all the relevant info in excel spreadsheets which I want to put into the access database
I am not computer literate so only work with WYSIWYG so I require easy ways if possible
I have built one database for First Manchester Fleet list by importing data from Excel but I find that I cannot alter the info also cannot hyperlink in the actual access database
There are going to be approx 120 fleet lists
Can I build from scratch in design or datasheet then import the data from excel and if so…How?
Any help or direction would be gratefully received
Whichever Access is advised I want the database to work in anything
Thank You
Tony Maguire