Search results

Ahhh rite I see. I most definitely will post the access database relationships however I haven't got that far yet! I will structure it this weekend and post it up!

Hi Rainlover. Sorry thought I was on the right track with that ERP? If you would prefer it in another style I will be very willing to do so! Your help has been very much appreciated to date! Let me know, nucoeus.

Hi all, I have updated and attached a new ERP based on your comments RainLover and Beetle. Keep them coming please I will perfect this before moving on! As in the last image I have included my thoughts on the relationships so you can understand my approach to these (and correct if necessary...

Hi Rain and all, Thanks for the continuing support! I have made a ERP though I seems to have alot of one-to-one relationships suggesting I may not have my entities correct. In my previous post I identified the asset, employee and potentially site as the only collections of items deemed as...

Hi all, Slight delay due to family issue so hopefully ill get back to you all tomorrow with an outline. I have read some of the documents today though and have a few questions / outlined some planning for critique to help me tomorrow if possible? 1. The RDBM principles document notes that...

Hi everyone, Ill come back to you on Monday evening - I'll make sure to have everything mapped out and defined rather than ad hoc the way through it today. All my reading should be hopefully done today from your suggestions so seems a good plan :) Should make it easier to progress forwards...

Hi Rain, Thanks for the input - what did you think to my attempt at normalizing my database above - did it make logical sense? I've read this document on the website :D (access-programmers.co.uk/forums/showthread.php?t=225837) noted in my above post - very informative! I will be putting that...

Okay had a look at Normalization. My fields for my database should include: 1. Type (vehicle / plant / F&F etc.) 2. Cost 3. UEL 4. Depreciation basis (straight line / reducing balance) 5. Accumulated depreciation 6. NBV 7. Disposal proceeds 8. Profit / loss on sale 9. Description 10. Site I'm...

Hi Rainlover, Normalization is on todays agenda after a brew and shower! I'm going to google it but if you / anyone has any links you think are good would be very interested to read up on them! I'll be sure to tap Gemma's knowledge when the time comes, parties willing of course :) Regards...

Wow Gemma that sounds exactly like what I am looking for! I see your a super moderator so id assume a Access pro - would it be hard for a beginner to do? Given you've done the exact thing Im looking for if your have any tips / planning documents etc. youd be willing to share id much appreciate...

Nothing in particular I'm gonna read this book before attempting to set up the database just wanted to know its not a wasted path! Oooh thinking about it importing and exporting data from Excel to Access - take it can be done? I imagine you need to input into Excel correct field headers and...

Hi all, Newbie to the forum and pleased to meet you all! I am considering shifting from Microsoft Excel 2010 to Microsoft Access 2010 to manage a rapidly growing fixed asset register. I would want to build the database from scratch (rather know it inside and out than use a pre-built one)...