April 2007
Beginner
573 pages
12h 41m
English
Content preview from Beginning Access™ 2007 VBA
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
10.2. Setting Up SQL Server
Now that you are aware that you can use Access Projects to work with SQL Server databases, I will take a moment to cover the different versions of SQL Server and explain how to install SQL Server. You must install one of the versions of SQL Server in order to perform the examples used throughout this chapter.
10.2.1. SQL Server Versions
As you are probably aware by now, Microsoft SQL Server is a relational database management system for storing, analyzing, and reporting data. Currently, seven versions of Microsoft SQL Server are available with SQL Server 2005. Each is briefly described here:
SQL Server 2005 Enterprise Edition – This is the most comprehensive version of SQL Server 2005 and supports all the SQL Server 2005 features. This version is most appropriate for large organizations that are required to manage immense amounts of data quickly and efficiently.
SQL Server 2005 Standard Edition – This version of SQL Server 2005 supports many of the available features, but it doesn't support the features that enable management of immense amounts of data quickly and efficiently. This version is primarily for small or medium-sized organizations that do not have the complex database requirements of a large organization. SQL Server 2005 Standard Edition is still an extremely powerful version of SQL Server and supports Analysis Services (with a few exceptions), Replication, Full-Text Search, Integration Services (Basic Transforms only), the Common Language ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.