Access help

Auric Systems Access 2013 Project

Create all records using information from this document – not from your file cards. You will submit this project for grading.

Be sure to save this project where you can find it again later in the semester. You will need it again.

Start Access 2013
Click Blank Desktop Database icon once
Key AuricSystems as the file name
Click file folder to browse to the location where you will save the database (e.g. usb)
Create

In DatasheetView
Add Data Type-Number as the second field
Add Field Size-Long Integer as the third field

Change to Design View
Click the arrow and select Design View

Save As > Table Name > Customers
Create the following table

TO AVOID RELATIONSHIP PROBLEMS LATER, VERIFY THAT YOU KEYED FIELD NAMES EXACTLY AS SHOWN
Make sure the key icon appears in ID row

Change to Datasheet view. Select yes to save the table when prompted.

Enter the following two records into the Customer form. In ID field, do NOT enter a preceding zero. Type 1, not 01, 2, not 02, etc.

In Amount Pledged column, type digits and decimal points but do NOT type $

(Note: The table is divided for readability)

Entering data in Datasheet View is not confidential. You will create a form and enter data for customers 3-10 using the form. To create a form:
1. Close Customer table by clicking the black X. Hover over the X to see the words
Close Table 1 to verify that you are clicking the correct area.
2. In the Navigation pane, select Customers table by clicking it once.

3. Click Create tab.
4. Click Form – not Form Design
5. Click black X (close Customers) and save form as Customers

Open Customers form from Navigation pane

Notice that forms 1 and 2 are already entered because you typed that data in the datasheet. To advance to the next available form, click the New Black Record icon.


Enter the following records into the Customer Form. In ID field, do NOT enter a preceding zero. Type 3, not 03, etc.

In the Amount Pledged column, key digits and the decimal but do NOT key $ sign.

Notice how Andersen is spelled in the following record!

Close all open tables and forms by clicking black X that indicates close “Customers”

Create the following queries. Answers are at the end of this packet.

Query 1: List Last Name of all records:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click on the Last Name field to add it to the query
7. Click Sort row of Last Name field in the query box
8. Click the dropdown arrow
9. Click Ascending
10. Click the red ! Run icon
11. Widen columns as needed
12. Compare your query to the answers at the end of this packet
13. Close query
14. Save as Query 1

Query 2: List Company and Last Name:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click on the Company Name and Last Name field to add it to the query
7. Click Sort, Ascending, by Company
8. Also Sort, Ascending, by Last Name
9. Click the red ! Run icon. Notice it IS important that you add fields in the desired
order!
10. Widen columns as needed
11. Compare your query to the answers at the end of this packet
12. Close query
13. Save as Query 2
Query 3: List the ID, Last Name, and Phone for all records whose Last Name begins with “Ru”:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click to add these fields: ID, Last Name, Phone
7. Click Sort, Ascending, by ID
8. In the Criteria row of the Last Name field, enter ru* Be sure to key*
9. Run
10. Widen columns as needed
11. Compare your query to the answers at the end of this packet
12. Close query
13. Save as Query 3

Query 4: List the ID and State for all records with an ID greater than 7:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click on the ID and State field to add it to the query
7. In Criteria Row of ID field, enter >7
8. Click the red ! Run icon. Notice it IS important that you add fields in the desired
order!
9. Widen columns as needed
10. Compare your query to the answers at the end of this packet
11. Close query
12. Save as Query 4

Query 5: List the ID and State for all records with an ID greater than 5 but less than 10:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click on the ID and State field to add it to the query
7. In Criteria Row of ID field, enter >5 and <10. Be sure to type ‘and’ 8. Click the red ! Run icon. Notice it IS important that you add fields in the desired order! 9. Widen columns as needed 10. Compare your query to the answers at the end of this packet 11. Close query 12. Save as Query 5 Query 6: List the ID and Last Name for all records with an ID greater than 5 AND Last Name beginning with R: 1. Select Create tab 2. Select Query design button 3. Add Customers table 4. Close Show Tables window 5. Size table so that you can see all fields by dragging the bottom of the box down 6. Double click on the ID and Last Name field to add it to the query 7. In Criteria Row of ID field, enter >5
8. In Criteria Row of Last Name field enter r* Be sure to key *
9. Click the red ! Run icon. Notice it IS important that you add fields in the desired
order!
10. Widen columns as needed
11. Compare your query to the answers at the end of this packet
12. Close query
13. Save as Query 6

Query 7: List the ID and Last Name for all records with an ID greater than 5 OR Last Name beginning with R:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click on the ID and Last Name field to add it to the query
7. In Criteria Row of ID field, enter >5
8. In OR Row of Last Name field enter r* Be sure to key *
9. Sort by ID, Ascending
10. Click the red ! Run icon. Notice it IS important that you add fields in the desired
order!
11. Widen columns as needed
12. Compare your query to the answers at the end of this packet
13. Close query
14. Save as Query 7


Query 8: Using ID and Last Name fields, sort data by ID:
1. Select Create tab
2. Select Query design button
3. Add Customers table
4. Close Show Tables window
5. Size table so that you can see all fields by dragging the bottom of the box down
6. Double click on the ID and Last Name field to add it to the query
9. Sort by ID, Ascending
10. Click the red ! Run icon. Notice it IS important that you add fields in the desired
order!
11. Widen columns as needed
12. Compare your query to the answers at the end of this packet
13. Close query
14. Save as Query 8

ANSWERS

Be sure that you created forms for each customer. I will check your database to be sure that all forms are present and correct.

Query 1 Results

Query 2 Results

Query 3 Results

Query 4 Results


Query 5 Results

Query 6 Results

Query 7 Results


Query 8 Results

Place Similar Order Now!

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.
[order_calculator]