Microsoft Office Archives

Outstanding Options in Microsoft Access

Craig Gerdes May 22, 2018

Customized Keyboard Shortcut Keys Many users find that keyboard shortcuts for Access helps them work more efficiently. In the previous blog, we discussed some frequently used keyboard shortcuts. In this blog, we will discuss how to create customized keyboard shortcut keys. The AutoKeys macro assigns shortcut key combinations to a set of tasks. You can only create one AutoKeys macro in each database but you can create multiple submacros, with each submacro assigned a shortcut key combination. You must name the macro “AutoKeys” for it to work.

Microsoft Access Tips and Tricks

Craig Gerdes May 10, 2018

Symbols for Special/Custom Formatting To customize the display of numbers, dates/times, and text, use the Format property. For a field, you set this property in the Table Design View (in the Field Properties section) or in the Query Design View (in the Field Properties property sheet). For a control, you set this property in the control’s property sheet. The Format property affects only how the data is displayed, not how the data is stored.

Access Fantastic Features – Startup Options: Navigation Form and AutoExec Macro

Craig Gerdes April 17, 2018

A split database will very often use a Navigation Form on the front-end as the entry point for users. A good idea is to display the Navigation Form by default each time a user opens the database. This makes it easy for users to switch between the various forms and reports in the database without affecting the data tables stored and protected on the back-end. This blog will explain a simple process of creating a Navigation Form by adding buttons to display forms and reports and then configuring options to display the Navigation Form at startup instead of the navigation pane. In addition, a brief discussion will describe a more advanced process of Navigation Form design that opens database objects (including queries) and shows a message (if preferred) at startup.

2018 Microsoft Product Roadmap Summary

Centriq Training March 8, 2018

(Original content provided by Gladys Rama/ Redmond Channel Partner) “It’s promising to be a busy year for Microsoft watchers, with major version releases on tap for some of the company’s most venerable product lines. Here are the biggest milestones to watch out for.” Every year Redmond Channel Partner puts out the Microsoft Product Roadmap, which provides a comprehensive guide to upcoming Microsoft product updates and new product releases. Centriq’s summarized this information for you, providing an overview of version updates, next-gen releases and brand new releases, as well as anticipated release dates.

Outstanding Options in Microsoft Word

Craig Gerdes January 2, 2018

If you have not spent much time reviewing the options and settings in Word, that is unfortunate because you can really customize Word to your own personal preferences and work situation. This blog will share some examples of the things you can do with options and settings. Perhaps these “gold nuggets” will encourage you to explore other options and settings that might be helpful to you.

Awesome Add-ins for Word

Craig Gerdes December 19, 2017

An add-in is a term used for a software utility added to a primary program. In other words, add-ins are mini applications that extend what you can do with Microsoft Office programs, such as Word. When you enable an add-in, it adds custom commands and new features that help increase your productivity. By default, add-ins are not immediately available, so you must first install (and in some cases activate or configure) these add-ins so that you can use them. Many of the add-ins are free from the Microsoft Store (https://store.office.com). You may also be able to search for add-ins from third party vendors.

Microsoft Word Terrific Tips Tricks Blog

Terrific Tips and Tricks in Microsoft Word

Craig Gerdes November 27, 2017

Since Microsoft Word is one of the most frequently used software programs, people assume they know everything there is to know. Therefore whenever you find new and cool things you can do in Word, it is an awesome treat. I have been teaching Microsoft Word for years and it seems like I learn new and cool things (or maybe remember old, useful things) frequently. Here are some of my most recent favorites that I thought you might enjoy:

Word Fantastic Feature: Creating Forms using Interactive Controls

Craig Gerdes November 9, 2017

The ability to create customized, interactive forms to collect data is a powerful, but often underutilized feature of Word. In this blog, we will discuss how to create electronic forms using form controls such as text content, drop-down list, and check box. In addition, you will learn how to protect the form and collect data.

Terrific Tips and Tricks in PowerPoint: Learn to Present Like a Pro

Craig Gerdes October 23, 2017

There is no shortage of tips for creating and delivering an effective presentation in PowerPoint. Just search the web and you will find lots of advice. Here is Microsoft’s official article on the subject. My goal for this blog posting is not to repeat some of the generic information and suggestions out there but to provide less common tools, applications, and tricks such as: Using tools and shortcut keys for screen and cursor options Utilizing special applications such as Mix (Free Add-in) and Office Presentation Service (Free Option) Employing special tricks like hiding slides and creating custom shows

Awesome Add-ins for PowerPoint

Craig Gerdes October 9, 2017

An add-in is a term used for a software utility added to a primary program. In other words, add-ins are mini applications that extend what you can do with Microsoft Office programs, such as PowerPoint. When you enable an add-in, it adds custom commands and new features that help increase your productivity. By default, add-ins are not immediately available, so you must first install (and in some cases activate or configure) these add-ins so that you can use them. Many of the add-ins are free from the Microsoft Store (https://store.office.com). You may also be able to search for add-ins from third party vendors.

Start Date	End Date	Day/Eve	Break Weeks	Track
Jan 23, 2023	Jul 27, 2023	Eve	4/3/23-4/7/23 5/22/23-5/26/23 7/3/23-7/7/23	CSSP-V
Jan 30, 2023	May 5, 2023	Day	3/6/23-3/10/23 4/10/23-4/14/23	CSSP-V
Feb 6, 2023	May 19, 2023	Day	3/27/23-3/31/23	FSCP-V
Mar 20, 2023	Jun 23, 2023	Day	4/24/23-4/28/23 5/22/23-5/26/23	CSSP-V
Apr 10, 2023	Jul 28, 2023	Day	5/29/23-6/2/23 7/3/23-7/7/23	FSCP-V
Apr 24, 2023	Oct 19, 2023	Eve	7/3/23-7/7/23 8/21/23-8/25/23	CSSP-V
May 15, 2023	Dec 14, 2023	Eve	7/3/23-7/7/23 9/4/23-9/8/23 11/20/23-11/24/23	FSCP-V
Jun 5, 2023	Sep 8, 2023	Day	7/3/23-7/7/23 8/7/23-8/11/23	CSSP-V
Jun 19, 2023	Oct 6, 2023	Day	7/3/23-7/7/23 9/4/23-9/8/23	FSCP-V
Jul 24, 2023	Jan 25, 2024	Eve	10/2/23-10/6/23 11/20/23-11/24/23 12/25/23-12/29/23	CSSP-V
Aug 14, 2023	Nov 17, 2023	Day	9/5/23-9/8/23 10/16/23-10/2/23	CSSP-V
Aug 28, 2023	Dec 15, 2023	Day	9/4/23-9/8/23 11/20/23-11/24/23	FSCP-V
Oct 30, 2023	Feb 2, 2024	Day	11/20/23-11/24/23 12/25/23-12/29/23	CSSP-V
Oct 30, 2023	May 2, 2024	Eve	11/20/23-11/23/23 3/4/23-3/7/23	CSSP-V
Nov 6, 2023	Mar 1, 2024	Day	11/20/23-11/24/23 12/25/23-12/29/23 1/29/24-2/2/24	FSCP-V

Start Date	End Date	Day/Eve	Break Weeks	Track
Feb 13, 2023	Mar 19, 2023	Day	3/20/23-3/24/23 4/17/23-4/21/23	CSSP-I
Apr 17, 2023	Jul 21, 2023	Day	5/22/23-5/26/23 7/3/23-7/7/23	CSSP-I
Jun 5, 2023	Sep 8, 2023	Day	7/3/23-7/7/23 8/7/23-8/11/23	CSSP-I
Jul 31, 2023	Nov 3, 2023	Day	9/4/23-9/8/23 10/2/23-10/6/23	CSSP-I
Sep 25, 2023	Dec 22, 2023	Day	11/20/23-11/24/23	CSSP-I
Nov 27, 2023	Mar 1, 2024	Day	12/25/23-12/29/23 1/29/24-2/2/24	CSSP-I

Start Date	End Date	Day/Eve	Break Weeks	Track
Jan 16, 2023	Apr 21, 2023	Day	2/2023-2/24/23 3/20/23-3/24/23	CSSP-I
Jan 23, 2023	Jul 27, 2023	Eve	4/3/23-4/7/23 5/22/23-5/26/23 7/3/23-7/7/23	CSSP-I
Feb 27, 2023	Jun 2, 2023	Day	4/3/23-4/7/23 5/1/23-5/5/23	CSSP-I
Apr 10, 2023	Jul 14, 2023	Day	5/15/23-5/19/23 7/3/23-7/7/23	CSSP-I
May 22, 2023	Aug 18, 2023	Day	7/3/23-7/7/23	CSSP-I
Jun 26, 2023	Sep 29, 2023	Day	7/3/23-7/7/23 8/7/23-8/11/23	CSSP-I
Aug 7, 2023	Nov 10, 2023	Day	9/4/23-9/8/23 10/9/23-10/13/23	CSSP-I
Sep 11, 2023	Dec 15, 2023	Day	10/16/23-10/20/23 11/20/23-11/24/23	CSSP-I
Oct 23, 2023	Jan 26, 2024	Day	11/20/23-11/24/23 12/25/23-12/29/23	CSSP-I
Oct 30, 2023	May 2, 2024	Eve	11/20/23-11/23/23 12/25/23-12/28/23 3/4/24-3/7/24	CSSP-I
Dec 4, 2023	Mar 8, 2024	Day	12/25/23-12/29/23 2/5/24-2/9/24	CSSP-I