Populating a Word Document

In the past I have been able to write form letters that link to an Access
database. Using the database I can fill in the needed data.

I now want to expand that some.

I am a school teacher and want to use Access and Word (Office 2003) together
to make the task easier for me.

Consider a calendar such as:

M T W Th F
Block1
Block2
Block3
Block4
etc.

Each block is to include information about a lesson plan (subject,
objective, procedure, etc.). Each lesson plan is distinct from the others on
the calendar.

My thinking was to design a database to house the lesson plans. Each week I
would populate this calendar in Word (the Word document is mandated from the
district). But as I think this through, I do not know how to pull 40-ish
different lessons from the database to a single Word document. A form letter
pulls one record per document, this one is different than that.

Any ideas as to how to do this? It seems like there should be a way, I just
don't see it right now.

I appreciate the help.

You did not say how your data is organized.
My data was this --
ClassCode ClassID Date
1 48 6/16/2008
1 29 6/17/2008
1 57 6/18/2008
1 92 6/19/2008
1 93 6/20/2008
2 29 6/23/2008
2 48 6/24/2008
2 57 6/25/2008
2 92 6/26/2008
2 93 6/27/2008
3 29 6/30/2008
3 48 7/1/2008
3 57 7/2/2008
3 92 7/3/2008
3 93 7/4/2008
The queries below have one class per day per record.
Qry Classes_1 ---
SELECT Format([Date],"yyyy") AS Class_Year, Format([Date],"ww") AS
Class_Week, Format([Date],"w") AS Class_Day, Classes.ClassID,
Classes.ClassCode
FROM Classes;
Class_Year Class_Week Class_Day ClassID ClassCode
2008 25 3 29 1
2008 25 2 48 1
2008 25 4 57 1
2008 25 5 92 1
2008 25 6 93 1
2008 26 2 29 2
2008 26 3 48 2
2008 26 4 57 2
2008 26 5 92 2
2008 26 6 93 2
2008 27 2 29 3
2008 27 3 48 3
2008 27 4 57 3
2008 27 5 92 3
2008 27 6 93 3

SELECT Classes_1.ClassCode, Classes_1.ClassID AS Mon, Classes_1_1.ClassID AS
Tue, Classes_1_2.ClassID AS Wed, Classes_1_3.ClassID AS Thu,
Classes_1_4.ClassID AS Fri
FROM (((Classes_1 LEFT JOIN Classes_1 AS Classes_1_1 ON
(Classes_1.Class_Year = Classes_1_1.Class_Year) AND (Classes_1.Class_Week =
Classes_1_1.Class_Week)) LEFT JOIN Classes_1 AS Classes_1_2 ON
(Classes_1.Class_Year = Classes_1_2.Class_Year) AND (Classes_1.Class_Week =
Classes_1_2.Class_Week)) LEFT JOIN Classes_1 AS Classes_1_3 ON
(Classes_1.Class_Year = Classes_1_3.Class_Year) AND (Classes_1.Class_Week =
Classes_1_3.Class_Week)) LEFT JOIN Classes_1 AS Classes_1_4 ON
(Classes_1.Class_Year = Classes_1_4.Class_Year) AND (Classes_1.Class_Week =
Classes_1_4.Class_Week)
WHERE (((Classes_1.Class_Day)="2") AND ((Classes_1_1.Class_Day)="3") AND
((Classes_1_2.Class_Day)="4") AND ((Classes_1_3.Class_Day)="5") AND
((Classes_1_4.Class_Day)="6"));


ClassCode Mon Tue Wed Thu Fri
1 48 29 57 92 93
2 29 48 57 92 93
3 29 48 57 92 93
--
KARL DEWEY
Build a little - Test a little


"Shoelaces" wrote:

In the past I have been able to write form letters that link to an Access
database. Using the database I can fill in the needed data.

I now want to expand that some.

I am a school teacher and want to use Access and Word (Office 2003) together
to make the task easier for me.

Consider a calendar such as:

M T W Th F
Block1
Block2
Block3
Block4
etc.

Each block is to include information about a lesson plan (subject,
objective, procedure, etc.). Each lesson plan is distinct from the others on
the calendar.

My thinking was to design a database to house the lesson plans. Each week I
would populate this calendar in Word (the Word document is mandated from the
district). But as I think this through, I do not know how to pull 40-ish
different lessons from the database to a single Word document. A form letter
pulls one record per document, this one is different than that.

Any ideas as to how to do this? It seems like there should be a way, I just
don't see it right now.

I appreciate the help.

Well, I haven't put my lessons in the database, so I have flexibility there.
Looking at what you posted, I do not think that will work for me. I do thank
you for your suggestion.

My thinking is each record will be a separate lesson. I teach about eight
different lessons daily. The "schedule" I have to fill out would need
approximately 40 lessons weekly.

Getting the lessons into the database will not be an issue. Printing them
out individually will not be a problem. The problem I am seeing is how to
list 40 different lessons in one Word document.

The problem I am seeing is how to list 40 different lessons in one Word
document.
How much data will be within each lesson? Your post showed a calendar for
output which would not lend itself to very much data even in landscape format.
--
KARL DEWEY
Build a little - Test a little


"Shoelaces" wrote:

Well, I haven't put my lessons in the database, so I have flexibility there.
Looking at what you posted, I do not think that will work for me. I do thank
you for your suggestion.

My thinking is each record will be a separate lesson. I teach about eight
different lessons daily. The "schedule" I have to fill out would need
approximately 40 lessons weekly.

Getting the lessons into the database will not be an issue. Printing them
out individually will not be a problem. The problem I am seeing is how to
list 40 different lessons in one Word document.

"KARL DEWEY" wrote:

The problem I am seeing is how to list 40 different lessons in one Word
document.
How much data will be within each lesson? Your post showed a calendar for
output which would not lend itself to very much data even in landscape format.

The district has mandated the following fields in the "calendar", as I have
been calling it:

Topic:
Objective(s):
Standard: (NJCCCS):
Procedure(s)/Activities and Time Allocation:
1.
2.
3.
4.
Assessment(s)

The lesson plans I write will have far more information than this. The
document for the district is busy work and not something I will use.
Nevertheless, I need to complete it.

Linking the Word document to the database should make this a trivial task.
What I do not understand is how to put a unique lesson into 40 different
blocks in the same document if each lesson is a separate record in the
database.

I am returning to this project. I have made no headway since I last brought
it up.

Look at this template on microsoft.com:
http://office.microsoft.com/en-us/te...id=45#comments

This is similar to the Word doc my district will now require teachers to
use. Each block (periods) of the template will need to contain the following
information:
Topic
Objective
Standard
Procedures
Assessment

I have an Access (2003) database of my lessons that contains this
information. Each lesson is a single record in a table.

What I cannot figure out is how to merge 40 lessons to a single Word document.

I would appreciate any help you can offer.