Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-29-2009, 03:02 PM
tinkertron tinkertron is offline
Novice
Should I uses Access or Excel?
 
Join Date: Mar 2009
Location: Garland, Texas
Posts: 15
tinkertron is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-29-2009, 03:27 PM
Matrix's Avatar
Matrix Matrix is offline Should I uses Access or Excel? Windows 10 Should I uses Access or Excel? Office 2010
Admin
 
Join Date: Jan 2005
Posts: 389
Matrix is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 03-29-2009, 06:25 PM
tinkertron tinkertron is offline
Novice
Should I uses Access or Excel?
 
Join Date: Mar 2009
Location: Garland, Texas
Posts: 15
tinkertron is on a distinguished road
Default

Then I geuss I will have to take some training courses, hopefully my job offers these, since they did with excel.
Reply With Quote
  #4  
Old 03-29-2009, 08:13 PM
Matrix's Avatar
Matrix Matrix is offline Should I uses Access or Excel? Windows 10 Should I uses Access or Excel? Office 2010
Admin
 
Join Date: Jan 2005
Posts: 389
Matrix is on a distinguished road
Default

Training courses may not be necessary, but you have to spend some time learning it.
Reply With Quote
  #5  
Old 03-29-2009, 08:20 PM
tinkertron tinkertron is offline
Novice
Should I uses Access or Excel?
 
Join Date: Mar 2009
Location: Garland, Texas
Posts: 15
tinkertron is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 03-29-2009, 08:30 PM
Matrix's Avatar
Matrix Matrix is offline Should I uses Access or Excel? Windows 10 Should I uses Access or Excel? Office 2010
Admin
 
Join Date: Jan 2005
Posts: 389
Matrix is on a distinguished road
Default

You can browse the access forum, maybe post your question there?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Should I uses Access or Excel? 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
Should I uses Access or Excel? 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
Should I uses Access or Excel? MS ACCESS - Import from Excel problem Gregory_in_Montauk Office 6 05-06-2005 08:50 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft