Microsoft Office Tips, Tricks, and How-to's to help you use MS Office like a pro!

Carol's Corner Office

Category Archives: Subscribers Office 365

Subscribers: How To Create A New Table In A New Database in Access

Posted on by Posted in Subscribers Office 365 Leave a comment

A simple database like say a Christmas card list, will most likely only use one table in Access. Once you create a new database, your creation is a new filet hat lives on on your computer and acts as a container for all of the objects in your database, including your tables.

You can create a table by creating a new database. You do this by inserting a table into an existing database, or by importing or linking to a table from another data source — such as a Excel workbook, a Word document, a text file, or another database.

When you create a new, empty database, a new, empty table will be automatically inserted . You can then enter data in the table to start defining your fields.

Follow the steps below to learn how:

  1. Click File | New.
  2. Select Blank desktop database.
  3. In File Name, key in an intuitive name for your new database.
  4. To browse to a different location and save your database, click the folder icon.
  5. Click Create.

Your new database will open, and a new table named Table1 will opens in Datasheet view.

Subscribers: How To Clear All Data Between Last Cell & Your Data

Posted on by Posted in Subscribers Office 365 Leave a comment

Ok you could go through your worksheet and manually delete everything between your last cell and your data, but you all know I would never in this world advocate doing such a thing. I am all about saving time and keystrokes and this time it is no different.

Follow the steps below to learn how:

Choose one of the methods below:

  1. To select all columns to the right of your last column containing data, click the first column heading, press and hold  CTRL, and then click the column headings of the columns that you would like to
  2. to select.
  3. But, you can also click the first column heading, and then press CTRL+SHIFT+END.
  4. To select all rows below your last row containing data, click the first row heading, hold down CTRL, and then click the row headings of the rows that you would like to select.

But wait, there’s more!

  1. You can also click your first row heading, and then press CTRL+SHIFT+END.
  2. On your Home tab, in the Editing group, click the arrow next to the Clear button Button image, and then click Clear All.
  3. Save your worksheet.
  4. Close your worksheet.

When next you open your workbook , the last cell of your data should be the last cell on the worksheet.

Subscribers: How To Highlight Table Text With Color in Word

Posted on by Posted in Subscribers Word 365 Leave a comment

There are myriad reasons why one would want to highlight table text with color.  It draws the eye to something you would like the viewer to see or it makes a reader look at the headings in your table.  Again, there could be many reasons why, but whatever the reason, today I will tell you how to do it.

Follow the steps below to learn how:

  1. Select the text you would like to highlight.
  2. Click the down arrow to the right hand side of Text Highlight Color.
  3. A color palette will appear.

text-highlighting

  1. Select the color of your choice.Word will highlight the text you previously selected  in your chosen color.
  2. Press ESC or click Text Highlight Color once more to turn off the Text Highlight Color command.

Subscribers: How To Format Table Cells in Google Docs

Posted on by Posted in Subscribers Word 365 Leave a comment

So in a previous post I told you how to resize the columns and rows in your Google Docs Table. In this post I will now tell you how to format the cells in that table.

Follow the steps below to learn how:

  1. Open your document containing the table whose cells you would like to format.
  2. Select the specific cells you would like to format.
  3. On the toolbar at the top of your document, click on the style you would like to format on your table.

You will see there are a variety of styles from which you can choose(i.e. border color,  width,  dash, and background color).

Again, very quick, easy and painless!

 

Subscribers: How To Resize Columns & Rows in Google Docs

Posted on by Posted in Subscribers Word 365 Leave a comment

I have written many posts detailing how to create and format tables in Microsoft Word. But lately, I have been receiving inquiries from folks concerning tables in Google Docs. So today I am going to try and help out the folks who have been asking questions in this regard.

Follow the steps below to learn how:

  1. Open your document containing the table that you wish  to resize.
  2. Right-click anywhere in your table, and a menu of options will appear.
  3. Select Table properties. A new set of options will appear.
  4. Under Dimensions, key in the height and width of your choice for your table.
  5. Click OK. Your table should now be resized to the height and width that you keyed in above.

It doesn’t get much easier than this folks!

Subscribers: How To Create A Report Using the Wizard in Access

Posted on by Posted in Subscribers Office 365 Leave a comment

In today’s post you will learn how to create a report using the Report Wizard.  I like the sound of that; don’t you? I mean who wouldn’t like to have a wizard around to do things you don’t necessarily know how to do or are afraid to try? And the good news is that you will most likely learn something in the process so you will not be afraid to venture further into Access and try different things!

Using the Report Wizard allows you to  be more selective about the fields that appear in your report. It also  allows you to specify how your data will be grouped and sorted, and you can use fields from more than one table, if you have specified the relationships between the tables beforehand.

Follow the steps below to learn how:

  1. On the Create tab, in the Reports group, click Report Wizard.
  2. Follow the directions on the Report Wizard pages.
  3. On the last page, click Finish.

Once finished, when you look at your report, you will see it as it will appear in print. You can also increase the magnification to zoom in on details.

I don’t know for sure, but I am thinking that this is too easy to not at least try! Let me know what you think!

Subscribers: How to Create A Report in Access

Posted on by Posted in Subscribers Office 365 Leave a comment

There can be many reasons why you may want a report when using Access.  In this post I am going to tell you how to create the easiest report you can.  It may not be fancy or finished looking, but it also will not prompt you for information. Why then am I telling you about this?  Simple, I want you to see just what Access can do for you and to give you your first  Access instructions.  Most of the folks I know have not ever looked at Access but it can be a very valuable tool or it can just make something a lot easier for you (i.e., I create my Christmas card list using it). So, let’s get to it then. We will be using the Report Tool today.

Follow the steps below to learn how:

  1. In the Navigation pane, click the table upon which you would  like to base your report.
  2. On the Create tab,In the Reports group,  click Report.
  3. Access will build your report for you and display it in Layout view.

Now I mentioned above that your report will not be polished or fancy looking didn’t I? Well here is the good news:

You can then save your report and modify it in Layout view or Design view so that it better serves your purposes.

Be on the lookout as there will be more posts on this subject.

Subscribers: How To Add A Chart to A Word 365 Document

Posted on by Posted in Subscribers Word 365 Leave a comment

Ever have a need to create a chart in Word? I know when I was in the working world, there were many, many times I was requested to do so. The first time I panicked but once I learned how it was a piece of case.

Having said that, you can make a chart in Word also, but, if you have a lot of data to be charted, you really should create your chart in Excel and then you can then copy from Excel to Word. This is also the most expedient method if your data changes often  and you want your chart to always reflect the latest data. In that case, when you copy the chart, keep it linked to the original Excel file.

But if you are creating a simple chart, follow the steps below to learn how:

  1. Click Insert | Chart, and select the chart you would like.
  2. Click the chart type and then double-click the chart of your choosing.
  3. In the spreadsheet that appears, replace the default data with your own information.
  4. When you insert your  chart, small buttons will appear next to its upper-right corner. You can use the Chart Elements button to show, hide, or format items such as axis titles or data labels. Or, you can use the Chart Styles Customize the Look of Your Chart button to quickly change the color or style of your chart. The Chart Filters button is a more advanced option that will show or hide data in your chart.
  5. Once you have finished, close your spreadsheet.
  6. Should you like, you can use the Layout Options button to arrange your chart and text in your document.

As you can see, this is a fairly simple process but it makes you look like a rock star when you quickly create that chart that was requested!

 

 

Subscribers: How To Evenly Place Your Table Rows

Posted on by Posted in Subscribers Office 365 Leave a comment

OK, you know what data you want to use in your table, and you think you have all your formatting in place. So now you start to input your data and you find that event though the height of your table seems correct and pleasing to the eye, your rows look funny.  Hmm, how to rectify this? You decide that it would look a lot more pleasing to the eye and be easier to navigate if your rows were the same height. The good news is, this is not terribly difficult to do.

Follow the steps below to learn how:

  1. Place your insertion point (cursor) someplace in your table.
  2. Click the Layout tab on your Ribbon.
  3. In the Cell Size group, click Distribute Rows.

You will notice now that Word has changed the height of your selected row(s).

Be aware though, that if things do not look exactly as you thought they should, it could be due to the fact that you used a larger or smaller size font in one of your cells.  This will affect your row height and you may have to fiddle with it to get it exactly the way you would like it.

Overall though, this is a very easy fix right?

Subscribers: How To Enable/Disable Macros in Office 365

Posted on by Posted in Subscribers Office 365

When I have something that I use over and over I simply create a macro to make my life easier and save me time and keystrokes.  You all know how I love to save time and keystrokes! And that is great, I’m all for it. Having said that, there can be and are bad macros out there and you need to be careful.  It is very easy for some miscreant to add some malicious code to a macro and it can cause you untold grief.  So be very, very careful of any Word document you download online or any that are sent to you via e-mail. It doesn’t matter how well you know the person, they may not be aware that they are sending you malicious code.  So be very discerning about macros.

By default, macros are disabled in Word and as a matter of fact, when you open a document that has a macro in it, Microsoft will send you a warning letting you know.

security-warnning

But it is very easy to enable them when you would like to. Once you receive that warning, all you have to do is click Enable Content and you’re in business!

  1. Another method to enable macros is to click on your File tab.
  2. Then on the left-hand side, click on Info.
  3. If your document contains macros, you will see a security warning section. Simply click Enable Content.
  4. A drop-down menu will appear. From there, click Enable  All Content.
  5. Now the macros will be enabled while you work on your document.
  6. Should you want to disable the macros, just close your document and reopen it.

Again, be very discerning when it comes to macros that you have not created!