Office 2013 MyITLab Grade Instructions For Access Chapter

Office 2013 Myitlabgrader Instructionsexploring Access Chapter

Exploring Access Chapter 1 Assessment Project involving opening a database about a national conference, modifying speaker records, filtering sessions, adding new sessions, and creating relationships among tables.

Tasks include opening specific tables and queries, editing records, applying filters and sorts, adding new data, establishing table relationships with referential integrity, and formatting reports.

Paper For Above instruction

In the modern landscape of data management and organizational planning, Microsoft Access serves as a fundamental tool for creating structured databases that streamline complex information. The assessment project based on exploring Access for Chapter 1 demonstrates the essential skills required to effectively manipulate and relate data within a comprehensive conference database. This exercise not only refines technical proficiency but also emphasizes the importance of data integrity, accurate reporting, and efficient record handling in professional environments.

The initial step involves launching Microsoft Access and opening the specific database file, “exploring_a01_grader_A1,” which contains detailed information about a national conference. This foundational action sets the stage for subsequent data manipulations. The first substantial task is to locate and update the Speaker table. By opening this table in Datasheet view, users search for the record with SpeakerID P014, then modify the first and last names from Mary Miller to Mirijana Hinek, ensuring data accuracy and correctness. Sorting the table by SpeakerID in ascending order facilitates an organized view, enhancing ease of data review.

Subsequently, focus shifts to filtering session data. Using the “Speaker – Session” query, filters are applied via the Filter by Form feature to isolate sessions led by specific speakers, namely Cynthia Ahsley and Holly Davis. This process highlights the importance of targeted data retrieval for reporting and analysis. Sorting the filtered sessions by SessionID in ascending order paves the way for clear, ordered presentation, and the query is then closed after saving these configurations.

The next phase entails adding a new session through the Sessions form. Precise data input — including SessionID, Session Title, RoomID, Date, and Starting Time — exemplifies data entry best practices. Saving and closing the form confirms the new session’s inclusion within the database structure. Attention then shifts to the SessionSpeaker table: entering a new record linking SpeakerID 010 to SessionID 09 exemplifies establishing relationships at the record level. Sorting this table in descending order facilitates review, and final saving and closing ensure data consistency.

Relationship management constitutes a core element of relational databases. Opening the Relationships window, all four relevant tables are added, demonstrating comprehensive viewability and dependency tracking. Establishing referential integrity through specific relationships—between RoomID in Rooms and Sessions, SessionID in Sessions and SessionSpeaker, and SpeakerID in SessionSpeaker and Speakers—ensures data consistency. Closing and saving the relationship layout finalizes these structural constraints essential for maintaining database integrity.

The next focus is on reporting. The Master List reports for Sessions and Speakers are viewed in Layout view, then switched to Print Preview, where margin adjustments to Wide format are made. This enhances print readability and presentation quality. The report is then set to Report View, where a filter is applied to restrict data to sessions in Room 101 only. Saving the filter and closing the report ensure that filtered views can be reaccessed efficiently for future analysis.

Finally, closing all database objects and exiting Microsoft Access completes the project, underscoring the importance of clean workflow and data security practices. This comprehensive exercise consolidates foundational skills in database management, emphasizing the importance of accurate data entry, relational integrity, and effective reporting techniques—skills vital for professionals managing complex organizational data.

References

  • Gaskin, J. (2014). Microsoft Access 2013: The Missing Manual. O'Reilly Media.
  • Higgins, P. (2013). Microsoft Access 2013 Programming by Example. Packt Publishing.
  • O'Leary, C. (2014). Mastering Microsoft Access 2013. Packt Publishing.
  • Shannon, R. (2013). Microsoft Access 2013 Inside Out. Microsoft Press.
  • Olsen, B. (2013). Learning Microsoft Access 2013. Pearson Education.
  • VanderHeide, K., & Trumble, D. (2014). Microsoft Access 2013 Step by Step. Microsoft Press.
  • Barrett, H. (2013). Practical Microsoft Access 2013. Apress.
  • Asif, M., & Aamir, M. (2014). Data Management with Microsoft Access 2013. Springer.
  • Crawford, L. (2014). Implementing a Database in Microsoft Access. Wiley.
  • Deitel, P., & Deitel, H. (2014). Microsoft Access 2013 How To. Deitel & Associates, Inc.

Related Assignments