Microsoft Office Professional 2007 Full Version for PC Logo
Posted on Apr 13, 2008
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Create a MS Word Report

A newbie here..How Can I prepare a report to Word from Access File?

1 Answer

Anonymous

Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Champion:

An expert who has answered 200 questions.

  • Expert 214 Answers
  • Posted on May 12, 2008
Anonymous
Expert
Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Champion:

An expert who has answered 200 questions.

Joined: Apr 07, 2008
Answers
214
Questions
0
Helped
66790
Points
499

This from the Word Help files - search for Embed.

You can simply select an area in Excel copy it and paste it into your word document, but embedding allows the data in your Word document to be automatically updated as you change the figures in the Excel Worksheet.

From the Help pages:

You can insert objects (object: A table, chart, graphic, equation, or other form of information. Objects created in one application, for example spreadsheets, and linked or embedded in another application are OLE objects.) into a Microsoft Word document when you want to include information from files created in other Microsoft Office programs or in any program that supports linked objects (linked object: An object that is created in a source file and inserted into a destination file, while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated.) and embedded objects (embedded object: Information (object) contained in a source file and inserted into a destination file. Once embedded, the object becomes part of the destination file. Changes you make to the embedded object are reflected in the destination file.).
create a MS Word Report - default.aspx?assetid=za060473201033 Embedded object
default.aspx?assetid=za060474661033 Linked objecreate a MS Word Report - default.aspx?assetid=za060474671033/default.aspx?assetid=za060474671033" alt="default.aspx?assetid=za060474671033" class="h_mi" /> Source file
For example, a monthly status report might contain information that is separately maintained in a Microsoft Excel worksheet. If you link (link: Used to insert a copy of information created in one program into a Microsoft Word document while maintaining a connection between the two files. When the information changes in the source file, the changes are reflected in the destination document.) the report to the worksheet, the data in the report can be updated whenever the source file (source file: The file that contains information that was used to create a linked or embedded object. When you update the information in the source file, you can also update the linked object in the destination file.) is updated. If you embed (embed: To insert information created in one program, such as a chart or an equation, into another program. After the object is embedded, the information becomes part of the document. Any changes you make to the object are reflected in the document.) the worksheet in the report, your report, or destination file (destination file: The file that a linked or embedded object is inserted into. The source file contains the information that is used to create the object. When you change information in a destination file, the information is not updated in the source file.), contains a screate a MS Word Report - default.aspx?assetid=za790050001033>default.aspx?assetid=za790050001033The differences between linked objects and embedded objects
The main differences between linked objects and embedded objects are where the data is stored and how you update the data after you place it in the destination file.
Linked objects When an object is linked, information is updated only if the source file is modified. Linked data is stored in the source file. The destination file stores only the location of the source file, and it displays a representation of the linked data. Use linked objects if file size is a consideration.
Linking is also useful when you want to include information that is maintained independently, such as data collected by a different department, and when you need to keep that information up-to-date in a Word document.
When you link to an Excel object, you can use the text and number formatting from Excel, or you can apply the formats supplied by Word. If you use the Word formats, you can preserve formatting when the data is updated. For example, you can change table layout, font size, and font color without losing those changes once the object in the source file is updated.
Embedded objects When you embed an object, information in the destination file doesn't change if you modify the source file. Embedded objects become part of the destination file and, once inserted, are no longer part of the source file.
Because the information is totally contained in one Word document, embedding is useful when you want to distribute an online version of your document to people who don't have accecreate a MS Word Report - default.aspx?assetid=za790050001033sheets.
default.aspx?assetid=za790050001033Edit and update linked objects
To edit a linked object in your document, use the Links command on the Edit menu.
By default, linked objects update automatically. This means that Word updates the linked information every time you open the destination file or any time the source file changes when the destination file is open.
If you prefer, you can change a linked object's setting so that the linked object is updated only when you choose to manually update it.
To ensure that your document is always up-to-date, you can also update linked objects whenever you print the document.
To prevent updates, you can lock individual linked objects. When you lock a link, Word uses the last information available from the source file.
You can also permanentcreate a MS Word Report - default.aspx?assetid=za790050001033inked object and its source file.
default.aspx?assetid=za790050001033Edit embedded objects
To edit an embedded object, double-click it, and then make changes to it in the source program (source program: The program used to create a linked object or embedded object. To edit the object, you must have the source program installed on your computer.). If you don't have the source program, you can convert the embedded object to the file format of a program you do have.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

Gudpm po im asking about how to open my open offices file again..last feb 15 i open my company pc the file has corrupted... tnx.....

If your company was using MS Office 2003 then you're using MS Office 2007. Make sure you're saving the file in a compatible format. For example, if you've create a report on excel file using MS Excel 2007 then you should save the file in .xls (compatible format) instead of .xlsx (2007 format. In that case you can open your file on both versions. Also when you're saving other office files make sure it's in compatible format.
0helpful
1answer

Print labels created in ms access

first check your driver for zebra 2844 it is compatible with the OS, if it's Ok may be you can find third party software that help us create label
0helpful
1answer

Problem in creating report

Crystal Reports comes bundles with VB6 and is a good choice fro reports. Regards -- Joe
0helpful
1answer

How to print picture wiht crystal report 8.5 using ms access ?

I am not sure if I understand your question correctly but here goes..

if you want to click on a link within crystal report and them show the picture you can use OLE..
in the tools menu click on OLE, select "Create From File" ,
select the object type eg: MS bitmap.
Select Link
Browse to folder where the image exists. and select it
you can now select a Icon or leave as is and it will display the image name..
Clikc OK

now when you run CR if you click on that link it will open and display the image..

if you just want to add a Image to CR
in the Tools Meni select Insert, Picture browse to the folder where the image is stored and select it then click OK and it will be displayed

I hope this helps



4helpful
3answers

Primavera P6

I am new in P6. I have a problem that how can we add target in any project like P3? Can u please help me.
0helpful
1answer

How to Justify Text of a label (memo type filed) in a Report

In relidad not understand exactly your probrema but would request that you specify.
For more information write to [email protected]
0helpful
1answer

MS access - how to insert a function in a access table

Have you reached resolution yet? If not I would be happy to help otherwise, I would be interested to know what happened. It sounds like you need to call the date (today) for the appropriate balance to come in automatically - assuming you have a table holding this data. Thanks for rating FixYa!
0helpful
3answers

Ms access

before this u should know what is databse.
ms access has various objects likw table,form,query,report etc..
table is a object which stores the actual data and form is used to enter the data in to the table and display the data from the table, while report is object which is used to desplay your data in required formate.Query is used to fetch the data from the table in customised formate.for that u should have knowledge of SQL.
Not finding what you are looking for?

313 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...