June 2010
Intermediate to advanced
834 pages
29h 12m
English
Content preview from Access 2010: The Missing ManualBecome 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.
Getting Started: SQL Server Express
Before you can start using SQL Server Express, you need to install it. This process is long and it involves downloading some very big files—71 MB (megabytes) at the least. If you’re still using a dial-up connection, it could take you a few mind-numbing hours.
Note
Everything you learn in this chapter about Access and SQL Server Express also applies to the full version of SQL Server. However, if you have that version, you obviously don’t need to follow the download steps described here—instead, you can pop in your setup DVD and get going right away.
If you plan to run SQL Server Express on a server computer and share it with a bunch of people, the setup process can be a bit challenging. Simply installing SQL Server Express isn’t enough; you also need to configure it so other people can access it over a network, and then to grant these people permission to use specific databases. The following sections provide a basic overview of the steps. If your goal is to experiment with SQL Server and practice your Access upsizing skills, this chapter is quite possibly all the information you need to get started. But if you’re trying to set up a production server—that is, an instance of SQL Server that hosts real data and runs a real application on a company network—get a skilled network administrator to help you out.
Preparing for SQL Server Express
You install SQL Server on the computer where you plan to place the shared database. Typically, this is a computer ...
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.