I'm working on a project for a class. The last step is
" Create a form to enter the Sales Representatives data regardless of which table the information is stored."
I'm not sure what this means or how to do it. Any ideas?
I'm working on a project for a class. The last step is
" Create a form to enter the Sales Representatives data regardless of which table the information is stored."
I'm not sure what this means or how to do it. Any ideas?
Neither do I. Why would there be multiple tables storing the same kind of data?
Provide your db design or the file itself for analysis. Follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
this is the db file
ACase01a1 - Copy.zip
Some context might help understand the meaning of this last step of your class project. Could you list the preceding steps? Also, please save and reattach your db as ".mdb", as many members, like me, don't have Access 2010 and cannot open .accdb.
Second time today I can say I've seen something I've never seen before:
Relationships set up between MySys tables. Why are you doing this?
The project has three tables:
Sales Rep Data
Outlet Data
ACase2Data - has all the fields of the other two tables. Why? This table seems totally unnecessary.
Seeing this structure does not clarify the assignment instruction.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
ACase2 Data was the excel file my teacher provided us with to import into the blank database. The excel document had two separate tables, but when I imported it into access they stayed in one table so I manually separated them into the two different tables, Sales Rep Data and Outlet Data.
The instructions are:
Problem: An electronics store wants to keep track of its sales representatives for its various outlets. Construct a database which will meet the following requirements.
- Create a new database to store an appropriate set of tables related to the electronics store. The fields should be logically named, structured with appropriate field types, attributes and keys. Tables should be appropriately related and relationships built. Follow good database practice and minimize redundant fields and incorporate normal forms.
- Save the database as ACase01.
- Import the data as possible into the constructed database.
Then it has a list of different things to do in access, which I believe I have done all except the one that says
- Create a form to enter the Sales Representatives data regardless of which table the information is stored.
If you want some examples of what the other ones are, they are like
- Create a simple form to enter the demographics of the sales representatives.
- Save as Sales Rep
- Create a report listing the sales representative’s identifier and name, outlet quota, YTD sales. Provide the total of the Quota and YTD Sales for each sales representative and for all representatives.
- Provide the following queries:
- Display all fields for all the records in the Sales Representative demographic table.
- Save as Sales Rep List
- Displays the sales representative located in HME 11.
- Save as Sales Rep HME 11
- Displays the sales representative with a Gender of M.
- Save as Sales Rep Male
- Display sales representative name/ID, age, and hire date for all sales representatives with a hire date after June 1, 2005.
- Save as Sales Rep Hire2006
The guidelines are
Guidelines
Be sure that your database objects are:
- Formatted professionally – fonts, colors, column widths, etc.
- Fields are named and formatted consistently
- Correct formulas and functions are used
- Minimal fields are declared and relationships presented.
- Intelligent use of the features covered in the first 4 chapters of the textbook
- Queries and reports are saved as outlined above
- Reports are prepared for printing with logical headers and/or footers
Those are really the only instructions she has given us.
Second time today I can say I've seen something I've never seen before:
Relationships set up between MySys tables. Why are you doing this?
The project has three tables:
Sales Rep Data
Outlet Data
ACase2Data - has all the fields of the other two tables. Why? This table seems totally unnecessary.
Seeing this structure does not clarify the assignment instruction.
If I understand correctly that a sales rep can have only one outlet then the tables seem correct to me.
And you have already built a form to enter sales rep data.
What you don't have is a table for entering sales data on daily/weekly/monthly basis, if the instructor is looking for that. You have annual quota and YTD fields in the SalesRep table. The YTD value would have to be manually adjusted, not calculated from detail sales records. Maybe that's a level of complexity the instructor didn't feel was necessary for this exercise.
However, I am still no more enlightened about the task at issue. I suggest you get clarification from instructor.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.