Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-21-2009, 12:50 AM
mrphilk mrphilk is offline Excel or Acces Windows XP Excel or Acces Office 2003
Novice
Excel or Acces
 
Join Date: Jul 2009
Posts: 8
mrphilk is on a distinguished road
Default Excel or Acces

Hi, im working on a project to help me with work.



Im not sure if i would be better to create this using excel or microsoft access so wondered if you guys could maybe suggest something.

I regularly have to create parts lists for plant machinery that I work on and want to create a file which will help me to do this. The idea i have in my head is to have a front page, where I can select the date, customer and machine type that I am working on.

From here I will then be able to select various sections of a machine, each which will have its own list of parts to select from and add to my order.

Once done I want the document to be able to produce an itemised order for parts required.

I understand that this is a mammoth task but I often have a lot of spare time on my hands so I just need pointing in the right direction.

Can anyone make any suggestions for me, should I use excel or access first of all, at least then I will know where to start looking :-)

Thanks!
Reply With Quote
  #2  
Old 07-21-2009, 12:52 AM
Matrix's Avatar
Matrix Matrix is offline Excel or Acces Windows 10 Excel or Acces Office 2010
Admin
 
Join Date: Jan 2005
Posts: 411
Matrix is on a distinguished road
Default

Sounds like an Access project, please post it on www.AccessForums.net, I'm sure you can get some expert advice quickly.
Reply With Quote
  #3  
Old 07-21-2009, 02:32 AM
Bird_FAT's Avatar
Bird_FAT Bird_FAT is offline Excel or Acces Excel or Acces Office 2007
Expert
 
Join Date: Apr 2009
Location: South East
Posts: 271
Bird_FAT is on a distinguished road
Default

I agree with Matrix on this - DEF an Access project!
Reply With Quote
  #4  
Old 07-23-2009, 03:37 AM
zyzzyva57 zyzzyva57 is offline Excel or Acces Windows 7 32bit Excel or Acces Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

If you already have a lot of this done in Excel, I would import it into an Access db as a table, then build queries to drill into my data I wanted, and then easily get to this, I would open on a form to extract my data

In a sense, queries are sub-tables you will want or soon want once you see the awesome power of data mining with Access


Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel or Acces Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
How do I use an Excel form to populate and Excel spreadsheet apostht Excel 0 05-21-2006 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:41 PM.


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