(Msg. 1) Posted: Sun Jan 15, 2006 2:37 pm
Post subject: New Access user needs database for small bookshop Archived from groups: microsoft>public>access>gettingstarted (more info?)
I have a small home-based business (primarily through ebay) and have been
trying to create a database that will allow me to: track inventory, track
which books are sold to which customers and for how much, track all fees
associated with each sale (ebay fees, paypal fees), tell me the amount of
sales within my state for quarterly sales tax, etc. I've tried relying on my
own faulty memory (used to be fairly good with access, but a head injury and
years of not using it are working against me), have asked numerous questions
through Microsoft's forum, and spent several days trying to disect templates
in order to figure it out, and I finally have to admit defeat.
Does anyone know someone in the Colorado Springs area who does freelance
database work for small, struggling businesses, OR know of a good template
for sale that would do what I've outlined above?
(Msg. 2) Posted: Mon Jan 16, 2006 5:00 am
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Are you certain you need a database? From your description, I'm wondering
if a commercial accounting/bookkeeping package might not be able to do what
you need?
--
Regards
Jeff Boyce
<Office/Access MVP>
"equuscycle" <equuscycle RemoveThis @discussions.microsoft.com> wrote in message
news:B096BD91-9E6F-4763-9E82-04299BF77DEC@microsoft.com...
> I have a small home-based business (primarily through ebay) and have been
> trying to create a database that will allow me to: track inventory, track
> which books are sold to which customers and for how much, track all fees
> associated with each sale (ebay fees, paypal fees), tell me the amount of
> sales within my state for quarterly sales tax, etc. I've tried relying on
my
> own faulty memory (used to be fairly good with access, but a head injury
and
> years of not using it are working against me), have asked numerous
questions
> through Microsoft's forum, and spent several days trying to disect
templates
> in order to figure it out, and I finally have to admit defeat.
>
> Does anyone know someone in the Colorado Springs area who does freelance
> database work for small, struggling businesses, OR know of a good template
> for sale that would do what I've outlined above?
>
> THANKS!!!!
(Msg. 3) Posted: Mon Jan 16, 2006 6:17 am
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Jeff - I currently have an Excel spread that tracks this information for me,
but I'm finding that I'm duplicating information when I need to pull
information for month-end/quarter-end reports, and thought a database would
be the best method of tracking everything.
"Jeff Boyce" wrote:
> Are you certain you need a database? From your description, I'm wondering
> if a commercial accounting/bookkeeping package might not be able to do what
> you need?
>
> --
> Regards
>
> Jeff Boyce
> <Office/Access MVP>
>
> "equuscycle" <equuscycle.TakeThisOut@discussions.microsoft.com> wrote in message
> news:B096BD91-9E6F-4763-9E82-04299BF77DEC@microsoft.com...
> > I have a small home-based business (primarily through ebay) and have been
> > trying to create a database that will allow me to: track inventory, track
> > which books are sold to which customers and for how much, track all fees
> > associated with each sale (ebay fees, paypal fees), tell me the amount of
> > sales within my state for quarterly sales tax, etc. I've tried relying on
> my
> > own faulty memory (used to be fairly good with access, but a head injury
> and
> > years of not using it are working against me), have asked numerous
> questions
> > through Microsoft's forum, and spent several days trying to disect
> templates
> > in order to figure it out, and I finally have to admit defeat.
> >
> > Does anyone know someone in the Colorado Springs area who does freelance
> > database work for small, struggling businesses, OR know of a good template
> > for sale that would do what I've outlined above?
> >
> > THANKS!!!!
>
>
(Msg. 4) Posted: Mon Jan 16, 2006 9:04 am
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
There are many ACCESS applications that people have develeoped for doing the
types of things that you seek.
If you'd like to get information about some of them, post a munged email
address (with explanation for how to unmunge it) to which people might send
you an email with information.
--
Ken Snell
<MS ACCESS MVP>
"equuscycle" <equuscycle DeleteThis @discussions.microsoft.com> wrote in message
news:B096BD91-9E6F-4763-9E82-04299BF77DEC@microsoft.com...
>I have a small home-based business (primarily through ebay) and have been
> trying to create a database that will allow me to: track inventory, track
> which books are sold to which customers and for how much, track all fees
> associated with each sale (ebay fees, paypal fees), tell me the amount of
> sales within my state for quarterly sales tax, etc. I've tried relying on
> my
> own faulty memory (used to be fairly good with access, but a head injury
> and
> years of not using it are working against me), have asked numerous
> questions
> through Microsoft's forum, and spent several days trying to disect
> templates
> in order to figure it out, and I finally have to admit defeat.
>
> Does anyone know someone in the Colorado Springs area who does freelance
> database work for small, struggling businesses, OR know of a good template
> for sale that would do what I've outlined above?
>
> THANKS!!!!
(Msg. 5) Posted: Mon Jan 16, 2006 9:04 am
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I'm not sure what a "munged" email address is, but if you could explain, I'll
give it a try.
Thanks!
Tina
"Ken Snell (MVP)" wrote:
> There are many ACCESS applications that people have develeoped for doing the
> types of things that you seek.
>
> If you'd like to get information about some of them, post a munged email
> address (with explanation for how to unmunge it) to which people might send
> you an email with information.
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
>
> "equuscycle" <equuscycle RemoveThis @discussions.microsoft.com> wrote in message
> news:B096BD91-9E6F-4763-9E82-04299BF77DEC@microsoft.com...
> >I have a small home-based business (primarily through ebay) and have been
> > trying to create a database that will allow me to: track inventory, track
> > which books are sold to which customers and for how much, track all fees
> > associated with each sale (ebay fees, paypal fees), tell me the amount of
> > sales within my state for quarterly sales tax, etc. I've tried relying on
> > my
> > own faulty memory (used to be fairly good with access, but a head injury
> > and
> > years of not using it are working against me), have asked numerous
> > questions
> > through Microsoft's forum, and spent several days trying to disect
> > templates
> > in order to figure it out, and I finally have to admit defeat.
> >
> > Does anyone know someone in the Colorado Springs area who does freelance
> > database work for small, struggling businesses, OR know of a good template
> > for sale that would do what I've outlined above?
> >
> > THANKS!!!!
>
>
>
(Msg. 6) Posted: Mon Jan 16, 2006 3:21 pm
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"equuscycle" <equuscycle DeleteThis @discussions.microsoft.com> wrote in message
news:AEC836AE-173A-4DCD-8603-7A9AFFC4B68F@microsoft.com...
> I'm not sure what a "munged" email address is, but if you could explain,
> I'll
> give it a try.
>
One that a bot can't harvest. Mine would be keith <at> keithwilby <dot>
com.
(Msg. 7) Posted: Mon Jan 16, 2006 6:12 pm
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Ah hah! Thanks, Keith!
Tina
"Keith Wilby" wrote:
> "equuscycle" <equuscycle.RemoveThis@discussions.microsoft.com> wrote in message
> news:AEC836AE-173A-4DCD-8603-7A9AFFC4B68F@microsoft.com...
> > I'm not sure what a "munged" email address is, but if you could explain,
> > I'll
> > give it a try.
> >
> One that a bot can't harvest. Mine would be keith <at> keithwilby <dot>
> com.
>
> Keith.
> www.keithwilby.com >
>
>
(Msg. 8) Posted: Sat Jan 21, 2006 8:51 am
Post subject: Re: New Access user needs database for small bookshop [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I would recommend QuickBooks - it will make it fairly easy and your
local accountant will have a template for it to make it very easy at
tax time.
By the way, if you are looking for live updated sales and use tax rates
around the US or Canada and don't want to bother with purchasing,
integrating and updating a sales tax database each month, you might try
StrikeIron's live sales tax rates xml-based Web service. You simply
provide an address and it provides the corresponding sales and use tax
rates. You can use the Web interface to manually look them up or access
it programmatically as a SOAP or REST based Web service.
equuscycle wrote:
> I have a small home-based business (primarily through ebay) and have been
> trying to create a database that will allow me to: track inventory, track
> which books are sold to which customers and for how much, track all fees
> associated with each sale (ebay fees, paypal fees), tell me the amount of
> sales within my state for quarterly sales tax, etc. I've tried relying on my
> own faulty memory (used to be fairly good with access, but a head injury and
> years of not using it are working against me), have asked numerous questions
> through Microsoft's forum, and spent several days trying to disect templates
> in order to figure it out, and I finally have to admit defeat.
>
> Does anyone know someone in the Colorado Springs area who does freelance
> database work for small, struggling businesses, OR know of a good template
> for sale that would do what I've outlined above?
>
> THANKS!!!!
All times are: Eastern Time (US & Canada) (change) Goto page 1, 2
Page 1 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other