BUTTONBAR DOCLICK WINDOWS

There will be a record, or form, for each employee. These 'forms' are called records in a database.

This is similar to creating a blank personnel form (on paper) that will be 'filled-in' for each employee (Name, Address, Phone Number, etc вЂ“ are called fields in a database).

Next you will be creating the fields that make up a database. Notice, under the Blue Bar at the top of the design screen that there are (3) things: Field name, Data Type, and Description, and, in the lower half of the window Field Properties (see arrows in image below). If the Table: Table1 image does not вЂњfillвЂќ the screen, click-on the small square between the вЂњminus and the XвЂќ in the upper right hand corner of the screen (see arrow and image on right). You should now see a Table1: Table design screen similar to the one below. To begin designing the database, please click-on the Design вЂњbuttonвЂќ at the top of the person: Database menu screen (see arrow on last page). Later, you can try Table Wizards when you have the 'feel' for creating a table. In other words, the PERSON database can be made-up of, or contain, many other databases (tables), reports, queries, etc.ДЇor now, we'll do a basic database (table) creation. As you create them, they will be shown in the 'white' area. You may create multiple Tables (Databases), as well as multiple other items associated with the items in the left border. You will notice at the top of the screen: Open, Design and New. The following person: Database menu screen should now appear.Д¬reating a Table You will notice, in the person:Database menu screen, in the left border: Tables, Queries, Forms, Reports, Pages, Macros, and Modules. Now click-on the Create button or tap the Enter key as shown on last page (see lower right arrow on last page). Delete any text that is entered in the area and then type-in the word PERSON as shown at the bottom of the above image (see lower left arrow). Your selection should now appear in the Save in: area Next click-in the area to the right of File Name. If you choose the C: drive, choose the folder in which you want to save by double clicking on the folder. If you choose the 3ВЅ Floppy (A:), make sure you have a formatted disk in the A drive. Point to the drive on which you want to save your database, and click-on it. Click-on the small down arrow on the right and it will show you the various disk drives available on which you can save (see right upper arrow above). In the upper left corner of the File New Database menu screen that appears, you will see a Save in: area (see upper left arrow above). WeвЂ™ll have to do several вЂњthingsвЂќ to set-up this screen to save your database. A File New Database menu screen, similar to the one below, will be on your screen. You can save your work on a floppy diskette in the A: Drive, or on your C: Hard Disk, or in some other drive, please save to these areas and substitute your Drive in the instructions.

Saving your work One of the unique things about Access database is that it requires you to save your database as soon as you enter the program. The New File menu screen at the on the right will appear when you click the left mouse button on Create a new file. So, always вЂњclick leftвЂќ unless we tell you otherwise. Left Mouse Button In this tutorial, whenever we indicate that you need to click the mouse, it will mean to click the left mouse button вЂ“ unless we indicate that you should click the right mouse button. In the Open area of the Access 2003 Getting Started Task Pane, click the left mouse button on Create a new file. There are few Task Panes in Excel and Access 2003. There are a lot of Task Panes in PowerPoint 2003, FrontPage and Publisher 2003 вЂ“ because they are so вЂњgraphicвЂќ in nature. Once you get used to the Task Pane, and its flexibility, we think youвЂ™ll like it. It replaces many of the Microsoft Menu Screens, Wizards, and Catalogs that were a part of the Office screens. The following Access 2003 Getting Started Task Pane will appear on the right side of your Access 2003 screen.ДЇor Access users, the Task Pane is something new in Office XP/20.

BUTTONBAR DOCLICK WINDOWS

Starting Access 2003 Double click on the Access 2003 icon on the Windows desktop (see right), or click-on the Start button in the lower left corner of the screen, then click-on Programs, and then click-on Microsoft Access. Creating a Database Using Access 2003 for Windows 2000/Me/XP

Buttonbar doclick