Use Access for this?

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

Guest

Hi.. I'm new Access learner... I have an opportunity to possibibly use
Access, and this would make my learning more "real" - but I'm not sure if I'm
thinking straight..here's what I'd like to do in a nutshell, and the doubts
I'm having.

Set up a "form" in Access where I can enter Interview notes relating to
specific topic areas asked about during an interview. THEN, I'd like to set
up a rating scheme so that those answers can be reviewed and rated on some
criteria. Those ratings would then be stored in a table that is downloadable
for analysis in Excel.

Doubt#1: As I reviewed the basics, it seems that there is a limit of 225 or
so characters for Text Boxes. Interview notes may run longer than that.
Doubt #2: I'd like to have a top part of the form with name, company,
date..etc. , - but can this info be displayed on a different "page" of the
record??
Doubt #3: Printing...if I want to print out all the info on one person
(contact info, actual interview notes, and ratings) could this then be
printed in one piece?

Any insights would be greatly appreciated!

Stilla
 
Stilla said:
Doubt#1: As I reviewed the basics, it seems
that there is a limit of 225 or so characters for
Text Boxes. Interview notes may run longer than that.
Click to expand...

Text Fields in a Table are limited to 255 characters; Text Boxes are not.
Text Boxes can have a Memo Field as their Control Source, "which has a limit
of 65,535 when entering data through the user interface; but can contain 1
gigabyte of character storage when entering data programmatically",
according to Access 2003 Help.
Doubt #2: I'd like to have a top part of the
form with name, company, date..etc. , - but
can this info be displayed on a different "page"
of the record??
Click to expand...

I'm sorry that I don't know what you mean by "displayed on a different
'page' of the record".

You can have a main Form with such information, and place on this a Subform
Control which has a Form embedded to contain the detail (e.g., your notes).
You can synchronize the related details by specifying the LinkMasterFields
(in Record Source of the main Form) and LinkChildFields (in the Record
Source of the Form embedded in the Subform Control).

You could also use a Query joining the related Tables as Record Source for a
single Form.
Doubt #3: Printing...if I want to print out all the info on one person
(contact info, actual interview notes, and ratings) could this then be
printed in one piece?
Click to expand...

Of course, you can join the various Tables in a Query and use the Report's
Sorting and Grouping Properties to determine the hierarchy of display. Or,
you could use a Subreport Control on the main Report, as described above for
Form/Subform.

Larry Linson
Microsoft Access MVP
 
Stilla said:
Hi.. I'm new Access learner... I have an opportunity to possibibly use
Access, and this would make my learning more "real" - but I'm not
sure if I'm thinking straight..here's what I'd like to do in a
nutshell, and the doubts I'm having.

Set up a "form" in Access where I can enter Interview notes relating
to specific topic areas asked about during an interview. THEN, I'd
like to set up a rating scheme so that those answers can be reviewed
and rated on some criteria. Those ratings would then be stored in a
table that is downloadable for analysis in Excel.

Doubt#1: As I reviewed the basics, it seems that there is a limit of
225 or so characters for Text Boxes. Interview notes may run longer
than that.
Click to expand...

Use a memo filed. I doubt if you can write enough to fill that.
Doubt #2: I'd like to have a top part of the form with
name, company, date..etc. , - but can this info be displayed on a
different "page" of the record??
Click to expand...

I am not sure want you mean by a different page and what information you
are talking about, but I strongly suspect that the answer is yes.
Doubt #3: Printing...if I want to print out all the info on one person
(contact info, actual interview notes, and ratings) could this then be
printed in one piece?
Click to expand...

No problem. I would suggest using a report.
 
Stilla wrote:
{snip}
Doubt #2: I'd like to have a top part of the form with name, company,
date..etc. , - but can this info be displayed on a different "page" of the
record??
Click to expand...
{snip more}

I'll hazard a guess here and tell you that what you need could be
satisfied with a form header. That way if you have a form that needs
to be scrolled, the name of the person will reliably stay visible at
the top. Or, if you use tab control pages, you can place the name of
the person/company on the form above the tab control object so that the
info remains always visible.
 
BOY!! GEE!! Thanks for all the responses you guys!!! I feel smarter already!
Maybe I'll try to tackle this after all!!
 
Stilla said:
Doubt #2: I'd like to have a top part of the form with name, company,
date..etc. , - but can this info be displayed on a different "page" of the
record??
Click to expand...

Are you thinking of a tabbed interface?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Back
Top