MIS 180 SIMNET ASSIGNMENTS

Access 2013 Chapter 1 Creating a Database and Tables Last Updated: 2/27/15 Page 1

USING MICROSOFT ACCESS 2013 Independent Project 1-4

Independent Project 1-4 Courtyard Medical Plaza (CMP) is a full-service medical office complex. For this project, you create a database, containing one table, to store information about the physicians who work at CMP. After creating the database, you add fields into the table, edit field properties, enter records, modify the datasheet layout, and sort and filter the data in the table. This project has been modified for use in SIMnet®.

Skills Covered in This Project

 Edit the default primary key.

 Add a new field into a table.

 Edit properties in Datasheet view.

 Save a table.

 Enter records.

 Change the datasheet layout.

 Sort data in a table.

 Filter data in a table.

1. Open the AC2013-IndependentProject-1-4.accdb start file.

a. Enable content in the security warning.

b. The file will be renamed automatically to include your name. Change the project file name if

directed to do so by your instructor.

c. Click the Table button [Create tab, Tables group] to create a new table. A new table opens in

Datasheet view.

2. Edit the default primary key and add new fields into the table.

a. Change the ID field name to DoctorID. Keep this field as an AutoNumber data type.

b. Enter the remaining fields into the table using the information in the following Data Type table.

h. After you enter the last field name, MoveInDate, press the down arrow key to remain in that

column.

i. Save the table as Physicians.

3. Edit the field properties of the Physicians table using the information in the following Field Name table.

4. Save the table after updating the properties.

Step 1

Download start file

c.

d.

e.

f.

g.

a.

b.

c.

d.

e.

f.

Access 2013 Chapter 1 Creating a Database and Tables Last Updated: 2/27/15 Page 2

USING MICROSOFT ACCESS 2013 Independent Project 1-4

5. Enter the data records shown in the following table into the Physicians table. Remember that the

DoctorID field is automatically entered by Access.

6. Change the layout of the Physicians table.

a. Change the Font Size to 12 pt.

b. Use AutoFit to increase the field width of the Specialty field.

c. Use AutoFit to increase the field width of the Tenant Since field.

d. Center-align the Doctor ID, Office, and Tenant Since fields.

e. Change the Alternate Row Color to Blue, Accent 1, Lighter 60% (fifth column, third row in the

Theme Colors category).

f. Save the changes to the layout.

7. Sort the Physicians table in ascending order by the Specialty field.

8. Remove the sort criteria.

9. Filter the Physicians table to find the doctors who moved in on or after 1/1/2010 and who have a

specialty in Pediatrics. The table should appear as shown in Figure 1-107.

10. Clear all the filters. The datasheet updates to show all the records.

11. Close the Physicians table.

12. Do not save any of the changes as a result of sorting or filtering the table.

a.

b.

c.

d.

e.

f.

g.

h.

i.

j.

k.

l.

m.

n.

Access 2013 Chapter 1 Creating a Database and Tables Last Updated: 2/27/15 Page 3

USING MICROSOFT ACCESS 2013 Independent Project 1-4

13. Add the following database properties.

a. Title: Courtyard Medical Plaza Physicians

b. Author: Caroline Rios

c. Company: CMP

d. Save the changes.

14. Close the database.

15. Upload and save your file.

16. Submit project for grading.

Step 2

Upload & Save

Step 3

Grade my Project