Wiley 978-0-470-17953-6 Datasheet

Browse online or download Datasheet for Software manuals Wiley 978-0-470-17953-6. Wiley Access 2007 Workbook For Dummies User Manual

  • Download
  • Add to my manuals
  • Print
  • Page
    / 12
  • Table of contents
  • BOOKMARKS
  • Rated. / 5. Based on customer reviews
Page view 0
Chapter 1
Getting Started with Access
In This Chapter
What is a database?
Opening Access
Checking out the Access interface
Exploring Office Online
Finding help on Access topics
M
icrosoft Office Access 2007 — which I refer to as Access throughout this book —
is the database component of the 2007 Microsoft Office System. If you’re familiar
with other programs in the 2007 Microsoft Office System — such as Word, Excel,
PowerPoint, and Outlook — you might already be familiar with the interface in Access.
However, Access contains many components not found anywhere else within the
Microsoft Office System.
In this chapter, you learn the very basics of databases, how to start and navigate Access,
and how to find help both online and offline.
Understanding What a Database Is
A database is just a collection of related information. The library’s card catalog, your
grandmother’s recipe cards, and the phone book are all examples of databases. Even if
they aren’t on the computer, they contain information you can retrieve relatively easily.
Putting these manual databases on the computer speeds up the retrieval of information.
You may have begun keeping lists in
Excel (Microsoft’s spreadsheet application). Or
perhaps you maintain your contacts in
Outlook (Microsoft’s e-mail application). And
you’ve no doubt used an
Internet search engine to look up information online. These are
all computerized databases that harness the power of the microprocessor to organize
and retrieve the information you need.
Defining two types of databases
A database management system (DBMS) is a computer software package designed for
managing databases. A DBMS controls the organization, storage, and retrieval of data
from a database. A DBMS contains data structures optimized to deal with large amounts
of data — some DBMS’s handle this data better than others.
05_179536 ch01.qxp 10/29/07 7:47 AM Page 9
COPYRIGHTED MATERIAL
Page view 0
1 2 3 4 5 6 ... 11 12

Summary of Contents

Page 1 - Getting Started with Access

Chapter 1Getting Started with AccessIn This Chapter What is a database? Opening Access Checking out the Access interface Exploring Office Online

Page 2 - Figure 1-1:

The Ribbon contains commands necessary to perform operations in Access. The Ribbonis broken down into tabs that contain different groups of commands:

Page 3 - Launching Access

Using the Navigation paneThe Navigation pane is where you access the objects in your database. You can collapsethe Navigation pane so you have more ro

Page 4

Finding help on Access topicsAccess provides help in a number of ways. You can always access the help files on yourlocal machine. If you have an activ

Page 5 - Creating a new database

A relational database management system (RDBMS) is a type of database managementsystem that stores data in related tables.For example, a table contain

Page 6 - Templates

FormsA form presents data from a table or query in a structured view instead of the row andcolumn format that a table shows. You create forms to Make

Page 7

Exercise 1-2: Creating Additional Icons to Launch AccessThe icons for launching Access are available only if you’ve added the Access program tothe des

Page 8 - Opening an existing database

The Getting Started with Microsoft Office Access page contains various sections andpanes that allow you to create blank databases, open existing datab

Page 9

6. Click the Microsoft Office Button and click Close Database to close the new blankdatabase and return to the Getting Started with Microsoft Office A

Page 10 - Using the Ribbon

4. Type Exercise1-5.accdb in the File Name text box.If you don’t want to change the database’s location, skip to Step 6.5. (Optional) Click the Folder

Page 11 - Using the Navigation pane

7. Click the Download button underneath the File Name text box.Access displays a message to verify you’re running a genuine copy of MicrosoftOffice.8.

Page 12 - Finding help on Access topics

In addition to clicking Open under the Microsoft Office button, you should be familiarwith the following methods of opening an existing Access databas

Comments to this Manuals

No comments