I'm currently helping a non-profit organization by creating an Access database to bring together several years of data captured on Excel worksheets. They do not currently have Access on their computers. While I've used Access for 20 years or so, it has always been (I think?) part of M$ Office. So I have some questions about what version of Access they should buy.
· Is there a difference in the ability to export to and/or import from Excel worksheets between a standalone Access and Access that's an integral part of M$ Office Pro? I suspect not, but need to make sure.
· The computer upon which we intend to install Access currently has M$ Office Home & Student 2007 (has Word, Excel, PowerPoint). We were considering buying the latest version of Access (2010, 32-bit), but in the specs, M$ says, "Importing data requires Excel 2010 or Outlook 2010". Knowing that M$ has a penchant for pushing upgrades, is that actually true, or will Access 2010 import Excel 2007 worksheets? Will it import Excel 2000/2003 worksheets?
· I am still using Office 2000, partly because I run a business with it and most of my clients have Office 2000, or 2003, which are upward and downward compatible. The database I've designed for this organization is, therefore, in Access 2000 format. Can Access 2010 open and use databases designed in 2000 format (assume so)? Does it have to convert them to do so, and is the converted database then incompatible with my Access 2000 (I assume it is)? The Microsoft Compatibility Pack is installed on my computer and allows me to read Office 2007 and I assume 2010 files. Does that pack convert Access 2010 databases so I can read and modify them using Access 2000?
· Does Access 2010 save files in the 'x' format like Office 2010 does with Excel and Word files (i.e., with the '.mdbx' extension)?
Appreciate the help.
· Is there a difference in the ability to export to and/or import from Excel worksheets between a standalone Access and Access that's an integral part of M$ Office Pro? I suspect not, but need to make sure.
· The computer upon which we intend to install Access currently has M$ Office Home & Student 2007 (has Word, Excel, PowerPoint). We were considering buying the latest version of Access (2010, 32-bit), but in the specs, M$ says, "Importing data requires Excel 2010 or Outlook 2010". Knowing that M$ has a penchant for pushing upgrades, is that actually true, or will Access 2010 import Excel 2007 worksheets? Will it import Excel 2000/2003 worksheets?
· I am still using Office 2000, partly because I run a business with it and most of my clients have Office 2000, or 2003, which are upward and downward compatible. The database I've designed for this organization is, therefore, in Access 2000 format. Can Access 2010 open and use databases designed in 2000 format (assume so)? Does it have to convert them to do so, and is the converted database then incompatible with my Access 2000 (I assume it is)? The Microsoft Compatibility Pack is installed on my computer and allows me to read Office 2007 and I assume 2010 files. Does that pack convert Access 2010 databases so I can read and modify them using Access 2000?
· Does Access 2010 save files in the 'x' format like Office 2010 does with Excel and Word files (i.e., with the '.mdbx' extension)?
Appreciate the help.