July 1999
Intermediate to advanced
432 pages
13h 10m
English
Content preview from Access Database Design and Programming, Second Edition
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.
Backing Up the Database
Once you’ve created the BOOKS database, it’s a good idea to make a backup copy of each of the tables. That way, you can feel free to make modifications to individual tables, to try out the book’s sample programs, and generally to experiment with the data, the tables, and the database, without having to be concerned that you’ll corrupt the data. You can make a backup copy by following this procedure for each of the four tables of the Books database:
Highlight the table you’d like to back up.
Select the Save As option from the File menu. Access opens the Save As... dialog shown in Figure 4.5.
Select the Within the current database button. Access will suggest a filename for your backup copy, such as Copy of BOOKS, as shown in Figure 4.5.
Click the OK button to create the backup copy. It will appear in the Tables property sheet of the Database dialog.
Figure D-5. The Save As... dialog
If the data in any of your tables do become lost or corrupted, you can restore the table as follows:
Highlight the backup copy of the table in the database window.
Select the Save As option from the File menu. Access again opens the Save As... dialog shown in Figure 4.5.
Select the Within the current database button.
Replace Access’ suggested filename (Copy of Copy of...) with the name of the original table and click OK.
Access displays a message warning that the name you entered has already ...
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.