Which sqlexpress version is compatible with Windows 7 64Bits, with a quad intel processor?

Which SQLEXPRESS version is compatible with Windows 7 64Bits, with a quad Intel processor?
It will be used to practice MSSQL and keep up with the technology, which I learned way back when Windows NT and Oracle 7.x,  in a PC with 16MB of RAM and 120MB of hard disk was as good as it got. It used to take hours to get install ORACLE as a Local Server,  and get it to work and connect with Access v2.
It seems that installing a local SQL Server in a home PC has not gotten any easier. I tinkered with SQLEXPRESS 2008,32 bit version, and got it to connect to Access 2007 32bit in my Windows 7 64 bit environment.  But the SQL Management Studio installation kept displaying a compatibility issue. I am using Access 2007 only to test connectivity, since Access 2007 can not modify the table designs in the SQLEXPRESS Local Server. SQL Management Studio, however does not install. Please help!
Relevant information follows:
System information
CPU      Quad Core Intel Core i7-2600K, 3500 MHz (35 x 100)
Operating System        Microsoft Windows 7 Professional, SP 1, x64  
OS Version      6.1.7601.18247 (Win7 RTM)
Motherboard       Gigabyte GA-Z68AP-D3
System Memory      8176 MB  (DDR3-1333 DDR3 SDRAM)
Video Adapter      AMD Radeon HD 6900 Series  (2048 MB)]
HDD Space Disk C       88 GBs free,   223 GBs Total
HDD Space Disk D      748 GBs free , 975 GBs Total

SQL related software installed
Microsoft Visual C++ 2005 Redistributable
Microsoft Visual C++ 2008 Redistributable - x64 9.0.30729
Microsoft Visual C++ 2008 Redistributable - x64 9.0.30729.6161
Microsoft Visual C++ 2008 Redistributable - x86 9.0.21022
Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.17
Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.6161
Microsoft Visual C++ 2010  x64 Redistributable - 10.0.40219
Microsoft Visual C++ 2010  x86 Redistributable - 10.0.40219
Microsoft Visual Studio 2010 Tools for Office Runtime (x64)
Microsoft Visual Studio Tools for Applications 2.0 - ENU
MSXML 4.0 SP3 Parser
MSXML 4.0 SP3 Parser (KB2758694)
MySQL Connector C++ 1.1.3
MySQL Connector J
MySQL Connector Net 6.7.4
MySQL Connector/ODBC 5.2 64bit (community edition)
MySQL Documents 5.6
MySQL Examples and Samples 5.6
MySQL For Excel 1.1.1
MySQL Notifier 1.1.4
MySQL Server 5.6
MySQL Workbench 6.0 CE
jaime56Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Seth SimmonsSr. Systems AdministratorCommented:
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HuaMin ChenProblem resolverCommented:
Sql server 2008 express will work in this config. Download it from
http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=26729

I think Sql server 2012 express can also work in your current machine.
1
jaime56Author Commented:
I will try Sql server 2012 express
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

jaime56Author Commented:
Which one to connect with Access 2007 32bit version in my 64bit environment? I know that  Access 2007 can not modify the "table design" of the tables in the SQLEXPRESS Local Server.
ENU\x64\SQLManagementStudio_x64_ENU.exe      600.2 MB
ENU\x86\SQLManagementStudio_x86_ENU.exe      614.9 MB
0
Seth SimmonsSr. Systems AdministratorCommented:
0
HuaMin ChenProblem resolverCommented:
As your current Win 7 OS is 64 bit, you can proceed with the Sql server with "x64".
0
jaime56Author Commented:
Thanks, it reads...
On a 64-bit computer, you must run packages that connect to Microsoft Access data sources in 32-bit mode. Both the Microsoft Jet OLE DB Provider and the OLE DB provider for the Microsoft Office 12.0 Access Database Engine are only available in 32-bit versions.
That means I need to use  x86 version?
Which is included in the x86 advanced version.

SQLEXPRADV_x86_ENU.exe 1.8 GB

http://www.microsoft.com/en-us/download/details.aspx?id=35579
0
jaime56Author Commented:
seth2740 solved it.  
Will use SQLEXPRADV_x86_ENU.exe (1.8 GB) because it is compatible with my 32 bit Access 2007.
 You have saved me many hours of trial and error. Thanks
0
jaime56Author Commented:
Saved me lots of hours of trial and error
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.