Home > Articles > Databases > Access

Automatic Access: Using Wizards

  • PrintPrint
  • Share ThisShare This
  • DiscussDiscuss

The important concept in this sample chapter from Sams Teach Yourself Access 2002 in 21 Days is to understand that wizards can save you a lot of time and that you can study the generated database applications for ideas that you can use in your own database.

There are five object wizards in Access — for tables, queries, forms, reports, and pages. In addition, there is a wizard for creating whole databases. All the wizards, especially the Database Template Wizard, are useful for the Access student because you can get to see how Microsoft did it. Creating objects or whole databases using wizards, and then examining those objects in design view, gives you valuable insight into the minds of the Access engineers.

In the previous two lessons you learned theory and mostly introductory material. Many developers ignore the wizards, because they don't know about the benefits that can be gained by using them. The important concept behind today's lesson is to understand that the wizards can save you a lot of time and that you can study the generated database applications for ideas that you can use in your own database.

Today You Will Learn

In today's lesson, you will see Access wizards in action. Specifically, this lesson covers the following topics:

  • Why Automatic Access?
  • The Database Templates
  • Table Wizard
  • Query Wizard
  • Form Wizard
  • Report Wizard
  • Page Wizard

After you finish today's lesson, you will be able to pick and choose what wizard will help you most. Let's put the wizards to work!

  • Share ThisShare This
  • Your Account

Discussions

Make a New Comment

You must log in in order to post a comment.

Related Resources

There are currently no related podcasts. Please check back later.

Buck WoodyDealing with Data Defining the Components to Tune
By Buck Woody on 0:00 No Comments

I've been reading a fascinating article about the Large Hadron Collider, or LHC facility. It's a scientific research facility that houses a particle collider, which generates an incredible amount of data. Their original plan was to stream the data to tape, then sending the data to "islands" closer to the users, offloading the network as quickly as possible. But they found that the network could handle the streaming better than they thought - so they now stream the data directly to the users, saturating the network. It's a new way of thinking about moving the data around.

Buck WoodyWork Swarms
By Buck Woody on August 24, 2010 No Comments

I’ve been reading some excerpts from Gartner, Inc. and information from others on the changes they are seeing in the workplace. It’s holding true where I work and in the workplaces of the other data professionals I work with. One of those new trends is called “Swarming” – where informal teams get together to work on a particular project, and in some cases a single task, as a group. They then move on to another task, and so on, like a swarm of bees. These are less formal than the “Tiger Teams” I used to be part of that were also temporary, but had a more formal banding and dis-banding. The Gartner article states that this is more often the norm in companies than not.

Buck WoodyA combination of crowdsourcing, people helping people, and the best technical community there is
By Buck Woody on August 19, 2010 No Comments

I talk a lot about “giving back”. It’s a personal issue with me – I grew up quite poor, and from time to time someone would take notice that my mom and I didn’t have enough to eat, and they would help us out. I’ve never forgotten those folks.

See All Related Blogs

Informit Network