I’m not sure what I did, but now my ribbon bar and options have disappeared. Can you help me get it back? It’s only happening in Microsoft Word. I’m a Log on to Learn member and couldn’t find a specific video that addresses this. Thanks! We’ve received this question a few times so, we thought we’d share it here in our blog.

This is what the member was seeing when looking at their screen in Microsoft Word.

 

This is what the member wants to get back.

 

This is a common problem. A user has closed the ribbon bar without knowing how they did it and they need to get the ribbon to display again. First, don’t feel silly, this isn’t the first time a user has contacted us. In fact since it’s a popular item, we’ve created a video and I’ve included a link at the bottom of this thread. I’ll note the step-by-step process here for you as well.

Minimize the Ribbon (Microsoft Office 2010)

1. Click the Minimize Button located in the upper-right corner just below the X (close button). This button is a toggle, click once to minimize, click again to restore.

 

 

 

 

or

2. Right click on the Ribbon and choose Minimize the Ribbon.

or

3. Use the Keyboard shortcut, Ctl+F1

Additionally, you can watch the video below.

 

Microsoft Word Warriors cannot be bothered with flipping through style books or typing bibliographies.  Mastery of Word leads one to discover the powerful tools behind the References Tab.  Users can build and manage a list of sources easily while Word does all the heavy lifting.  Inserting citations is a quick and seamless task, leaving the Warrior free to focus on analysis and research. This video shows you how to create citations, bibliographies and cross references.

 

Date ranges are a very common filter that database users  want to implement in their queries. For example, let’s say your company sells office supplies and your databases tracks customer orders. You want to run a monthly query that summarizes total orders.

 

 

 

 

You can save your database users time and frustration by creating a friendly, interactive form that allows them to enter a beginning order date and an ending order date. Then, with a click of a button, they can run a query that displays the order information for their specified date range.

Follow these steps (in Access 2007 or Access 2010):  Or click the PDF Icon to Download these steps in PDF format.

 

 

 

1. On the Create tab, click Form Design in the Forms group.

 

 

 

2. In the Form Design window, the Form Design Tools Group is now active.

3. In the Controls group, click the Text Box to add a text box to the form.

 

 

4.  Add a second text box to the form.

5. Change the caption in the label to be more descriptive (for example, Begin Order Date). Modify the second label (for example, End Order Date).

 

 

 

 

 

 

6. Click the “Unbound” portion of the first text box.

7. Make sure the Property Sheet pane is displayed on the right side of screen. Click Property Sheet, if the Property Sheet pane is not displayed.

 

 

 

 

 

 

 

 

8. On the Property Sheet, click the All tab.

9. Change the Name property to be descriptive (for example, txtBeginOrderDate).

10. Change the Format property to Short Date.

11. Click on the second “unbound” text box and change its Name and Format properties.

12. Save the parameter form. You can keep the parameter form open, since we’ll add a command button to it as our last step.

Modify the Query to Receive the Date Range Values from the Parameter Form

1. Open your query in Design View, or create the query, then switch to Design View.

2. In the Criteria row of the appropriate date field, right-click and select Build…

 

 

 

 

 

 

 

3. The Expression Builder is now displayed. In the upper area, we’ll build an expression that selects the orders between a begin date and end date that’s entered in the parameter form.

4. Type the word between (followed by a space).

5. In the lower half of the Expression Builder, click on the (+) sign to the left of the Database name to expand the list.

6. Click on the (+) sign to the left of Forms.

7. If your interactive form is still open, you can expand the Loaded Forms list. If you closed the interactive form, expand All Forms. Click on the parameter form name.

8. In the middle area (under Expression Categories), you’ll see both text box names that you created on the interactive form

9. Double-click on the Begin Date text box. In the top-half of the Expression Builder, your expression may look something like:

between Forms![ParameterForm]![txtBeginOrderDate]

10. After the Begin Date text box name, type the word and, then double-click on the End Date text box name.

11. Your final formula will look something like this:

between Forms![ParameterForm]![txtBeginOrderDate] and Forms![ParameterForm]![txtEndOrderDate]

12. Click OK to save and close the Expression Builder.

13. The expression you just created will now display in the Criteria row of your query.

14. Save your query and close it.

Final Step: Create a Command Button to Run the Query

1. Open your parameter form and switch to Design View, if needed.

2. On the Form Design Tools group, click the Design tab.

3. Click Button.

 

 

 

4. Click on the form to start the Command Button Wizard.

5. In the Categories list, click on Miscellaneous.

6. In the Actions list, click on Run Query.

7. Click Next.

 

 

 

 

 

 

 

 

 

8. Select your query and click Next.

9. Choose whether you want text or a picture for your button. Click Next.

10. Type a descriptive name (without spaces). For example, cmdRunOrdersDateQuery.

11. Click Finish.

12. Save your parameter form and test it out.

 

Click the PDF Icon to Download these steps in PDF format.

 

 

 

 

KnowledgeWave provides Access and SQL consulting services both on site and remotely. We’ve helped hundreds of clients turn their assortment of spreadsheets, external mailing lists and other documents into a streamlined, organized database. The result is more time to work on the things their businesses need from them and less time creating reports. Let us know how we can help you! Call us at 1-800-831-8449.

This is a great video from Ron Owens from the Microsoft Word Blog. Ron shows us how to use the co-authoring (simultaneous editing) tool in Word 2010. He notes that you can “Cut your all-nighter in half”. He’s not kidding! This video also highlights how authors can be in different locations utilizing SkyDrive, Microsoft’s Cloud storage solution. Our two cents, at just under three minutes this is a great video and worth the watch.

Video Link: http://office.microsoft.com/en-us/redir/va102757656.aspx

Unveiling Microsoft Office 2010 Web Apps

Product(s): Microsoft Office 2010
Audience(s): Business Professional.
Date(s): Wednesday, October 27, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Watch Out Google Apps; Microsoft Now Lets You Create, Edit, and Save Office Docs Online! One of the biggest new additions to Microsoft Office is the ability to use Web Apps to access your work from anywhere. These Apps are lightweight versions of Word, PowerPoint, Excel, and OneNote that are all accessible via desktop, mobile devices, and Web browsers Internet Explorer, Firefox, and Safari.

All of the apps offer enough basic features to work on the go. We think that many of you will find these apps very useful for edits, changes, and even sketching out ideas while away from the office. You can always transfer a document back to your desktop for further tweaks when you return to the office.

Join us in this 60 Minute Webinar where you will learn how you can create, edit, share, and store documents with others in Word, PowerPoint and Excel using Web Apps on line.

To Register: Click Here Fee: $99.00

Change the Appearance of Your Calendar: Change the Background Color

1. On the Tools menu, click Options, and then click Calendar Options.
2. Under Calendar options, in the Background color list, click the color that you want.

Notes:
* The color that you choose is applied to the Day and Work Week views. The Week and Month views use system background colors, which are gray and white, by default.
* The color that you choose is applied to weekday hours. A darker shade of the background color is applied to night and weekend hours.

Print Blank Calendars
You can use Microsoft Outlook to print a blank calendar. Blank calendars may be useful to take notes on or to consult when you meet to discuss a project with your team.

1. On the File menu, point to New, and then click Folder.
2. In the Create New Folder dialog box, in the Name text box, type a name for the folder.
3. In the Folder contains list, click Calendar Items.
4. In the Select where to place the folder list, click Calendar, and then click OK.
5. In Calendar, in the Navigation Pane under the My Calendars section, select the check box for the calendar you created.
6. On the File menu, click Print.
7. In the Print dialog box, under Print this calendar, click the calendar you created.
8. Select the print style options you want, and then click OK.

Make an Appointment or Meeting Private
1.  Create or open the appointment or meeting that you want to make private.
2. On the Appointment tab, in the Options group, click Private.

Important: You should not rely on the Private feature to prevent other people from accessing the details of your appointments, contacts, or tasks. To ensure that other people cannot read the items that you mark as private, do not grant them Read permission to your Calendar, Contacts, or Tasks folders. A person with Read permission to access your folders could use programmatic methods or other e-mail applications to view the details of your private items. Use Private only when you share folders with people whom you trust.

Propose a New Time for a Meeting

1. In the open meeting request, on the Message tab, in the Respond group, click “Propose New Time”.
*Note: If you open the meeting from your calendar, on the Appointment tab, in the Respond group, click Propose New Time.
2. Click either Tentative and Propose New Time or Decline and Propose New Time.
3. Click a time when all invitees are available.
4. Click Propose Time.
5. Click Send.
Microsoft Office Outlook 2007 sends a default message saying that you want to propose a new time but you have tentatively accepted the meeting. You can change this default message to say that you want to propose a new time, and that you are declining the meeting:

1. On the Tools menu, click Options, and then click Calendar Options.
2. In the Use this response when you propose new meeting times list, click the setting that you want.

*Note: You can also change this setting for individual meetings. In the open meeting request, on the Message tab, in the Respond group, click either Tentative and Propose New Time or Decline and Propose New Time. If you open the meeting on your calendar, on the Appointment tab, in the Respond group, click either Tentative and Propose New Time or Decline and Propose New Time.

Change all of the Slide Transitions in your Presentation

1. In the pane that contains the Outline and Slides tabs, click the Slides tab.
2. On the Home tab, click a slide thumbnail.
3. On the Animations tab, in the Transition To This Slide group, click a different slide transition effect.
To see more transition effects on the Quick Styles list, click the More button.
4. To re-set the slide transition speed, in the Transition To This Slide group, click the arrow next to Transition Speed, and then select the speed that you want.
5. In the Transition To This Slide group, click Apply to All.