Starting Access 1. Launch the Access program by double clicking on the Access icon on the desktop. A Microsoft Access window will appear. 2. Click New on the file menu or click the new file icon on the toolbar. 3. In the pane on the right side, click Blank database. 4. Type the file name Address Book. 5. Click Save in: text box. Specify location. 6. Click Create.

Creating a Table

1. Click the Tables tab in the database window. 2. Click New. 3. Go to Design View , Save Table as Addresses. 4. Create these columns AddressId (Auto Number) Primary Key ,FirstName (text) ,LastName(text), Address(text) , City (text), State(text), Postal Code (Number), and Home Phone Number(Text- Use input Mask for formatting in ###-###-####) 5. Close the Addresses table

Entering Table Data

1. Click the Tables tab in the database window. 2. Double click Addresses to open the table we have created. In the table fields, ignore the one labeled Addresses ID for now. 3. Press the right arrow key or tab key and enter these field values, pressing enter after each value:

First Name Last Name Address City State ZIPCode Phone # Betty Bop 123 Apple Way Houston TX 77333 (713)555-5555 Daffy Duck 5492 Hill St Houston TX 77009 (713)555-9999 Mickey Mouse 902 East Lucky Ave Humble TX 77398 (281)555-5555

4. Click Save and close the table.

Creating a Form

1. Click the Forms tab in the database window. 2. Click New. 3. The New Form Window appears.Make changes as per requirement. 4. Click Save and name it as AddressForm and close the form.

Entering Data into a Form In Access, you can enter data into Tables or Forms. Some find it easier to enter and view data in forms rather than tables. Lets use the form we just created to enter more data.

1. Click the Forms tab in the database window 2. Double click AddressForm to open the form. 3. Click the right pointing arrow with a star button at the bottom of the form. The form should be on the fourth record, which is blank. Enter the following field values. Press the enter key or tab key after each entry to move to the next cell.

First Name Last Name Address City State ZIPCode Phone # Sponge Bob 758 Awesome Way Houston TX 77999 (713)555-0000

4. Betty Bop is spelled incorrectly. Click the left arrow with a line button at the bottom of the form. This will automatically take you to the first record. 5. Click the Last Name text box with the word Bop. Click before the p and enter o. It should now read Boop. 6. Click Save and close the form. 7. Access should automatically update the table with the new form data. Click the Tables tab and double click Addresses to open the table 8. You should see the Sponge Bob record and the spelling correction of Boop in the table. 9. Click Save. 10. Close the table (click the X in the top right hand corner of the window.)

Queries

Lets find the people in our Address Book database that live in Houston. We are planning a last minute birthday party and need to call them immediately. We have four records in our database. If there were more records, it would be time consuming to go through all the addresses. Queries allow you to pluck only certain pieces of data out of your database. Lets make a query to find the people in our database that are located in Houston.

Query 1: Houston query

1. Click on table Addresses and then select Quert Wizard from Create tab, Select Simple Query Wizard and click OK 2. Click the downward pointing arrow on the right of the Tables/Queries: text box. 3. Select Table: Addresses. 4. Select First Name, Last Name, City, and Home Phone field values (click once to highlight the selection and then click the right pointing arrow or double click the selection) and move to the Selected Fields side of the window. 5. Click Next. 6. Under What title do you want for your query? type: Houston in the text box and click Finish. 7. The results are displayed. The records are displayed with four fields that were included in the search. We only want the records that include the city Houston. We have a little more work to do. 8. Select query Houston already created. Click on Design icon on the toolbar to look at the query in Design View. 9. At the bottom half of the screen there is a grid. Under the City column and along the Criteria row, we want to type: Houston in that cell. We are making a query, which looks for only those records that include Houston not the friends that live in Humble, for example. 10. Click the Run tool (red exclamation point) on the tool bar to get the results of the query. 11. The records that include Houston are displayed. Now we know who to call and their phone number.

Query 2: List all person last name and first name along with phone number whose Last name starts with b

Query 3: List all person last name and first name along with phone number whose first name has a in it.

Query 4: List all person last name and first name along with phone number whose address has Ave in it.

Query 5: List all person with first name along with phone number whose zip code is more than 77300