Thank you so much for coming to the launch event in Detroit, I hope everyone had fun and learned something new in Office 2010 or SharePoint 2010.  I had several questions from the event and here they are:

Q: What type of database did I use for the PowerPivot Demo (relational or a cube)?
A:
The database that I used to show the PowerPivot demos was just a sample relation database with about 4 million rows in it.

Q:Where can we learn more about the bibliography feature in Word 2010?
A:
. In Microsoft Word 2010, you can automatically generate a bibliography based on the source information that you provide for the document. Each time that you create a new source, the source information is saved on your computer, so that you can find and use any source you have created. You can choose the bibliography style that you want, and you can add new bibliography styles. To start working with the bibliography, you want to go to the references ribbon, in there you can then use the citations and bibliography to help create your sources.

Q: Is Business Contact Manager still in Outlook 2010?
A:
Yes, the BCM is alive and well in Outlook 2010, you can learn more about it here: Outlook 2010 with Business Contact Manager. It is available in Microsoft Office Professional Plus 2010.

Q: What video formats can you insert in PowerPoint 2010?
A:
You can insert Windows media (.asf), Windows video (.avi), QuickTime, MP4 video, movie file (MPEG), MPEG-2 TS video, Windows Media Video File (.wmv) and Adobe flash files.

Q: What features are enabled with SQL Server 2008 R2 and SharePoint that I will miss with another version of SQL?
A:
There are a few benefits to running SQL R2 with SharePoint 2010, you can read about all of them here: SQL Server 2008 R2 and SharePoint 2010 Products: Better Together Some of the key components are: Microsoft PowerPivot for SharePoint, Database Mirroring, and Remote Blob Storage, just to name a few enhancements.

Q: Will there be an upgrade checker for SharePoint 2010?
A:
While there is not an upgrade checker for SharePoint 2010 to move to the next version of SharePoint after 2010, I am sure there will be, it might be added in a service pack. For example we added the –preupgradechecker to SharePoint 2007 with SP2. So I would imagine as we get closer to next version of SharePoint, there will be a tool to help go to the next platform. To learn more about the current upgrade checker you can run on SharePoint 2007 take a look here: Run the pre-upgrade checker

Q: Is there a print to one note add-in?
A:
During one of the breaks I was asked about support for print to OneNote and seemed to go away with Windows 7. It looks like there needed to be a 64 bit update and I was able to find the information about the new add-in here: OneNote Print Driver – A 64 Bit Solution

Q: Is there any security guidance for Office 2010 and SharePoint 2010?
A:
There has been some great guidance published to help with Office and SharePoint, take a look at the links below to help you security guidance:

Q: Are there any known issues with BITS and disk fragmentation?
A:
I could not find any, known issues if anyone knows of any please comment and let me know.

Q: Is there a technology guarantee for Visio 2010, like there is for Office 2010?
A:
Yes, although not sure how much longer it will be for: Visio 2010 Release Dates.

Q: Can I mass convert files to Office 2010?
A:
Yes, you will want to use the Office Migration Planning Manager (OMPM) to help you with mass file migrations, you can get the OMPM here: Office Migration Planning Manager (OMPM) overview for Office 2010

Q: Is the Office Code Compatibility Inspector (OCCI) available for Project?
A:
Unfortunately it does not directly run in Project 2010. However, it does support, running in Microsoft Excel 2010, Microsoft PowerPoint 2010, Microsoft Word 2010, and Microsoft Visual Studio 2008 to troubleshoot and resolve issues with your Microsoft Visual Basic for Application (VBA) Macros and add-ins. Depending on how your Macros where created ,you may be able to look at the macro in Visual Studio to see if you can fix to learn more about the OCCI here: Microsoft Office Code Compatibility Inspector user's guide

Q: What is Folksononmy in SharePoint 2010?
A:
In brief, taxonomy is the hierarchical structure of terms/metadata that are part of the information architecture that is defined by the organization/corporation. Folksononmy is that defined by users. This will usually supplement taxonomy.Here is one of the links, very basic but will get you started : http://download.microsoft.com/download/E/B/0/EB0212B9-D40D-4A82-88C1-36A99891367C/FINALSharePoint2010ECMDatasheet.docx

Also look at the slides from Jamie Valez located here on SharePoint and social computing: http://www.sharepointsaturday.org/dc/Pages/speakerdecks.aspx

Here is another great free ebook that talks about it: http://www.aiim.org/forms/8-reasons.aspx

Q: What is the maximum size for an Access 2010 database?
A:
The size is still 2GB.

Q: Where can I learn more about PowerShell in SharePoint?
A:
You can learn more some here: Windows PowerShell in the SharePoint Management Shell

Q: What are the different versions of Office 2010?
A:
There are 5 different versions and they are listed below, and what each package includes:

Microsoft Office Professional Plus 2010 — only available via volume licensing Includes:

  • Microsoft® Excel® 2010
  • Microsoft® Outlook® 2010 with Business Contact Manager
  • Microsoft® PowerPoint® 2010
  • Microsoft® Word 2010
  • Microsoft® Access® 2010
  • Microsoft® InfoPath® 2010
  • Microsoft Office Communicator 2007 R2
  • Microsoft® Publisher 2010
  • Microsoft® OneNote® 2010
  • Microsoft® SharePoint® Workspace 2010
  • Microsoft Office Web Apps

Microsoft Office Professional 2010 Includes:

  • Microsoft Excel 2010
  • Microsoft Outlook 2010
  • Microsoft PowerPoint 2010
  • Microsoft Word 2010
  • Microsoft Access 2010
  • Microsoft Publisher 2010
  • Microsoft OneNote 2010

Microsoft Office Home and Business 2010 Includes:

  • Microsoft Excel 2010
  • Microsoft Outlook 2010
  • Microsoft PowerPoint 2010
  • Microsoft Word 2010
  • Microsoft OneNote 2010

Microsoft Office Standard 2010 — only available via volume licensing Includes:

  • Microsoft Excel 2010
  • Microsoft Outlook 2010
  • Microsoft PowerPoint 2010
  • Microsoft Word 2010
  • Microsoft OneNote 2010
  • Microsoft Publisher 2010
  • Microsoft Office Web Apps

Microsoft Office Home and Student 2010 — licensed for noncommercial use Includes:

  • Microsoft Excel 2010
  • Microsoft PowerPoint 2010
  • Microsoft Word 2010
  • Microsoft OneNote 2010

***Microsoft Visio 2010 and Microsoft Project 2010 are also available but are not part of the suites.

Q: Where can I learn more about Outlook 2010 offline folders?
A:
There is some great information here: Changes in Outlook 2010 . You will also notice, when you take a look at this site, there is also links for the other products in office 2010.