21-04-2012, 11:20 AM
Access 2007 Step by Step
accessstepbystep12007.doc (Size: 191 KB / Downloads: 51)
Starting Access
Click the Start button on the Windows taskbar, point to All Programs on the Start menu, and then point to Microsoft Access on the All Programs submenu (Access might be inside a folder for Microsoft Office, it depends on how you installed)
Click Microsoft Access
(If the Access window is not maximized, double-click its title bar to maximize it)
Creating a New Database
On the right hand side of the screen should be a panel for Blank Database, if not available
• Click the Blank Database icon or use the Office Button...New
Click on the folder that displays on the screen to the right of File Name so you can choose your file/Database location
In the File New Database Window that appears. Point/Click to 3½ Floppy (A/Your Flash Drive/Desktop…wherever you’d like to save…just remember where. [We need this for next week too]
Click in the File name text box.
Repeatedly press the BACKSPACE key to delete db1
Type Alisa Vending Services as the file name.
Click the Create button to create the database.
Creating a Table
You should automatically see a new Table (Table1:Table)
If not click on the Create Tab and click on Table in the Tables Group
The Table that is open will be in DataSheet View where you can do simple Data Entry
(It should look a lot like Excel)
Defining the Fields in a Table
To Define the Fields we’re going to switch to Design View
On the Home Tab click the down arrow under View and select Design View
You’ll be prompted to Save…Save the Table as Driver
Type Driver Number (the name of the first field) in the Field Name column
Press the TAB key
Text is the correct data type for what we’re about to do, [Review Data Types]
Press the F6 key to move the insertion point to the Field Size property box
Type 2 as the size of the Driver Number field.
Use the mouse to return to the Data Type column for the Driver Number field
Press the TAB key to move the insertion point to the Description column,
Type Driver Number (Primary Key) as the description
Access 2007 automatically assigns your first field as a Primary Key (which is generally good)
• You’ll see a small key icon next to Driver Number
If you don’t see that Driver Number is the Primary Key
• Point/Click on the Primary Key button on the Table Design toolbar to make Driver Number the primary key
[Every table must have a primary key which identifies the records in a Table]
Press the TAB key to move to the Field Name column in the second row
Defining the Fields in a Table Cont’
Use the techniques illustrated in the previous steps to make the entries from the Driver table structure shown here:
Save Table
Ctrl + S to Save or use the Office Button..Save
Entering Data in the Table
On the Home Tab click on View button to change from Design View to Datasheet View
Type 30 as the first Driver number.
Press the TAB key to complete the entry for the Driver Number field. [Data Saves Automatically]
Type the following entries, pressing the TAB key after each one:
Tuttle as the Last Name,
Larissa as the First Name
7562 Hickory as the Address,
Laton Springs as the City,
FL as the State, and
37891 as the Zip Code
16.00 as the Hourly Rate
Type 21,145.25 as the YTD Earnings