Use Access for this?

[Stilla]

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

 

[Larry Linson]

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.

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??

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?

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

 

[betwalk]

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??

{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.

 

[Stilla]

BOY!! GEE!! Thanks for all the responses you guys!!! I feel smarter already!
Maybe I'll try to tackle this after all!!

 

[Tony Toews]

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??

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