#1
|
|||
|
|||
Should I uses Access or Excel?
I upkeep a database of offenders from our agency that are located in the county jail. The database is to track the offender through what we call is a pre-revocation process. The main purpose of this, is to eliminate the time it takes to get the offender through the process and to help cut back on the jail over population. I currently uses Excel to do this. But I find that the layout is overwhelming shotting two to three pages long (landscape). I have about 18 entries to enter. I also want to make my speadsheet and possible data entry available on the web. What should I be using (Excel or Access) I looked at access and also found that to be overwhelming to learn, and plus I didn't see if it also uses formulas like excel does.
If there is anyone in or around the Dallas, Texas area, and think they can help me develope something like I mention, please hit me up and post. |
#2
|
||||
|
||||
Excel is a Office software; Access is a database software and more for programmers, it's very powerful at data manipulation and report/web presentations. It seems Access is better for your requirement, but it's gonna be hard since you have no Access experience.
|
#3
|
|||
|
|||
Then I geuss I will have to take some training courses, hopefully my job offers these, since they did with excel.
|
#4
|
||||
|
||||
Training courses may not be necessary, but you have to spend some time learning it.
|
#5
|
|||
|
|||
I watched acouple of online videos about access, and so far i'm not finding it usesful. I know that it is or could be, but the knowledge of it all is making my head hurt. I want to learn, but I want to learn from what I need and want, not what cool features it has. I just want to show what I have and someone show me how to put it together, and hear what I expect the "Purpose Statement" of that database. When I learned Excel I gain so much, that I was able to create a database with simply ease. Now I want to improve on it, so that other people in my business and do data-entry and clients can view the reports and or speedsheet via web. I have less the 3 weeks to get this all together and wow my employer.
|
#6
|
||||
|
||||
You can browse the access forum, maybe post your question there?
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Opening multiple Excel files within the same Excel window. | lost9471 | Excel | 2 | 05-01-2010 01:57 PM |
Excel or Access ? | inferno | Excel | 0 | 10-03-2008 03:42 AM |
Can Access access folders & sub-folders and dig out data? | nrg | Office | 4 | 06-20-2005 11:09 PM |
Delete excel files by code in Access | Barry Richardson | Office | 0 | 06-13-2005 06:26 AM |
MS ACCESS - Import from Excel problem | Gregory_in_Montauk | Office | 6 | 05-06-2005 08:50 AM |