Designing from Excel Spreadsheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What's the best way to create a table(s) in Access that will allow a form
and/or subform with headers across the top and down the side, like a Excel
spreadsheet? I'm trying to create a database based on a Excel spreadsheet
that has basic header information at the top, ex. Designer, Date, Drawing,
Checked By, Date. Immediately followed by a a typical Excel-type spreadsheet,
with 30+ row headers in groups of six and 10 column headers. I guess you can
call it a gradebook for lack of a better term. I want to recreate that
"gradebook" in Access but I'm having trouble with the tables. PLEASE HELP!!!
 
Then use Excel.

Really, I don't understand why SO MANY people hang on to Excel like they
were drowning and Excel is a life preserver.

Put your data in a table, and look at it in table-view mode. It'll look just
like Excel. I promise. Then you can relax....
 
I think the issue is presenting normalized data from Access in a spreadsheet
type/pivot view. This is normally done with a crosstab query in Access. The
values in the crosstab query can't be edited. This is normally not an issue.

If you have some questions regarding crosstabs, please reply with table and
field names and how you want them to appear.
 
My main problem is getting to a crosstab query, becuase the table design is
giving me the problem. The form used as the interface is real complicated. I
made the form look like the spreadsheet so the user would be familiar with it.
MARK-UP Illustrator:DROP-DOWN BOX Designer Checker RwkErrs RwkChk
RwkErrs2 RwkChk2
1 Incorrect Interpretation D-D BOX D-D BOX D-D BOX D-D BOX D-D BOX
D-D BOX
2 Not Completed D-D BOX D-D BOX D-D BOX D-D BOX D-D BOX D-D
BOX 3 Wrong Baseline D-D BOX D-D BOX D-D BOX D-D BOX D-D BOX
D-D BOX
4 Incorrect Grap. D-D BOX D-D BOX D-D BOX D-D BOX D-D BOX D-D
BOX
5 Wrong Effect. D-D BOX D-D BOX D-D BOX D-D BOX D-D BOX D-D
BOX

That just a simply. It's 30 rows, all with drop-down boxes for the various
answers. How can I do that in Access?
 
You said:

"The form used as the interface is real complicated. I made the form look
like the spreadsheet so the user would be familiar with it."

Isn't the goal of GOOD DESIGN to make the user interface as intuitive as
possible? I think that by attempting to hang on to something that looks like
Excel, you've simply made your REAL task (that of providing a SOLUTION to
your users) that much more difficult. The real solution to users unfamiliar
with an application is a USER GUIDE and/or training.
 
Back
Top