If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Populating a Word Document
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. |
#3
|
|||
|
|||
Populating a Word Document
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. |
#4
|
|||
|
|||
Populating a 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. |
#5
|
|||
|
|||
Populating a 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. |
#6
|
|||
|
|||
Populating a Word Document
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. |
Thread Tools | |
Display Modes | |
|
|