Objective 3. Create a New Database

Plan your database on paper first. Determine what it is you want to keep track of and how you think the tables and their fields should be laid out. A good way to determine the layout of the tables is to ask yourself what questions you want the database to answer.

In this project, the purpose of the database is to keep track of the donations collected by student club members for the annual charity fundraiser. The questions to be answered include: Who made the donations? How much was donated by each donor? Has the pledged donation been collected? Because there is competition among the student clubs to see which club raises the most money, the database should also be able to answer these questions: What student collected which donation? To what club does the student who collected a donation belong? Which club collected the most money?

Activity 1.9. Creating a New Database

In this activity you will create a new database. There are two methods to create a new Access database: create a new database using a wizarda tool that walks you step by step through a process, or create a new blank databasewhich is more flexible because you can add each object separately.

Regardless of which method you use, you must name and save the database before you can create any objects. Think of an Access database file as a container that stores the database objectsthe tables, queries, forms, reports, and so onthat you create and add to the database.


Start Access, or if Access is open, close any open databases. On the Database toolbar, click the New button . Alternatively, from the File menu, click New. Compare your screen with Figure 1.23.

[Page 888]

Figure 1.23.


In the displayed New File task pane, under New, click Blank database. In the displayed File New Database dialog box, click the Save in arrow, and then navigate to your Access Chapter 1 folder where you are storing your projects.


Delete any text in the File name box and then, using your own information, type 1B_Fundraising_Firstname_Lastname In the lower right corner, click Create.

The Fundraising database is created and the Database window displays with the new database name indicated in the title bar of the Database window. The file format used to create this file also displays in parentheses following the file name.

[Page 889]

More Knowledge: Versions of Access

Understanding File Formats

To share data with computers that use different data management software, Access uses file formats that comply with international standardsstandards that include storage for music and languages like Japanese that use pictographs instead of letters. Newer versions of Access recognize older file formats, but older versions of Access do not recognize newer formats. Files that are not recognized by earlier versions of the same software are not backwardly compatible. Go to the Microsoft Web site to find conversion programs. The Access 2000 format is suitable for most uses where the text is written in English; this format is the default format used in Access 2003.

The default file format for your computer may be set to Access 2000 or to Access 2002 and 2003. This affects the format of new Access files that you create. The default file format can be changed in the Options dialog box on the Advanced tab. To learn more about Access file formats, in the Type a question for help box, type converting Access files. In this book, all of the files provided are created using the Access 2000 file format to provide maximum flexibility.

[Page 889 (continued)]

Windows XP

Outlook 2003

Internet Explorer

Computer Concepts

Word 2003

Chapter One. Creating Documents with Microsoft Word 2003

Chapter Two. Formatting and Organizing Text

Chapter Three. Using Graphics and Tables

Chapter Four. Using Special Document Formats, Columns, and Mail Merge

Excel 2003

Chapter One. Creating a Worksheet and Charting Data

Chapter Two. Designing Effective Worksheets

Chapter Three. Using Functions and Data Tables

Access 2003

Chapter One. Getting Started with Access Databases and Tables

Chapter Two. Sort, Filter, and Query a Database

Chapter Three. Forms and Reports

Powerpoint 2003

Chapter One. Getting Started with PowerPoint 2003

Chapter Two. Creating a Presentation

Chapter Three. Formatting a Presentation

Integrated Projects

Chapter One. Using Access Data with Other Office Applications

Chapter Two. Using Tables in Word and Excel

Chapter Three. Using Excel as a Data Source in a Mail Merge

Chapter Four. Linking Data in Office Documents

Chapter Five. Creating Presentation Content from Office Documents

Go! With Microsoft Office 2003 Brief
GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448

Flylib.com © 2008-2020.
If you may any questions please contact us: flylib@qtcs.net