Data Files Contact Tables In Chapter 17
The Data Filecontactstable17located In The Chapter 17on Yourow
Open the data file ContactsTable17 located in the Chapter 17\On Your Own folder. Save the database as ContactsTable17Edited. Open the Contacts table in Datasheet view and examine the data it contains. Switch the table to Design view. Rename the ID field as ContactID, and then set this field as the table’s primary key. Change the Field Size property to 3. Use the Field Properties pane to set an appropriate caption as needed based on the data stored in each field. Use the Field Size property for Text fields to set an appropriate field size, based on your examination of the data in the datasheet. Set the Format property for the BirthDate field to Short Date. Set the Default Value property for the State field to UT. Save the table, and then switch the table to Datasheet view. Change the values in the appropriate columns for the record with Contact ID 201 to your first and last names. Change the value in the Title field if necessary. Resize each column in the datasheet so that all of the field values are displayed. Save and close the table. Compact and repair the database.
In the Navigation Pane, select the Contacts table, and then copy it to the Clipboard. Open the data file Contacts17 located in the Chapter 17\On Your Own folder. Save the database as ContactsList17. Use the Paste button to paste the copy of the Contacts table. In the Paste Table As dialog box that opens, edit the table’s name to Contacts and choose the option to paste the structure and data of the copied Contacts table. Open the Contacts table in Design view, and then delete the Title field from the table. Save and close the table.
Open the data file Reservations17 located in the Chapter 17\On Your Reservations folder. Use it to create a form based on the Reservations table. Navigate to the record with Reservation ID 513, and change the deposit amount to $1,700. Save the form as ReservationsForm and then close it. Use the Simple Query Wizard to create a query that includes all fields in the Contacts table except for the ContactID field. Save the query as ContactsList. Sort the query results in descending order by contact last name. Save and close the query. Create a report based on the Reservations table, and then delete the calculated field that adds all of the deposit amounts. Delete the line that remains, and then sort the report so that contact last name is the first column in the datasheet. Save the report as ReservationsList and then close it. Compact and repair the database, then close the database.
Paper For Above instruction
This assignment involves comprehensive database management tasks using Microsoft Access, focusing on data manipulation, table management, form and report creation, and database maintenance. The process begins with opening and editing a given contacts database, emphasizing understanding data structure, renaming fields, setting primary keys, and adjusting field properties such as caption, field size, format, and default value to conform with best data practices. These steps aim to enhance data clarity and integrity.
Subsequently, the assignment addresses data modification within datasheets, where specific record modifications occur based on identifiable attributes, such as Contact ID. Changing values for a particular contact and resizing columns are essential for improving user interface readability. After editing, the database is compacted and repaired to optimize performance and maintain the health of the database system, which is a vital step in database administration.
The task proceeds with copying a table from one database and pasting it into another, illustrating data transfer techniques. Renaming and structure pasting ensures data organization and integrity, which supports data consistency across multiple databases. Deletion of specific fields, such as the Title field, demonstrates data cleaning and schema adjustment capabilities.
Further, the creation of forms and reports based on the database tables illustrates how users can generate customized views and summaries of data for practical use. The form allows data entry and navigation to specific records, exemplified by the modification of the deposit amount for a specific reservation. Saving and closing procedures ensure proper form and report management.
The use of the Simple Query Wizard to generate a query that extracts and sorts data exemplifies querying skills essential for data analysis. Removing calculations and adjusting sort order towards the contact last name helps in organizing and understanding data relationships better. The creation of a report based on the reservations table consolidates data presentation skills, enabling users to generate summarized, printable representations of database data.
Overall, the procedural steps demonstrate essential database management tasks, including schema design, data editing, transfer, querying, report generation, and maintenance. These skills are fundamental in managing real-world databases efficiently, ensuring data accuracy, usability, and performance optimization. Mastery of these tasks enhances a user’s ability to maintain complex data systems and generate meaningful insights from data collections.
References
- Harrington, J. L. (2016). Relational Database Design and Implementation. Morgan Kaufmann.
- SQL in a Nutshell. O'Reilly Media.