Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Building a database/interface

word excel database

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
Hey everyone,

Is there any way to create a database of categorised sentences in Office, that I can use to populate a document?

E.g. if the document was a review for a car magazine: have a number of prewritten sentences or phrases under various categories like 'loud engine' or 'good value' and put all these categories into a choose-able list. Then when I select the various categories, it populates a template document with the right content.

Is there a way of doing this in Office, or would I have to go elsewhere, and if elsewhere then where!

I have tried dropdown boxes on Word as well as Macros that work fine, just not as well as it could be.

Maybe I've bitten off more than I can chew. Thanks for any help you could give me!
  • 0




    Founder Geek

  • Administrator
  • 24,549 posts

In Word there are a couple of ways:


  • Insert with AutoCorrect: Select a block of text that you want to populate. In the ribbon click File -> Options. In the Word Options dialog click Proofing and then Auto Correct Options. In Replace, enter a phrase to type that will auto populate the selected text. Best to start your phrase with a special character to prevent inserting it accidentally.
  • Insert with Quick Parts: Select the text you want to populate. In the ribbon choose the Insert tab. Next click Quick Parts and choose Save Selection to Quick Part Gallery. To auto-populate click Quick Parts and click an entry from the gallery. You can also right click Quick Parts choose Add to Quick Access Toolbar. You'll find it just above the ribbon at the top of the window.

There are also a couple apps that can do similar functions.

  • 0

Similar Topics

Also tagged with one or more of these keywords: word excel, database

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP