New Perspectives Access 365 | Module 1: End of Module Project 1 Bowles College
BUILDING AN ACCESS DATABASE
· Excel Projects Help
GETTING STARTED
1. Save the file NP_AC365_EOM1-1_FirstLastName_1.accdb as NP_AC365_EOM1-1_FirstLastName_2.accdb
a. Edit the file name by changing “1” to “2”.
b. If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
2. To complete this Project, you will also need the following files:
Support_AC365_EOM1-1_Faculty.accdb
3. With the file NP_AC365_EOM1-1_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.
a. If the table does not display your name, delete the file and download a new copy.
PROJECT STEPS
1. You are a student affairs coordinator at Bowles College in Henderson, Nevada, and are developing an Access database to maintain data about student groups. You need to improve the current student group database by creating and modifying fields and tables, queries, forms, and reports. Open the Students table in Datasheet View and use FirstName to rename the current FName field and make it easier to interpret. Close the Students table.
2. Create a new table in Datasheet View to maintain advisor information. Change the ID field name to AdvisorID with the AutoNumber data type, add a field named AdvisorFirst with the Short Text data type, add a field named AdvisorLast with the Short Text data type, add a field named StartDate with the Date/Time data type, and add a field named Budget with the Currency data type. Save the table with the name Advisors and then close it.
3. Open the database Support_AC365_EOM1-1_Faculty.accdb, copy the 30 records in the Organizations table, and then paste them in the Advisors table in the project database. Close the Advisors table and the Support_AC365_EOM1-1_Faculty.accdb database.
4. Open the Groups table in Datasheet View, add a new record that contains the data shown in Table 1, and then close the table.
Table 1: New Record for the Groups Table
GroupID | GroupName | GroupType | Activities | Office | Members SG-172 | Anime Club | Cultural | Field | Public | 21
5. Open the Students table in Datasheet View and delete record 8 for StudentID F40886 (Floretta Franklin). Modify the BaseRate value for record 6 with StudentID C87578 (Jue Cho), using $17.00 as the new BaseRate value, and then close the Students table.
6. Create a query using the Simple Query Wizard. Choose the GroupName, GroupType, and Members fields from the Groups table. Show the record details, and use GroupList as the title of the new query. Open the query to view information, a portion of which is shown in Figure 1, and then close it.
Figure 1: GroupList Query
7. In the Navigation pane, rename the Group form using GroupEntry as the new form name.
8. Create a new form using the Form Wizard. Choose all the fields in the Students table. Choose a Columnar layout. Title the form StudentInfo, open the form to view information as shown in Figure 2, and then close it.
Figure 2: StudentInfo Form
9. Create a report using the Report Wizard. Choose the GroupName, GroupType, Office, and Members fields from the Groups table. Do not add any grouping levels. Sort the records in ascending order by GroupType and then in ascending order by GroupName. Use a Tabular layout and a Portrait orientation. Title the report GroupsByType, preview the report, a portion of which is shown in Figure 3, and then close it.
Figure 3: GroupsByType Report
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.