Categories
Microsoft Office

Creating Reports in MS Access 2010

If you are required to share the information from your database with someone but you don’t want that person to work with your database you can consider creating reports. With reports you can easily organize as well as present data in a very reader-friendly and visually appealing format. MS Access 2010 will make it very easy to create as well as customize a report by using data from any query or table in your database. You can also download Applying Hyperlinks to your Text in MS Word 2016.

Creating Reports:

MS Access 2010 lets you create the reports from tables and queries. For creating reports you need to follow these simple steps.

  • 1st of all you need to open the table or query which you want to use in your report.
  • Select the Create tab from the ribbon and then locate the Reports group.
  • Now you need to click the Report command.
  • MS Access will create a new report based on your object.
  • Some of your data may be located in the other side of the page break. In order to fix this you need to resize the fields.
  • Select the field and then click and drag its edge till the field is of the desired size.
  • Repeat with additional fields until all your fields fit.
  • For saving your reports you need to click the Save command on the Quick Access toolbar.
  • Whenever prompted you need to type a name for your report and after that click OK.

Deleting Fields:

You may find out that your report has got some fields which you don’t want to view so you need to delete the fields. For deleting the fields you are required to follow these simple steps.

  • 1st of all you need to click any cell in the field which you want to delete.
  • Now press the Delete key for deleting the required fields.
Categories
Microsoft Office

Applying Hyperlinks to your Text in MS Word 2016

MS Word is an impressive and handy word processor which is being used worldwide by all and sundary. With MS Word you can create text documents easily and can edit them as well. With hyperlinks to your text you can have access to the websites and email addresses directly from your documents. There are various different ways of inserting hyperlinks into your documents. You can use Word’s automatic link formatting or convert text into a link which depends upon how you want the link to appear. Hyperlinks have got two basic parts which are the address (URL) of the webpage and the display text. MS Word often recognizes the email addresses as well as web addresses as you type them and will automatically format them as hyperlink after you press Enter or Spacebar. You can also learn about Fetching any Files on a Remote Computer with OneDrive.

Formatting Text with a Hyperlink:

  • 1st of all you need to select the text which you want to format as a hyperlink.
  • Now select the Insert tab and then click the Hyperlink command.
  • You will notice that the Insert Hyperlink dialog box will appear.
  • The selected text will appear in the Text to Display: field at the top.
  • On the Address: field you need to type the address which you want to link to and then click OK.
  • The text will be formatted as a hyperlink.
  • With these simple steps you will be able to apply hyperlink to your text.

Editing and Removing Hyperlinks:

For editing and removing the inserted hyperlink you need to right click the hyperlink and select either open, copy or remove form the menu that appear.