December 2006
Intermediate to advanced
409 pages
8h 3m
English
Content preview from Access® 2007 For Dummies®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.
Chapter 21. Hello! Creating an Interface to Welcome Data Users
In This Chapter
Plugging into a switchboard
Testing your switchboard
Keeping the switchboard running smoothly
Opening a database to the switchboard
If you plan for others to use your database, you may want to provide them with navigation tools so that they can easily find their way around your database (especially if they know nothing about Access). You might even want this luxury for yourself. It's much easier to move around a database with a menu system in place. Fortunately, the Switchboard Manager makes it easy to build such a system. Why it's not called the Menu Manager I'll never know, but for some reason, Microsoft likes the word switchboard — so switchboard it is! This chapter explains all there is to know about making your database user friendly via the Switchboard Manager.
To see a switchboard in action, download the sample files at http://www.dummies.com/go/access2007 Open the file Access 2007 Dummies.accdb and open the form Switchboard.
The Comings and Goings of a Switchboard
Before you create your switchboard, take a few minutes to plan out your database navigation. How do you want you and your users to navigate to the various forms and reports you've created?
If you have a simple database with a few data entry forms and several reports, it might be best to have a switchboard for the data entry forms and a switchboard for the reports.
If your database is more complex, you may need to break the forms and reports into ...
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.