473,320 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Just Learning and Need Guidance! Please!

Hello,
I am just reading up and learning how to use Access. I have always
made Excel work for me in the past. I want to create a db that will
allow me to track expenses at my job. I want to be able to input the
Dept. that is billed and the item numbers that we are charging to them
from our supplier. I would like the db to be able to them take that
and automatically associate that item number with a description and
cost. Quantity would be nice as well.
I am not sure how to even start this, and I have been searching the
web and reading for two weeks now and have just confused myself a
great deal!
THANK YOU to all who could help me get started! I would like to learn
to better utilize this program!

Mar 14 '07 #1
1 1150
It sounds like to get started you will need a table with your item
number, description, and cost. You'll probably also want a form that
will allow you to input the department number, item number, and
quantity used. Are you tracking inventory as well with this? If so,
you'll probably want a table with your "current inventory" that gets
updated as items are used, and a "details" table that has what was
used by which department. You can use the item number as your common
field between the tables. I'm not sure if this really helps you get
started or not...

Mar 14 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

72
by: Herbert | last post by:
I'm still relativey new to stylesheets, so I'm hoping that the way I'm going about things can be seriously improved upon, i.e . I just haven't undersood something obvious about the 'cascading'...
29
by: Jhon smith | last post by:
Hi,all,I was just wondering if I am likly to have any problems trying to learn C from older books,I have some from the late 80`s,mid/late 90`s. I am using Dev-C++ on the pc windows platform,But I...
2
by: Parthiv Joshi | last post by:
Microsoft provides calendar control for month view in .NET. I want to make week view and day view on based of that. So how can I make that in ..NET . If any one have an idea or if some one have...
13
by: O-('' Q) | last post by:
In my effort to fully understand how to use the RegExp engine in c#.net (VS2005), I have begun to tinker with it more since I was shown about the ability the other day in a lengthy newsgroup...
5
by: inetquestion | last post by:
I've got an xml doc which I'm using xslt to create a flat text configuration file. I need to make some dynamic changes in certain circumstances where some of the elements need to have others...
0
by: lucky | last post by:
hi, i've to work on a DB2 project.i'm totally unaware of those concepts.can anyone guide me atleast on the overview of db2.i need specific guidance on connectivity in db2.does it refer tothe...
18
by: ***** charles | last post by:
Hi all, I have tried to learn C now several times before but gave up twice. I would like to learn GCC under Debian. Is there any good BEGINNER tutorials out there that will take me from the...
6
by: MC felon | last post by:
Hi. I've just about learnt object oriented programming, operation of pointers, dereferencing of the same, functions and all other basic manipulations. Now, recently, i made the big leap to the...
0
by: darius | last post by:
Hi, having gps navigation web pages I am still curious about voice guidance algorithms/ applications incorporated into navigation systems. I would appreciate your guidance in accessing the...
2
by: =?Utf-8?B?UmFmYWVsIFNvdGVsZG8=?= | last post by:
Hi there: Does anybody know where can I find a good and complete C# Solution Developing Guidance. With subjects like: * What's the best place for Global Objects and Global Variables *...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.