Home > Articles > Data > Access

Exploring the Database Window in Microsoft Access

Get to know the Database window, the place where you can find everything you'll need in Access — data, forms, reports, and other objects. Learn how to navigate in this window and see how to start customizing objects for your own use.
This chapter is from the book

In this chapter

  • The Database window

  • A quick introduction to Access objects

  • Organizing objects

In Chapter 2, "Take a Quick Tour of Access," you learned about some of the Access user interfaces. So far, you've learned about the edges of the screen—the task panes, toolbars, and menus. Now it's time to tackle the core of Access itself: the Database window. As you'll learn in this chapter, the Database window is the place where you can find everything you'll need in Access—data, forms, reports, and other objects. You'll learn how to navigate in this window and see how to start customizing objects for your own use.

What's in the Database Window?

The easiest way to learn what's in the Database window is to open an Access database and explore. Fortunately, Access comes with several sample databases you can use for just this purpose. You don't have to worry about breaking anything because you can always reinstall the samples if a problem occurs. Now that you know how to launch Access (refer to Chapter 2 if you need a refresher), here's how to open the sample database called Northwind Traders:

  1. Launch Access.

  2. Select Help, Sample Databases, Northwind Sample Database.

NOTE

If you didn't install the samples when you installed Access, you'll be prompted to insert your Office CD-ROM the first time you try to open one of the sample databases.

When the Northwind database loads, you are presented with the splash screen shown in Figure 3.1. If you've seen this screen often enough, you can check the check box to make it go away. For now, just click the OK button and it will vanish. A splash screen is really just a programming trick that displays information about the application that's loading. It keeps you from getting bored while Access loads the database.

Figure 3.1Figure 3.1 The Northwind database splash screen.

After you dismiss the splash screen, your Access window contains two things, as shown in Figure 3.2. In the front is the Main Switchboard, which is actually an Access form designed to let you perform various functions in this sample database. You'll learn a bit about creating your own switchboard forms in Chapter 15, "Automating Your Database." For now, click the Close button (the X in the upper-right corner of the Main Switchboard) to make it go away. Behind the Main Switchboard is the Database window for this database.

Figure 3.2Figure 3.2 The Northwind database Main Switchboard and Database window.

Close the Main Switchboard form, and you're left with only the Database window. But there's a lot going on in this window! Here's a rundown of the parts of the Database window (Figure 3.3 shows where these items are located):

  • Shortcut buttons—Give you one-click access to common operations. The exact shortcut buttons available change depending on the type of object selected in the database.

  • Delete button—Deletes the object highlighted in the object list. Fortunately, it asks you to confirm before it actually deletes anything.

  • View buttons—Let you choose between large icon, small icon, list, and detail view in the object list.

  • Objects button—Opens the list of object types in the object bar at the left side of the window.

  • Shortcuts—Select the type of object to display in the object list. For example, in Figure 3.3, the Tables shortcut is selected, so the objects showing in the object list are all tables.

  • Groups button—Opens the list of groups in the object bar at the left side of the window. You'll learn more about groups later in this chapter.

  • Design shortcuts—Gives you easy access to ways to create new objects.

  • Object list—Shows all objects of the selected type. For example, with the Tables shortcut selected, you can see that the Northwind sample database contains a table named Categories, a table named Customers, and so on. Each of these is called a table object.

Figure 3.3Figure 3.3 The Database window in the Northwind database.

Take a moment and click a few of the shortcuts in the Northwind sample database. You'll see that dozens of objects of various types appear in this database. But you'll recall that when you make a new database, you're prompted to save only a single file. What's going on here?

The answer is that Access acts like its own little directory of files. When you look at an Access database in Windows Explorer, you can't see into it; it's just one big file. But when you open that database in Access itself, Access knows how to extract all the little files and display them by name in the Database window. Compared to some older databases, this is immensely convenient. To give someone an Access database, you just have to copy the one file, instead of rounding up dozens of little files (and probably missing some).

CAUTION

Because a database stores all your data in one place, you need to be especially cautious with database files. Access stores all your data in a single file with the extension .mdb. You therefore should make a backup copy of this file on a regular basis by copying it to a disk, a CD-ROM, or another computer.

Before digging into the actual objects—the tables, queries, forms, reports, and so on—you might want to change slightly the way things look in the Database window. If you increase the size of the window vertically (click the cursor on the bottom border of the window and drag down), it will eventually be tall enough to show all the shortcuts simultaneously. Click the Details view button to get more information on each object in the object list (although you'll see fewer objects at one time). Figure 3.4 shows the resized and restyled Database window.

Figure 3.4Figure 3.4 Another view of the Database window in the Northwind database.

Any Access database can contain seven types of objects (although it's possible that any of these types contain no objects):

  • Tables

  • Queries

  • Forms

  • Reports

  • Pages

  • Macros

  • Modules

Next, let's take a quick look at each of these objects. Don't worry, you'll learn about each one in more detail later in the book. For now, just concentrate on getting an overview of what the database contains.

Tables

Tables are where the data in a database is actually stored. The Northwind sample database has tables named Categories, Customers, Employees, and so on.

The Northwind sample database uses natural naming. That is, objects have names that identify what they contain or do. Some database designers advocate a more formal, program-like style for naming objects. You can view one such naming convention at http://msdn.microsoft.com/archive/en-us/dnaraccgen/html/msdn_20naming.asp. For your own databases, feel free to name objects in any way you feel comfortable with.

To see the data in a table, just double-click the table in the Database window. For example, Figure 3.5 shows the data in the Orders table (you can see it identified in the caption area of the window displaying the data). Click the Close button at the upper-right of the table window (not the main Access window!) to exit the table when you're done inspecting it.

Figure 3.5Figure 3.5 A table opened from the Database window.

If you right-click a table in the Database window, you'll get a shortcut menu of things you can do with the table. This shortcut menu varies depending on which type of object you've clicked, but some choices are the same. Right-click and select Properties to open the Properties dialog box for the table. Here you can type a description that will appear in the Database window when you're displaying objects in detail view.

You'll learn more about tables starting in Chapter 5, "Building Your First Tables."

Queries

Click the Queries object type (also known as a shortcut) button to see a list of queries in the Database window. Of course, you know that in plain English, queries are questions. But in the world of Access, it's easier to think of queries as the answers to questions.

For example, the Northwind sample database contains information on a fictional food importing company. The tables contain data on the customers of the company, the products the company sells, the employees who sell the products, the orders that customers have placed, and so on. You might think of the tables as a gargantuan filing cabinet filled with sales receipts, employee time cards, and so on.

Faced with this mass of data, you might want to ask some questions, such as, "What were the total sales of all our beverage products in 1997?" If you had the sales slips and a calculator, you could work this out. But in Access, you can use a query to find the answer quickly. Locate the query named Category Sales for 1997 in the Database window and double-click it. You'll see the answers in the form of a table, as shown in Figure 3.6. Close the query window by clicking its Close button when you're done inspecting its contents.

Figure 3.6Figure 3.6 A query opened from the Database window.

Even though queries look like tables when you open them, there's a difference. You enter data into the database through tables, and then retrieve it (possibly rearranged and summarized) through queries. You'll learn more about queries starting in Chapter 7, "Retrieving Data with Queries."

Forms

Click the Forms shortcut to see a list of forms in the Database window. Real life is full of forms: tax forms, medical insurance forms, rebate forms, and so on. Access forms share some of this fill-in-the-blank aspect, but they also offer additional flexibility that you'll never find in a paper form.

Just like tables and queries, you can open a form by double-clicking it in the Database window. For example, double-click the Employees form in the Database window to open it, as shown in Figure 3.7.

Figure 3.7Figure 3.7 A form opened from the Database window.

This particular form displays some information about Nancy Davolio, a sales representative for Northwind Traders. You can click the Company Info and Personal Info tabs to see two different sets of information.

But this form holds more than just information on Nancy Davolio. The set of controls at the bottom of the form is called the navigation bar. These controls let you select different sets of information to display. Click the right-facing arrow on the navigation bar (just to the right of the box containing the numeral 1), and the form shows Andrew Fuller's information. Keep clicking here and you can see every employee in the database. Close the form by clicking its Close button when you're done. In this particular case, the form is drawing its information from the Employees table, which you saw when you clicked the Tables shortcut. But forms need not display any data at all; they can also be a home for Windows controls such as push buttons and list boxes. For example, the Splash Screen (which you saw in Figure 3.1) and the Main Switchboard (which you saw in Figure 3.2) in the Northwind sample database are both forms.

You'll learn more about forms in Chapter 8, "Creating and Using Data Entry Forms."

Reports

Click the Reports shortcut to see a list of reports in the database. Reports provide a different way to display the data contained in tables. Reports are designed to be attractive when they're actually printed, although you can also view them onscreen. For example, locate and double-click the Summary of Sales by Quarter report. The report opens onscreen, as shown in Figure 3.8. If you move your cursor over the report, the cursor turns into a magnifying glass; click the report to see it with larger type.

Figure 3.8Figure 3.8 A report opened from the Database window.

If you look at the information in this report, you'll see that it consists of summary sales and orders numbers. Once again, Access has compiled this information by aggregating the raw data contained in the tables in the database.

If you have a printer, you can click the Print button on the Access toolbar to get a paper copy of the report. You'll find that the onscreen rendition is almost indistinguishable from the printed version.

Use the Close button on the preview window to close the report when you're done investigating it.

You'll learn more about reports in Chapter 9, "Printing Information with Reports."

Pages

Click the Pages shortcut to see a list of pages in the database. Pages are very similar to forms, but there's a twist: They can be displayed in a Web browser as well as in Access itself.

Right-click the Employees page and select Web Page Preview. This launches your default Web browser (most likely Internet Explorer) and loads the Employees page. As you can see in Figure 3.9, the page is very similar to the Employees form you saw in Figure 3.7.

Select File, Exit in the Web browser to close the page.

Access is the first database to let you so easily move your data to a Web site. You'll learn more about pages in Chapter 10, "Take Your Data to the Web with Pages."

Figure 3.9Figure 3.9 A page open in Internet Explorer.

Macros

Click the Macros shortcut to see all the macros in the database. Macros are lists of commands that Access can save and execute. For example, a macro might open up a particular form or prompt the user for some information. You'll learn just a bit about macros in Chapter 15. Until then, you won't need to use this object type.

Modules

Click the Modules shortcut to see a list of the modules in the database. Modules are objects that actually contain programming code, written in a language called Visual Basic for Applications (VBA). Modules are designed to give advanced users extra power in customizing a database and its contents. We won't be using modules in this book, although you might occasionally see a database that contains a module.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020