Thursday, August 31, 2017

Manage Data Tasks - Dialog

Manage Data Tasks - Dialog

Use this Manage Data Tasks dialog box in Access to view and manage the import and export operations (also known as specifications) that you have created for the current database. When you run either the various import and export wizards, you can save the operation as a specification for future use.

Saved Imports and Saved Exports tabs

To view the Manage Data Tasks dialog in Access click External Data > Saved Imports or External Data > Saved Exports. You can click either of the tabs on the dialog box to switch between the saved import and saved export specifications.

To change the name of the specification, its description, and the path and file name of the source or destination file, do these steps:

  • Edit the specification name by clicking it and then making your change in the text box. Press ENTER to save or ESC to cancel your changes.

  • Edit the path or file name by clicking the string and then making your change in the text box. Press ENTER to save or ESC to cancel your changes.

  • Edit the description by clicking above the path and file name and then making your change in the text box. Press ENTER to save or ESC to cancel your changes.

    Notes: 

    • You cannot edit other settings that are saved as part of the specification, such as the name of the worksheet or named range, data types of fields, and the source or destination table.

    • When you choose a different source file for an import specification, ensure that the new file meets all the requirements that are essential for successfully completing the operation.

Run

You can repeat an operation by clicking the specification and then clicking Run. When the operation is complete, you'll see a message that describes the status of the operation.

For more information, see the article Run a saved import or export operation.

Create Outlook Task

To repeat an operation at regular intervals, consider creating a task in Outlook that executes the corresponding specification. You must have Microsoft Outlook installed on your computer or device before you can create an Outlook task. To schedule a task, select the specification and then click Create Outlook Task. Specify the settings you want in the Task window in Outlook and then click Save & Close.

For more information, see the article Schedule an import or export operation.

Delete

If you no longer need to perform a specific operation, you can delete the specification. Select the specification and click Delete.

Note: Any changes you make — such as the name of the specification, file name or path settings, or any specifications that you delete — cannot be undone.

Page Setup dialog box (Page Properties tab)

Page Setup dialog box (Page Properties tab)

Note: Changes you make to settings on this tab apply to the currently displayed drawing page only, not to the entire file.

Type

Lists properties for either the drawing page (the foreground page) or the background page.

Name

To change the name of the drawing page, type a name containing up to 31 characters.

Background

Lists the names of the background pages in the drawing. The background you select in this list is assigned to the current page.

If you haven't created a background page, the only item that appears in the list is None.

Measurement units

Choose the measurement unit you want the Microsoft Office Visio rulers to display on the page. Unless you specify different units here, the ruler units are those specified in the drawing scale (on the Drawing Scale tab).

Quick Parts

Quick Parts

Use the Quick Parts Gallery to create, store, and find reusable pieces of content, including AutoText, document properties such as title and author, and fields.

In this article

Open the Quick Parts gallery to use these items. In Word, click Insert > Quick Parts.

AutoText

Document Property (Word only)

Field (Word only)

Building Blocks Organizer (Word only)

Save Selection to Quick Part Gallery

AutoText

AutoText is reusable content that you can store and access again and again. Click AutoText to access the AutoText gallery. You can save AutoText to the AutoText gallery by selecting the text you want to reuse, clicking AutoText, and then clicking Save Selection to AutoText Gallery. By filling in the new building block information you store the content you save to use again and again.

Document Property (Word only)

Click Document Property to choose from a list of properties that you can insert in your document. Fill in the document property box to create properties that travel with your document.

Field (Word only)

Use field codes to insert fields that can provide automatically updated information, such as the time, title, page numbers, and so on.

Building Blocks Organizer (Word only)

Click Building Blocks Organizer to preview all of the building blocks available to you in Word. You can also edit properties, delete, and insert buildings blocks.

Save Selection to Quick Part Gallery

Select a phrase, sentence, or other portion of your document. On the Insert tab, in the Text group, click Quick Parts, and then click Save Selection to Quick Part Gallery.

After you save a selection to the Quick Part Gallery, you can reuse the selection by clicking Quick Parts and choosing the selection from the gallery.

Create a form with Microsoft Forms

Create a form with Microsoft Forms

With Microsoft Forms, you can create surveys, quizzes, and polls, and easily see results as they come in.

Tip: Are you creating a quiz? Start here.

To get started with building a form, follow these steps:

  1. In your web browser, navigate to the Microsoft Forms site at http://forms.microsoft.com.

  2. Sign in to Office 365 with your school or work credentials.

  3. Under My Forms, click New Form to begin creating your form.

    Create new survey form

  4. Enter a name for your form. You can also enter an optional subtitle for it.

    Note: Form names can contain up to 90 characters and a subtitle can contain up to 1,000 characters.

    Name and subtitle entered for a new form

  5. Click Add Question to add a new question to the form. You can choose to add Choice, Text, Rating, or Date questions.

    Note: Your form is saved automatically while you create it.

    Choice, text, and rating question types displayed for a form.

  6. For choice questions, enter the text you want to display for the question and each of the choices.

    A form choice question displayed with options

    Want to add more choices? Click Add Option to add more choices than the default two choices. Click Add "Other" Option to add a choice option that displays the text Other. To remove a choice, click the trash can button next to it. You can also choose to make a question required or allow multiple choices for a question by changing the settings at the bottom of the question. To have Microsoft Forms randomly shuffle the order of the options displayed to users of the form, click the ellipses button (...) and then click Shuffle options.

    Tip: Click the ellipses button () and then click Subtitle to add a subtitle for a question.

    Some choice questions will trigger auto suggestions.

    Suggested answer options for a question

    Click on the suggested options to add as choices. In the following example, Monday, Wednesday, and Friday are selected.

    Selection of suggested answer options for a question

  7. Click Add Question to add more questions to your form. To change the order of the questions, click the Up or Down arrows on the right side of each question. For text questions, select the Long Answer option if you want a larger text box displayed on the form.

    A text question displayed on a form

    Tip: To copy a question, select it and then click the Copy Question button Copy question button in the upper right corner.

  8. Text questions also allow you to set restrictions when you need to have numbers as the answer. Click the ellipses button () and then click Restrictions. You can choose to restrict the numbers by selecting from the various options such as Greater than, Less than, Between, and many others.

    Text question displayed with number restriction between 1 and 6

  9. Click Preview at the top of the design window to see how your form will look on a computer. If you want to test your form, enter answers for the questions in preview mode and then click Submit.

    Preview computer mode for a class survey form

  10. Click Mobile to see how your form will look on a mobile device.

    Preview mobile mode for a class survey form

    Click Back when you are finished previewing your form.

To get started with building a form, follow these steps:

  1. Sign in to Office 365 with your school or work credentials.

  2. Click New, and then select Forms for Excel to begin creating your form.

    Insert Form for Excel option in Excel Online

    Note: Forms for Excel is available for OneDrive for Business and new team sites connected with Office 365 groups. Learn more about Office 365 groups.

    Note: We are currently updating this feature and rolling out changes, so you may not yet see Forms for Excel. If you see the Excel surveys feature, learn more about Excel surveys in OneDrive and Forms for Excel in OneDrive for Business.

  3. Enter a name for your form, and then click Create.

  4. Click Add Question to add a new question to the form. You can choose to add Choice, Text, Rating, or Date questions.

    Note: Your form is saved automatically while you create it.

    Choice, text, and rating question types displayed for a form.

  5. For choice questions, enter the text you want to display for the question and each of the choices.

    A form choice question displayed with options

    Want to add more choices? Click Add Option to add more choices than the default two choices. Click Add "Other" Option to add a choice option that displays the text Other. To remove a choice, click the trash can button next to it. You can also choose to make a question required or allow multiple choices for a question by changing the settings at the bottom of the question. To have Microsoft Forms randomly shuffle the order of the options displayed to users of the form, click the ellipses button (...) and then click Shuffle options.

    Tip: Click the ellipses button () and then click Subtitle to add a subtitle for a question.

    Some choice questions will trigger auto suggestions.

    Suggested answer options for a question

    Click on the suggested options to add as choices. In the following example, Monday, Wednesday, and Friday are selected.

    Selection of suggested answer options for a question

  6. Click Add Question to add more questions to your form. To change the order of the questions, click the Up or Down arrows on the right side of each question. For text questions, select the Long Answer option if you want a larger text box displayed on the form.

    A text question displayed on a form

    Tip: To copy a question, select it and then click the Copy Question button Copy question button in the upper right corner.

  7. Text questions also allow you to set restrictions when you need to have numbers as the answer. Click the ellipses button () and then click Restrictions. You can choose to restrict the numbers by selecting from the various options such as Greater than, Less than, Between, and many others.

    Text question displayed with number restriction between 1 and 6

  8. Click Preview at the top of the design window to see how your form will look on a computer. If you want to test your form, enter answers for the questions in preview mode and then click Submit.

    Preview computer mode for a class survey form

  9. Click Mobile to see how your form will look on a mobile device.

    Preview mobile mode for a class survey form

    Click Back when you are finished previewing your form.

To get started with building a form, follow these steps:

  1. Sign in to Office 365 with your school or work credentials.

  2. Open the Excel workbook in which you want to insert a form.

  3. In the Tables section, click Form > New Form to begin creating your form.

    Insert New Form option in Excel Online

    Note: To enable the Form button, make sure your Excel workbook is stored in OneDrive for Business.

    Note: We are currently updating this feature and rolling out changes, so you may not yet see the Forms button. If you see the Survey button, learn more about surveys in Excel Online.

  4. A new tab, Microsoft Forms, will open.

  5. A default title for your form will be provided. To change it, click on the title and type a new name.

  6. Click Add Question to add a new question to the form. You can choose to add Choice, Text, Rating, or Date questions.

    Note: Your form is saved automatically while you create it.

    Choice, text, and rating question types displayed for a form.

  7. For choice questions, enter the text you want to display for the question and each of the choices.

    A form choice question displayed with options

    Want to add more choices? Click Add Option to add more choices than the default two choices. Click Add "Other" Option to add a choice option that displays the text Other. To remove a choice, click the trash can button next to it. You can also choose to make a question required or allow multiple choices for a question by changing the settings at the bottom of the question. To have Microsoft Forms randomly shuffle the order of the options displayed to users of the form, click the ellipses button (...) and then click Shuffle options.

    Tip: Click the ellipses button () and then click Subtitle to add a subtitle for a question.

    Some choice questions will trigger auto suggestions.

    Suggested answer options for a question

    Click on the suggested options to add as choices. In the following example, Monday, Wednesday, and Friday are selected.

    Selection of suggested answer options for a question

  8. Click Add Question to add more questions to your form. To change the order of the questions, click the Up or Down arrows on the right side of each question. For text questions, select the Long Answer option if you want a larger text box displayed on the form.

    A text question displayed on a form

    Tip: To copy a question, select it and then click the Copy Question button Copy question button in the upper right corner.

  9. Text questions also allow you to set restrictions when you need to have numbers as the answer. Click the ellipses button () and then click Restrictions. You can choose to restrict the numbers by selecting from the various options such as Greater than, Less than, Between, and many others.

    Text question displayed with number restriction between 1 and 6

  10. Click Preview at the top of the design window to see how your form will look on a computer. If you want to test your form, enter answers for the questions in preview mode and then click Submit.

    Preview computer mode for a class survey form

  11. Click Mobile to see how your form will look on a mobile device.

    Preview mobile mode for a class survey form

    Click Back when you are finished previewing your form.

To get started with building a form, follow these steps:

  1. Sign in to Office 365 with your school or work credentials.

  2. Open the OneNote notebook in which you want to insert a form.

  3. On the Insert tab, select Forms.

    Insert Forms option in OneNote Online
  4. A Forms for OneNote panel will open and dock on the right side of your OneNote notebook.

    Forms for OneNote panel in OneNote Online
  5. Click Sign in.

  6. When you see the message, "Forms for OneNote wants to display a new window," click Allow.

  7. In the Forms for OneNote panel, you'll now see a list of any forms and quizzes you've created.

    MS_Forms_OneNote_FormsPanel-generic
  8. Under My Forms, click New Form to begin creating a form. A new window will open with a blank form and default title ("Untitled form").

  9. Click on the default title to add your own. You can also add a description for your form.

  10. Click Add Question to add a new question to the form. You can choose to add Choice, Text, Rating, or Date questions.

    Note: Your form is saved automatically while you create it. In the Forms for OneNote panel, you'll see your new form listed under My Forms.

    Choice, text, and rating question types displayed for a form.

  11. For choice questions, enter the text you want to display for the question and each of the choices.

    A form choice question displayed with options

    Want to add more choices? Click Add Option to add more choices than the default two choices. Click Add "Other" Option to add a choice option that displays the text Other. To remove a choice, click the trash can button next to it. You can also choose to make a question required or allow multiple choices for a question by changing the settings at the bottom of the question. To have Microsoft Forms randomly shuffle the order of the options displayed to users of the form, click the ellipses button (...) and then click Shuffle options.

    Tip: Click the ellipses button () and then click Subtitle to add a subtitle for a question.

    Some choice questions will trigger auto suggestions.

    Suggested answer options for a question

    Click on the suggested options to add as choices. In the following example, Monday, Wednesday, and Friday are selected.

    Selection of suggested answer options for a question

  12. Click Add Question to add more questions to your form. To change the order of the questions, click the Up or Down arrows on the right side of each question. For text questions, select the Long Answer option if you want a larger text box displayed on the form.

    A text question displayed on a form

    Tip: To copy a question, select it and then click the Copy Question button Copy question button in the upper right corner.

  13. Text questions also allow you to set restrictions when you need to have numbers as the answer. Click the ellipses button () and then click Restrictions. You can choose to restrict the numbers by selecting from the various options such as Greater than, Less than, Between, and many others.

    Text question displayed with number restriction between 1 and 6

  14. Click Preview at the top of the design window to see how your form will look on a computer. If you want to test your form, enter answers for the questions in preview mode and then click Submit.

    Preview computer mode for a class survey form

  15. Click Mobile to see how your form will look on a mobile device.

    Preview mobile mode for a class survey form

    Click Back when you are finished previewing your form.

  16. Your newly created form will appear at the top of your My forms list under the New Form and New Quiz buttons.

    MS_Forms_OneNote_FormsPanel-generic
  17. When you're ready, you can embed your form into your OneNote notebook.

Got feedback on Microsoft Forms?

We'd love to hear from you! In the upper right corner of the Microsoft Forms window, click More Options (...) > Feedback. You can also visit the Microsoft Forms User Voice site to provide suggestions and vote on ideas others have already submitted.

See Also

Adjust your form settings

Change a form theme

Check your form results

Budget Work fields

Budget Work fields

The Budget Work fields are used to enter or review budget work for budget work and material resources. Budget resources are assigned only to the project summary task. You can use the Budget Work fields to compare the current budgeted work with the planned work for the project.

There are several categories of Budget Work fields.

Budget Work (task field)

Data Type     Duration

Entry Type    Calculated

How Calculated    When you assign a work or material resource that is a budget resource to a project summary task, and then enter a work amount for the resource in either the Task Usage or Resource Usage view, Microsoft Office Project 2007 rolls up the total amount to the project summary task.

This information can then be used to review the overall budget work information for the project. If the project is part of a master project or portfolio of projects, the project summary budget work information can be compared and analyzed against other projects. The project summary task of the master project includes the rolled-up work value of its own budget resources plus the sum of the budget resources of its subprojects.

Best Uses    Add the Budget Work field to a task view and show the project summary task when you want to review the total work budget for work and material resources. After you start tracking progress in your project plan, you can use the Budget Work field to compare your budgeted work against actual work.

Example    Having built your project based on an estimate of 5,000 hours for three full-time equivalent work resources, you create "Staffing" as a work resource and identify it as a budget resource. You assign the "Staffing" resource to the project summary task, and then enter the work amount of 5,000 hours in the Task Usage view. As work continues, you enter actual progress information in the project plan. You can compare any variances between your planned work and actual work to analyze whether you're on track or need to make any adjustments.

Remarks    The Budget Work field shows information for work resources and material resources, but not for cost resources. To see budget cost information for cost resources that have been assigned to the project summary task, add the Budget Cost field to the task sheet.

To show the project summary task, on the Tools menu, click Options. On the View tab, select the Show project summary task check box.

Budget Work (resource field)

Data Type     Duration

Entry Type    Calculated

How Calculated    When you assign a work or material resource that is a budget resource to a project summary task, and then enter a work amount for the resource in either the Task Usage or Resource Usage view, Microsoft Office Project 2007 copies this amount into the Budget Work resource field.

Best Uses    Add the Budget Work field to a resource view when you want to review the work budget for your work and material resources, or to compare the work budgets of your resources to each other.

Example    Having built your project based on an estimate of 5,000 hours for three full-time equivalent work resources, you create "Staffing" as a work resource and identify it as a budget resource. You assign the "Staffing" resource to the project summary task, and then enter the work amount of 5,000 hours in the Task Usage view. When you add the Budget Work field to the Resource Sheet, you see that the "Staffing" work resource reflects this budget of 5,000 hours.

Remarks    The Budget Work field shows information for work resources and material resources, but not for cost resources. To see budget cost information for cost resources that have been assigned to the project summary task, add the Budget Cost field to a resource sheet.

Budget Work (assignment field)

Data Type     Duration

Entry Type    Entered

Best Uses    Add the Budget Work field to the Task Usage or Resource Usage view when you want to enter the budgeted work amount for work or material resources on assignments, or when you want to compare the budgeted work of resources to one another.

Example    Having built your project based on an estimate of 5,000 hours for three full-time equivalent work resources, you create "Staffing" as a work resource and identify it as a budget resource. You assign the "Staffing" resource to the project summary task. You can now enter the lump-sum budget work amount of 5,000 hours in the sheet portion of the Task Usage view.

Remarks    You can use the Budget Work field to enter information for work resources and material resources, but not for cost resources. To enter a lump-sum budget cost for cost resources that have been assigned to the project summary task, add the Budget Cost field to the sheet portion of the Task Usage or Resource Usage view and enter the cost there.

Budget Work (task-timephased field)

Data Type     Duration

Entry Type    Calculated

How Calculated    When you assign a work or material resource that is a budget resource to a project summary task, and then enter a work amount for the resource in either the Task Usage or Resource Usage view, Microsoft Office Project 2007 rolls down the total amount to the task-timephased level.

Best Uses    In the Task Usage view, click Detail Styles on the Format menu. To show the Budget Work field on the timephased portion of the view, move the Budget Work field to the Show these fields box. This shows the breakdown of budgeted work for the project summary task spread out over time.

Example    Having built your project based on an estimate of 5,000 hours for three full-time equivalent work resources, you create "Staffing" as a work resource and identify it as a budget resource. You assign the "Staffing" resource to the project summary task, and then enter the work amount of 5,000 hours in the Task Usage view. As work continues, you enter actual progress information in the project plan. You can compare any variances between your planned work and actual work to analyze whether you're on track or need to make any adjustments.

Remarks    The Budget Work field shows information for work resources and material resources, but not for cost resources. To see timephased budget cost information for cost resources that have been assigned to the project summary task, add the Budget Cost field to the timephased portion of the Task Usage view.

Budget Work (resource-timephased field)

Data Type     Duration

Entry Type    Calculated

How Calculated    When you assign a work or material resource that is a budget resource to a project summary task, and then enter a budgeted work amount for the resource in either the Task Usage or Resource Usage view, Microsoft Office Project 2007 rolls down the total amount to the resource-timephased level.

Best Uses    In the Resource Usage view, click Detail Styles on the Format menu. To show the Budget Work field on the timephased portion of the view, move Budget Work to the Show these fields box. This shows the breakdown of budgeted work for the budget resources assigned to the project summary task spread out over time.

Example    Having built your project based on an estimate of 5,000 hours for three full-time equivalent work resources, you create "Staffing" as a work resource and identify it as a budget resource. You assign the "Staffing" resource to the project summary task, and then enter the work amount of 5,000 hours in the Task Usage view. As work continues, you enter actual progress information in the project plan. You can compare any variances between your planned timephased work and actual timephased work to analyze whether you're on track or need to make any adjustments.

Remarks    The Budget Work field shows information for work resources and material resources, but not for cost resources. To see timephased budget cost information for cost resources that have been assigned to the project summary task, add the Budget Cost field to the timephased portion of the Resource Usage view.

Budget Work (assignment-timephased field)

Data Type     Duration

Entry Type    Entered

Best Uses    In the Task Usage or Resource Usage view, click Detail Styles on the Format menu. To show the Budget Work field on the timephased portion of the view, move Budget Work to the Show these fields box. You can now enter or review the budget work for the assignment spread out over time.

Example    Having built your project based on an estimate of 5,000 hours for three full-time equivalent work resources, you create "Staffing" as a work resource and identify it as a budget resource. You assign the "Staffing" resource to the project summary task. You can now enter timephased or contoured work amounts in the timesheet portion of the Task Usage or Resource Usage view for the assignment of "Staffing" on the project summary task.

Remarks    You can use the Budget Work field to enter timephased information for work resources and material resources, but not for cost resources. To enter timephased budget cost information for cost resources that have been assigned to the project summary task, add the Budget Cost field to the timephased portion of the Task Usage or Resource Usage view and enter the cost information there.

Which file format should I use in Access 2010?

Which file format should I use in Access 2010?

Microsoft Access 2010 by default uses the .accdb file format extension introduced in Access 2007. Access continues to provide some support for the file format used in earlier versions of Access. This article explains why you should use the new file format whenever possible, and why you might need to use the earlier version file format in some instances. You will also learn explicitly how to convert a database to the new file format.

In this article

The new file format (.accdb)

The earlier version file format (.mdb)

Converting to the new file format

The new file format (.accdb)

Access 2010 employs a file format that supports a number of product enhancements. When you create a new database, the database uses the new file format by default and is given the .accdb file extension.

You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. Moreover, if you want to convert your desktop database to a Web database by using Access Services, the desktop database file must be in .accdb format.

However, the new file format cannot be opened or linked to with earlier versions of Access, it does not support replication, and it does not support user-level security. If you need to use the database with earlier versions of Access, or if you need to use replication or user-level security, you must use an earlier version file format.

Features provided by the .accdb file format

  • Web publishing with Access Services    

    If you have a server running Access Services, a component of SharePoint Server, you can publish an .accdb file format to the Web, suibject to certain compatibility restrictions. Some design features and paradigms are different for Web databases than for desktop databases — some desktop databases cannot be published to the Web without first making design changes.

    After you publish a database to the Web, you can still open the .accdb file to make design changes, and can also then synchronize those changes with the published version. People can use the published Web database in a browser, without having Access installed.

  • Multivalued fields    

    Suppose you need to assign a task to one of your employees but decide that you need to assign it to more than one person. In Access 2010 you can create a multivalued field where the employees' names can be selected from or entered in a box.

    When you click the box, check boxes that are selected indicate your choices. The selected employees are stored in the multivalued field and are separated by commas (by default) when displayed.

    The idea behind multivalued fields is to make it easy to select and store more than one choice, without having to create a more advanced database design. Multivalued fields are also important for integration with Microsoft SharePoint Foundation, because SharePoint lists also support multivalued fields.

  • Attachment data type    

    The new Attachment data type lets you easily store all types of documents and binary files in your database without excessive growth in the physical size of the database. Attachments are automatically compressed, when appropriate, to maximize space usage. You can attach a Word document to a record, or save a series of digital pictures. You can even keep multiple attachments attached to a single record.

  • Improved integration with SharePoint and Outlook    

    In the past, Access files in the .mdb format were blocked by SharePoint or Outlook due to the fact that unsafe code can be included within an Access database. Access 2010 allows code to be either verified as safe or disabled. This makes it possible to integrate Access databases more fully with SharePoint or Outlook.

  • Memo field history tracking    

    Memo fields are useful for storing large amounts of information. Starting with Access 2007, you can set a property (AppendOnly) that forces Access to retain a history of all changes to a Memo field. You can then view a history of those changes. This feature also supports the versioning feature in Windows SharePoint Services 3.0 so that you can use Access to track changes in multiple lines of a text field that is stored in a SharePoint list (provided that the field has the Append Changes to Existing Text option set to Yes).

  • Improved encryption    

    You can choose to set a database password and encrypt the contents of your database. When you do so using Access 2007 and a file that uses the new file format, Access uses the Windows Crypto API to encrypt the data. Third-party encryption tools can also be used.

Top of Page

The earlier version file format (.mdb)

Versions of Access earlier than Office Access 2007 support file formats that use the .mdb file extension. In Access 2010 you can still open .mdb files. If the file is stored in the Access 2002-2003 or Access 2000 file format, you can open it and use it in Access 2010 as you normally would. However, you cannot take advantage of the new features that require the .accdb file format.

If the file is stored in the Access 95 or Access 97 file format, when you first open it in Access 2010, Access offers to upgrade the database to the file format currently set as the default file format (usually the .accdb file format, unless you or an administrator has changed the setting). If you do not plan to use the database with versions of Access earlier than Access 2007, and you will not be sharing the database with other users who use versions of Access earlier than Access 2007, and you do not use replication or user-level security, you should upgrade the database file to the new .accdb format. After you upgrade the database to the .accdb file format, you can no longer open the database by using a version of Access earlier than Access 2007.

If the file is stored in Access 95 or Access 97 format and you choose not to upgrade to the .accdb format, you cannot make design changes. You can view objects and make changes to your data through Access 2010, but you cannot make design changes.

Top of Page

Converting to the new file format

To explicitly convert an Access database to the new .accdb file format, you must first open the database and then save it in the .accdb file format.

Important: The following procedure is for files created in Access 97, Access 2000, Access 2002 or Access 2003.

First, open your database:

  1. Click the File tab.

  2. On the left, click Open.

  3. In the Open dialog box, select and open the database that you want to convert.

Now, convert your database:

  1. Click the File tab.

  2. On the left, click Share.

  3. Under Save Entire Database, click Save Database As.

  4. On the right, under Database File Types, click Access Database.

  5. In the Save As dialog box, in the File name box, enter a file name or use the file name supplied.

  6. Click Save.

    A copy of the database is created in the .accdb file format.

Top of Page

Graphics, object, or ActiveX control compatibility issues in Excel 2016 for Windows

Graphics, object, or ActiveX control compatibility issues in Excel 2016 for Windows

The Compatibility Checker found one or more compatibility issues related to graphics, objects, or ActiveX controls.

Important: Before you continue saving the workbook to an earlier file format, you should address issues that cause a significant loss of functionality so that you can prevent permanent loss of data or incorrect functionality.

Issues that cause a minor loss of fidelity might or might not have to be resolved before you continue saving the workbook—data or functionality is not lost, but the workbook might not look or work exactly the same way when you open it in an earlier version of Microsoft Excel.

In this article

Issues that cause a significant loss of functionality

Issues that cause a minor loss of fidelity

Issues that cause a significant loss of functionality

Issue

Solution

Any effects on this object will be removed. Any text that overflows the boundaries of this graphic will appear clipped.

What it means    In Excel 2007 and later, you can use special effects, such as transparent shadows that are not supported in Excel 97-2003. The special effects will be removed.

Also, in Excel 2007 and later, when you insert text in a shape that is wider than the shape, the text displays across the boundaries of the shape. In Excel 97-2003, this text is truncated. To avoid truncated text, you can adjust the size of the shape for a better fit.

What to do    In the Compatibility Checker, click Find to locate the objects that have special effects applied so that you can remove those effects as needed.

This object will no longer be editable.

What it means    Embedded objects that are created in Excel 2007 and later cannot be edited in Excel 97-2003.

What to do    In the Compatibility Checker, click Find to locate the objects that contain text that will not be editable, and then make the necessary changes.

Uninitialized ActiveX controls cannot be transferred to the selected file format.  The controls will be lost if you continue.

What it means    If a workbook contains ActiveX controls that are considered to be Unsafe for Initialization (UFI), they are lost when you save the workbook to an earlier Excel file format. You may want to mark those controls as Safe for Initialization (SFI).

What to do    If you open a workbook that contains uninitialized ActiveX controls, and the workbook is set to high security, you must first use the Message Bar to enable them before they can be initialized.

One or more objects in this workbook (such as shapes, WordArt, or text boxes) may allow text to overflow the object boundaries. Earlier versions of Excel do not recognize this option and will hide overflowing text.

What it means    In Excel 2010 and later, you can display text boxes on objects (such as shapes) and display the text beyond the boundaries of those objects. In Excel 97-2007, text that overflows the boundaries of an object will not be visible.

What to do    In the Compatibility Checker, click Find to locate the text box that contains text that overflows the boundaries of the shape, make the necessary changes to keep the text within the boundaries, and then turn the option to overflow text off (right-click the shape or text box, click Format Shape, click the Text Options category, click the Textbox button, and then select the Allow text to overflow shape check box).

Top of Page

Issues that cause a minor loss of fidelity

Issue

Solution

This workbook contains text boxes with text formatting not available in earlier versions of Excel. The text in the text boxes will appear differently in the earlier versions of Excel.

What it means    In Excel 2007 and later, you can use a text box on objects (such as shapes) that displays more than one column of text. In Excel 97-2003, the text will be displayed but in a different format.

What to do    In the Compatibility Checker, click Find to locate the text box that displays more than one columns of text, and then make the necessary changes to display the text in one column only (right-click the shape, click Format Shape, click the Text Options category, click the Textbox button, and then click the Columns button).

Top of Page

Decide whether to trust a database

Decide whether to trust a database

Microsoft Office Access 2007 uses a new security model that is simpler than earlier versions. In Access 2007, you indicate whether you trust a database, and all other security decisions are made for you automatically, based on your trust decision. This article contains an overview of how trust works in Access 2007, how it differs from security in earlier versions, and what factors you should consider when you decide whether to trust a database.

This article does not explain the use of digital signatures in trust decisions. For more information, see Show trust by adding a digital signature.

In this article

Overview

Factors to consider when deciding whether to trust a database

Ways to trust a database

Overview

If you used the security features in earlier versions of Access, you had to make a series of choices when you opened a database. For example, you had to choose between security levels (Low, Medium, or High), and whether you wanted to run potentially unsafe code or not. You no longer have to make those kinds of decisions when you open a database in Access 2007. By default, Access 2007 disables all the potentially unsafe code or other components in a database, regardless of the version of Access that you used to create the database.

When Access disables content, it informs you of the action by displaying the Message Bar.

The Message Bar

If you see the Message Bar, you can choose whether to trust the disabled content in the database. If you choose to trust the disabled content, you can do so in two ways:

  • Trust the database only for the current session (while the database is open)    Click Options on the Message Bar. A dialog box appears in which you can choose to trust the database. When you choose this option, you must repeat the procedure every time that you open the database.

  • Trust the database permanently    Place the database in a trusted location — a folder on a drive or network that you mark as trusted. When you choose this option, you no longer see the Message Bar, and you never have to enable the database content as long as the database remains in the trusted location.

If you do not want to trust the database, ignore or close the Message Bar. When you ignore or close the Message Bar, you can still view the data in the database and use any components in the database that Access has not disabled.

Top of Page

Factors to consider when deciding whether to trust a database

Before you decide whether to trust a database, you should consider the following factors.

  • Your own security policy    You or your company may have a security policy in place that specifies how to handle Access database files. For example, you might have a very robust backup system in place, and decide that you are willing to trust most database files, unless you have a specific reason not to. Conversely, you may not have a good backup system, and therefore might want to be very cautious when you decide whether to trust a database.

  • Your goal    When Access disables content in a database that you have not trusted, it does not block your access to the data in that database. If you want to review the data in a database and do not want to perform any actions that may be unsafe, such as running an action query or using certain macro actions, you do not need to trust the database. If you are not sure whether an action is considered unsafe, you can try to perform the action while the database content has been blocked by disabled mode. If the action is potentially unsafe, it will be blocked in this circumstance.

  • The database source    If you created the database, or if you know that it came from a source that you trust, you can decide to trust the database. If the database came from a possibly unreliable source, you might want to leave the database untrusted until you can be sure that its content is safe.

  • The contents of the database file    If you cannot make a trust decision based on other information, you might consider thoroughly examining the database contents to see what potentially unsafe content the database might contain. After you conduct a complete check and are sure that the content is safe, you can decide to trust the database.

  • The security of the location where the database is stored    Even if you know that the contents of a database file are safe, if the file is stored in a location that is not fully secure, it is possible that someone might introduce unsafe content into the database. You should be careful when deciding to trust database files that are stored in locations that might not be secure.

Top of Page

Ways to trust a database

After you decide to trust a database, you can either trust it once — and enable database content for a session — or you can trust it indefinitely by putting the database file in a trusted location.

Enable database content for a session

To enable database content for a session, you use the Message Bar.

The Message Bar

The Message Bar appears just under the Ribbon, and is part of the Microsoft Office Fluent User Interface.

Use the Message Bar to enable content

If you do not see the Message Bar, it may be hidden or disabled. To use it, you must first show or enable it.

Show the Message Bar

If you see the Message Bar, you can skip this step.

  • On the Database Tools tab, in the Show/Hide group, select the Message Bar check box.

    If the Message Bar check box is disabled, you can enable it.

Enable the Message Bar

If the Message Bar check box is enabled, you can skip this step.

  1. Click the Microsoft Office Button Office button image , and then click Access Options.

  2. In the left pane of the Access Options dialog box, click Trust Center.

  3. In the right pane, under Microsoft Office Access Trust Center, click Trust Center Settings.

  4. In the left pane of the Trust Center dialog box, click Message Bar.

  5. In the right pane, click Show the Message Bar in all applications when content has been blocked, and then click OK.

  6. Close and reopen the database to apply the changed setting.

Once the Message Bar is visible and enabled, you can use it to enable content.

Enable content using the Message Bar
  1. In the Message Bar, click Options.

  2. In the Microsoft Office Security Options dialog box, click Enable this content, and then click OK.

Top of Page

Enable a database by default

To specify that a given database is trustworthy and should be enabled by default, make sure that the database file is located in a trusted location. A trusted location is a folder or file path on your computer or a location on your intranet from which it is considered safe to run code. Default trusted locations include the Templates, AddIns, and Startup folders. You can also specify your own trusted locations.

Tip: If you want to know the path of the current database, click the Microsoft Office Button, click Manage, and then click Database Properties. The full path of the current database's location is listed on the General tab of the Database Properties dialog box.

Move a database file to a trusted location

  • Open the folder where the database file is currently located, and then copy the database file into the trusted location that you want.

Specify a trusted location

  1. In the Message Bar, click Options.

  2. At the bottom of the Microsoft Office Security Options dialog box, click Open the Trust Center.

  3. In the left pane of the Trust Center dialog box, click Trusted Locations.

  4. To add a network location, in the right pane, select the Allow Trusted Locations on my network check box.

  5. Click Add new location.

  6. In the Microsoft Office Trusted Location dialog box, do one of the following:

    • In the Path box, type the full path of the location that you want to add.

    • Click Browse to browse to the location.

  7. To specify that subfolders of the new trusted locations should also be trusted, select the Subfolders of this location are also trusted check box.

  8. Optionally, in the Description box, type a description for the trusted location.

Top of Page

View your speaker notes as you deliver your slide show in PowerPoint 2016 for Mac

View your speaker notes as you deliver your slide show in PowerPoint 2016 for Mac

Using Presenter View is a great way to view your presentation with speaker notes on one computer (your laptop, for example), while your audience views the notes-free presentation on a different monitor (projected on a larger screen, for example).

At the bottom of the PowerPoint slide window, click Slide Show.

PowerPoint for Mac Slide Show icon in the status bar

Tips: 

  • Now, if you are working with PowerPoint on a single monitor and you want to display Presenter View, in Slide Show View, on the control bar at the bottom left, click the presenter view command and then click Use Presenter View.

  • PPT for Mac Presenter View Command

To exit Presenter View, press ESC.

Related information

View, print, or add speaker notes to a slide in PowerPoint 2016 for Mac

Record your slide show in PowerPoint 2016 for Mac