I Need to Create Form For Sales Reporting

G

Guest

Could someone please recommend how to create a form for 50 employees to track
their weekly sales? I am hoping to create the form based on 4 tables:
employees/customers/products/sales activities

Do these tables sound like a reasonable start for a new user? Thanks for
your advice! -Ella
 
J

Jeff Boyce

Ella

We aren't there. We have no way to know the specifics of your situation.
What works for one situation may prove totally off-base in another.

If you were working with a spreadsheet, I could imagine starting out as
you've described. Access is a relational database, though, and you'll need
to familiarize yourself with "normalization" if you want to get good use of
Access' relationally-oriented functions and features.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Event item sales 1
Need conceptual help with form for entering Sales Tickets 3
How can I create a Sales form that can update both the Product and Sales Tables 7
Need to reference multiple fields in combo box or Form Button 2
Creating a form to populate Datasheet 3
Create complex data entry form 3
Calc Sales based on Stock Count 3
Design of a simple sales entry database form 1

Top