Interview Q&A

• Why doesn't my new password work in my FrontPage web?

  Loading and changing passwords in FrontPage is a little more complicated than with FTP programs. To set or change passwords, you'll need to log on to your current web in order for the security menu choice to be active.

• Are all of the features available in FrontPage supported on my site?

  FrontPage was created for developing websites in the Windows environment, so the following features are not available on our UNIX servers: * Active Server Pages * ODBC and MS SQL Database connections (Access, FoxPro) * Acti...

• What is the scope of technical support for FrontPage?

  * We will provide support related to the functionality of the extensions. * We will point FrontPage users to resources that will help you solve problems, publish your FrontPage webs and learn techniques for getting the most from your...

• What is Design Checker?

  Design Checker is a great option to use, all it does is go through your Publisher creation and check if there are any errors and advise you to make correction, it works almost the same way as spell checker. 1. Click on Tools 2. Select Des...

• Can I use Mail Merge in Publisher?

  Yes you can, just click on Mail and catalog merge under the Tools menu bar and you can either open an existing data source, or create one.

• How can I bring objects backward/forward?

  1. Click Arrange, make your choice 2. You can also use the shortcut available on the menu bar.

• How do I insert Line/border?

  1. Select the page that you want to add the border to. 2. On the Objects toolbar, click Rectangle, and then drag on the page to draw a rectangle the size that you want the page border, for example to the page margins. 3. Select the rectan...

• How do I insert a Picture into Publisher?

  You do have the choice of entering pictures other than Clip art into your Publication, you can also enter pictures that you found on the net, or that you created. 1. Go to Insert, then click on Picture 2. Click on From File, then just l...

• How do I move objects?

  1. Click on the pointer tool (on the left side of your screen) 2. Left click on the object you want to move 3. Drag the object to its new location If you wish to move more than one object at a time you can hold down the SHIFT key while...

• How do I place a picture on a specific area?

  1. Click on the Picture Frame Tool (on the left side of your screen) 2. Select the area where you'd like to place your picture (by holding down the left side of the mouse) 3. Insert the picture that you would like to have on your page (cl...

• What are my options for inserted objects?

  You can insert objects from various different photo editors such as Adobe PhotoShop, Bitmap images, Corel and also Excel Spreadsheets etc. 1. Click Insert 2. Select Object (the list of options will show, you make your choice)

• How do I enter text into a page?

  You need a text frame before you can type text into your publication. 1. Click on the Text Frame Tool - 2. Click on the space where you want to put your text. 3. Start typing.

• How do I start a Publication?

  1. Click on the wizard of your choice (in the left column). 2. Go to your right and click the template you want. 3. Click on Start Wizard located at the bottom of the page. 4. Then follow the instruction on your left side.

• How do I open Microsoft Publisher?

  1. Click on the Common Applications folder on the desktop. 2. Double click on the Publisher icon.

• What is MS Publisher?

  Publisher is used to manipulate text and graphic on a page for making flyers, greeting cards, business cards, etc. It also includes a PageWizard Assistant utility that guides you step-by-step in creating a publication. It also includes temp...

• What is MS Publisher?

  Publisher is used to manipulate text and graphic on a page for making flyers, greeting cards, business cards, etc. It also includes a PageWizard Assistant utility that guides you step-by-step in creating a publication. It also includes temp...

• How do I print my presentation?

  1. Click on the Office button in the upper left corner. 2. When you do that, there will option to preview what you will print. Click print. 3. Click the mouse button on the downward arrow to view the print options.

• How do I animate objects?

  1. Go to the Animation option. 2. Choose Custom Animation. 3. Select object(s) needed to be animated. 4. Click on Effects. 5. Under Entry Animation and Sound, click on the drop down arrow and choose preferred animation. 6. Choose any s...

• What is a slide transition and how can I create transitions?

  Slide transition is the action in which a slide appears on the screen as one slide is removed is the transition. 1. Go to the slide for which you want to create a transition. 2. In the main menu, click Animation. 3. There are different...

• How do I view the slide show?

  1. Click on the slide show tool (located at the bottom left of the screen). The slide displays in full view on the screen. 2. To advance through the slides, click the mouse button, press enter. or the right arrow key. 3. To move backwards...

• How do I move a slide?

  1. While on the Slide Sorter, select a slide by clicking on it. 2. While holding the mouse button down, drag slide one so that it is positioned after slide three. 3. A vertical line will appear to the right of slide three. When this line...

• How do I delete a slide?

  1. While on the home option, click on a slide you want to delete. 2. Click on the delete button.

• What is a slide sorter?

  Slide Sorter enables you to view many different slides at once. It can also be used to delete, add, and move slides around. Choose the slide sorter view by clicking on the tool with four boxes on it (located in the bottom left corner of the...

• How do I add a slide?

  1. Click on the new slide icon in the home option. 2. Scroll down to New Slide. 3. Choose a Layout and Click OK. 4. Add three more slides for practice.

• How do I change my background?

  Solid color background: 1. Go to Design on the first toolbar. 2. Click on the Background option located to the right. 3. Click on the Background styles option. 4. Drop the arrow and choose a color. 5. Click on Apply to All. Picture ba...

• How do I enter text into a document?

  1. Select the font. 2. Select the font size. 3. Click on the Insert option (located at the top left). 4. Then click on the Text option and then Text Box. This tool enables you to enter text. 5. Place the cursor where you want to beg...

• How do I save my presentation?

  1. Go to the upper left corner to the Office button. 2. Scroll down to Save As. 3. Select the location of where you want to save your file in Save in:. 4. Type the name of your file on File name:. 5. Then click Save or just press Enter.

• How do I create a new presentation?

  1. Go to the upper left corner to the Office button and click on New. 2. Choose the Title slide layout from the different Layout selections To see the Slide Setup menu: • Click on Design and then Page setup. Changes are made in a dialog...

• How do I open PowerPoint?

  1.Click on the Common Applications icon on the desktop (located on the top-left corner). 2.Double click on the icon entitled Microsoft Office Microsoft PowerPoint 2007.

• What is PowerPoint?

  PowerPoint is used to create a slide presentation which you can include clip art, photographs, sound, and video clips. PowerPoint also lets you enhance and move text, making your presentations very attractive to watch.

• I am using the Switchboard Manager in MS Access. I am getting an error message "There was an error executing this command."

  The Switchboard manager in MS Access offers only limited information on errors that occur within the database. Execute the selection directly from the database window to get more detailed information on the error.

• When I assigned a primary key to my table in Microsoft Access, I was expecting my data to be sorted. Am I using the correct procedure?

  Some developers occasionally rely on indexes to sort their data, but shouldn't. That's because an index is an internal Jet operation that relies on internal rules to speed sorting, which is not the same as actually performing the sort. Reco...

• Would you like to easily automate your MS Access database through menu driven selections?

  This can be accomplished by creating a form with customized buttons that point to macros. An easier way is to use MS Access' built in function called "Switchboard Manager". This can be located in Tools/Add-Ins.

• What is the size limitation of an Access database?

  Size limitation does not pertain to number of records in a table within a database. Forms, reports, macros, and modules also contribute to database size, but is rather minimal compared to tables containing records. It is recommended that if...

• How can I open an MS Access database that has been converted to a current version?

  MS Access is not backwards compatible. A workaround to share tables between different versions of MS Access would be to link the tables between two different databases. All objects in the database would not be available.

• In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

  In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.

• In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

  In the date field properties of the table, form, or properties manually input the format you would like. It is not required to choose one of the date formats in the drop down box. Example would be mm/dd/yyyy.

• I am designing an Access database form. How can I get my next control in the form to be automatically selected?

  By default, Access waits until you press Enter before it selects the Next control on your form. However, this is a wasted keystroke you can eliminate by setting each control's Auto Tab property to Yes. This Property also requires that you s...

• What is the maximum size of a database that can be opened in Microsoft Access?

  1 Gigabyte

• What format should my database be saved in to allow different versions of Microsoft Access to open the database?

  MS Access is not backwards compatible. To share tables between different versions of MS Access, you can link the tables between two different databases. However, only the tables in the converted database would be available.

• What format should my database be saved in to allow different versions of Microsoft Access to open the database?

  MS Access is not backwards compatible. To share tables between different versions of MS Access, you can link the tables between two different databases. However, only the tables in the converted database would be available.

• How do I put password to protect my entire Spreadsheet so data cannot be changed?

  1. Click Tools 2. Scroll down to Protection, then Protect Sheet 3. Enter a password, Click OK 4. Re-enter password, Click OK

• What is Freeze Panes and how do I do it?

  1. Row - Select the row below where you want the split to appear 2. Column - Select the column to the right of where you want the split to appear 3. Go to the Menu Bar 4. Click Windows and then click Freeze Panes

• How do I Format data?

  1. Must Always highlight the data before formatting 2. Click Format 3. Then go to Cells

• How do I resize Columns and Rows to better fit the data?

  1. Move the mouse in between any two labels (Rows/numbers or Columns/letters) 2. The pointer will turn into a vertical (letters) or horizontal (numbers) line with arrows on both ends 3. Simply drag the column or row to the desired size

• How do I combine different chart types into my Excel spreadsheet?

  To combine chart types, follow these steps: 1. If the Chart toolbar isn't already displayed, right-click any Toolbar and select Chart. 2. On the chart, click the series you want to change. 3. On the Chart toolbar, click the arrow next to th...

• Using Excel is there a way to close all open Excel files at once instead of closing them one at a time?

  Yes, you can close down all your Excel files at once by using the following instructions: 1. Hold down the Shift key. 2. Choose File + Close All from the menu. Holding down the Shift key changes Excel's File + Close command to a File + Clos...

• I have converted my MS Access database to a current conversion. I am getting conversion errors.

  Design specs have changed in new releases of MS Access. Visit the on-line help option for "conversion and compatibility" that explains different portions of Access databases that will have difficulty converting. Some reprogramming may be re...

• Is there a way to apply the same formatting to every sheet in a workbook in Excel?

  Yes. To do this, you will need to right click on one of the worksheet tabs and then choose Select All Sheets. After you do this any formatting that you apply or text you enter will show up on all the sheets in your workbook. In order to eli...

• How can I identify which cells in my spreadsheet have a formula and which do not in MS Excel?

  Option A: 1. Choose Edit + Go To (or press Ctrl + F5). 2. Select Special. 3. Select Formulas. 4. Click OK. Option B: 1. Choose Tools + Options. 2. Select the View Tab 3. In Window Options choose the check box 'Formulas'. 4. Click OK