(Msg. 1) Posted: Sun Jun 15, 2008 6:46 pm
Post subject: Populating a Word Document Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
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.
(Msg. 2) Posted: Mon Jun 16, 2008 12:55 pm
Post subject: RE: Populating a Word Document [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 3) Posted: Mon Jun 16, 2008 2:16 pm
Post subject: RE: Populating a Word Document [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 4) Posted: Mon Jun 16, 2008 3:32 pm
Post subject: RE: Populating a Word Document [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
>>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.
(Msg. 5) Posted: Mon Jun 16, 2008 5:29 pm
Post subject: RE: Populating a Word Document [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"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.
(Msg. 6) Posted: Fri Aug 29, 2008 9:08 pm
Post subject: RE: Populating a Word Document [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I am returning to this project. I have made no headway since I last brought
it up.
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.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other