March 2005
Beginner to intermediate
378 pages
8h 46m
English
Content preview from Beginning InfoPath™ 2003
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.
3.2. Working with Various Databases
You've read about flat file and relational databases and now know the differences. There is some additional information you need to know about the available relational databases and their platforms. Before talking about Microsoft Access and SQL Server specifically, there is some terminology you need to get comfortable with.
3.2.1. File Server versus Client Server
File server databases are those where the database is stored in a folder on a file server. When you access the database, all the data is brought over the network and locally processed. Microsoft Access is a file-server-based database system.
Client/server databases are stored on a server, but when it comes time to process the data, the processing is performed on the server, and just the necessary data is brought over the network. Microsoft SQL Server is a client/server product.
With most development environments, how you develop against the two types of database platforms will vary. With InfoPath, you use the same methods for both platforms.
3.2.2. Front and Backends
When working with database applications, you have front- and backends. The database containing the data is the backend. The application created to control the input and output of the data is called the frontend. The application contains forms, reports, and other programming elements. When connecting to a database, the data source, such as Microsoft Access or SQL Server, is the backend and the InfoPath form is the frontend. ...
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.