i need a access form design (1 Viewer)

khushee

New member
Local time
Yesterday, 16:17
Joined
Dec 7, 2005
Messages
7
i want to conduct survey on paper and want to enter manually the data of this survey in access form and want to create report in graph
the design of data entering form and report is attached in picture format. please help me in this regard.

stay blessed
 

Attachments

  • form.jpg
    form.jpg
    95.9 KB · Views: 112
  • report..jpg
    report..jpg
    84.4 KB · Views: 89

Pat Hartman

Super Moderator
Staff member
Local time
Yesterday, 19:17
Joined
Feb 19, 2002
Messages
43,302
Asking someone to do your work for you for free isn't going to get you anywhere. Take a stab at it and come back with specific questions.
 

plog

Banishment Pending
Local time
Yesterday, 18:17
Joined
May 11, 2011
Messages
11,646
I agree with Pat, but also want to point out Forms and reports and graphs aren't the place to start. The first part of any database is properly structuring the tables. That's what you need to work on, then you start on your forms.

If you need help with that, post in the Tables section of this forum.
 

CraigDolphin

GrumpyOldMan in Training
Local time
Yesterday, 16:17
Joined
Dec 21, 2005
Messages
1,582
I agree with Pat, but also want to point out Forms and reports and graphs aren't the place to start. The first part of any database is properly structuring the tables. That's what you need to work on, then you start on your forms.

If you need help with that, post in the Tables section of this forum.

Table design is definitely the right place to spend a lot of time thinking and planning and failure to properly normalize your table structure is the biggest problem for database design.

But I also think that table design can be informed by expected outputs, such as reports and graphs and such.

If a client wants to produce a chart showing sales, then that tells me I need to store sales data. If a client wants to report average fish length with 95% confidence limits, by date or by month or by year, then that tells me I need to store fish lengths and dates for individual fishes rather than just summary group fish length data so that the appropriate statistics can later be calculated for whatever interval is required. The expected level of reporting detail can help inform you how detailed your data model/table structure needs to be.

The worst thing would be to create a wonderful functional database, only to have a client later wonder why they can't produce a report breaking down their product sales by color, when you don't even store product color in your sales data tables.
 

Users who are viewing this thread

Top Bottom