New to Access and I have some Questions

[Joah]

A friend of mine has encouraged me to try Access for some of my gaming developments. I am currently using excel to build an army sheet for a tabletop wargame. Players input their various data into the excel sheet and the model computes some numbers to build applicable values to the game.

My questions-- do I need to code to use Access? Will Access use my excel sheet to build its database? How can I get Access working for me now (and avoid the mental haze of book-learning)?

I've tried to import my excel sheet but I guess I have to build xml mapping/data. I have googled this but I have to code stuff?

Now don't get me wrong, I don't mind coding stuff. But I havn't coded for years and if I do have to code stuff I will have to undertake a vow of coding acceptance.

Cheers,

PS I have included my excel sheet so that anyone who may be able to help can have a look and see if Access could be made to help.

[alansidman]

For a starting point, I suggest you read the following link

http://www.deeptraining.com/litwin/d...aseDesign.aspx

Once you have devoured the above, here is a link to a tutorial on building a database.

http://www.accessmvp.com/strive4peace/

Pay close attention to data normalization. This will allow you to use your excel sheets either imported or linked if they are normalized. Read the first link and it will explain normalization clearly.

Much of what you do in Access can be done without coding in VBA; however, if you want more than very basics, then you will need to do some coding.

Good luck and post back with any issues you may encounter.

Alan

[Joah]

Thank you so much for your reply,

I will follow your links astutely,

Cheers,

[arlu1201]

Joah,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Joah]

I have made the changes.