Question Excel to Access

[messiah165]

Im not sure what section I should put this in because it will require all of the areas in this forum. VBA, Reports, macros, ETC.

I created this spreadsheet and I now want to move it to a database. Im familiar with mysql, but not so much Access. I can design a database, create relationships and all of that. I know how to query with mysql, but these things are slightly different in access.

Here is the file (I cant post the link so I have attached the file). I was looking at oxicottin's that he created and this is about what I would need with some tweaks. Looking at my spreadsheet how feasible do you think it would be to go to an access DB and if you are willing guide me through the process of creating it. Im not asking for you to do the work. I can search for the coding that I do not understand, just be my teacher so I am able to learn as I complete this project.

Of also attached the file to this thread.

Thanks much!
Messiah

 

[DavidAtWork]

This would go into a database. You just need to think about what you are wanting to store in terms of records, this should dictate your table design and relationships. Once you are happy with the design you need to decide on how you'd like to control the creation of the necessary records, either by using forms bound to tables or simple data entry forms and then some sql to append the entered data into tables.
Looking at your spreadsheet, some of the tables are self explanatory ie the lookup tables. Other tables, looks like you'd need an employee table, absence table. Don't understand how your attendance points works. The calendar view showing absences etc will not be straightforward to replicate in Access, but all other functionality should be possible
David

 

[messiah165]

David,

Yes I have gotten as far as creating the tables. I have two so far. Employees and Attendence which contains the codes and points for each type. As far as how the points work, for each occurance there are a certain amount a points that you can get, late get 1 point, really late you can get 3. There are no excused absences or lates, its all the same. Accumulate more than 21 and its an automatic termination. If you go 90 days without any occurance 3 points are removed from your total. I was going over oxicottins and the coding in there is really jacked in some spots. I.E unsigned variables. As far as how I have the calendar in excel, the way the one in oxi's works will do. So that leaves the how of the way it works. What to do first? Should I create all the querys needed before going into the forms and reports?

 

[DavidAtWork]

How do you want it to work or how do you envisiage it working. You can certainly create forms for all aspects of data entry and queries can be used to create views which you might see as sub forms. You need to think about the design of your database ie what will happen at startup and how you want to navigate from form to form, to any reports etc.
David

 

[messiah165]

David this one by oxicottin is almost exactly what I need. Only thing missing is the ability to track points. access-programmers.co.uk/forums/showthread.php?t=142732. I want to get around to how he did this because this is what I envisioned. Just a simple clickable interface for whomever is using it. This will stop the need for me to constantly be instructing the eventual end user.