Petshop Logo Skills Approach Access 2013 Chapter 3 Working

Petshoplogopnga Skills Approach Access 2013 Chapter 3 Working With

In this project, you will continue working with the movie database from Chapter 2, On Your Own 2.5. You will create forms to enter new movies and loans. You will also create reports to keep a printed record of current loans. Save your changes often as you work through the project.

Skills needed to complete this project include creating various types of forms and reports in Microsoft Access 2013, such as single record forms, multiple item forms, split forms, wizard and blank forms, and reports with grouping and totals. Additionally, you will format controls, add design elements, apply themes, and control page setup for printing.

Download the resource file needed for this project from the Resources link, extract it after downloading, and follow specific steps to fix and modify forms and reports within the database. Tasks include rearranging and resizing controls, adding fields, fixing labels, inserting images, and adjusting report layouts. You will also create a new form for the Sales table that shows both datasheet and single record views, and modify reports to include missing data, group records, add totals, and format currency fields. Furthermore, apply the Organic theme to all forms and reports, and set the reports in landscape orientation for optimal viewing.

Finally, close the database, save your project file, and submit it for grading, ensuring all changes are saved and the project meets the specified requirements.

Paper For Above instruction

The meticulous process of designing and modifying forms and reports in Microsoft Access 2013 is crucial for creating an efficient and user-friendly database system. This project builds on foundational skills acquired in earlier chapters, emphasizing practical application in managing a movie database system that also incorporates movie loans, demonstrating the essential aspects of database design, form customization, report generation, and aesthetic consistency through theme application.

The initial step involves fixing the CustomersForm, which requires a careful rearrangement and resizing of controls to ensure a clear and logical data entry flow. Moving the LastName controls to the right of the FirstName controls improves the readability, aligning with standard data entry conventions. Similarly, repositioning the ZipCode controls adjacent to the City controls enhances geographical data input clarity. Moving the Phone controls beneath the City controls and adding the Newsletter field beneath Phone ensures a cohesive layout that facilitates intuitive data input. Resizing label controls to fit longer descriptions is essential for maintaining a neat and professional appearance. Including the store logo using the PetShopLogo image promotes brand identity and visual appeal.

The SalesForm requires analogous modifications, including repositioning controls for better data flow—moving FirstName to the right of SaleDate and placing LastName below, with Phone controls beneath LastName. Adding the Breed, MainColor, and AgeInMonths fields below AnimalType creates a logical grouping of animal-related data, simplifying data entry and analysis. Like the CustomersForm, fixing label widths and embedding the store logo enhances form aesthetics. Naming the form "Sales" improves clarity for users.

Creating a split form, SalesFormSplit, provides a hybrid view, allowing users to see both a datasheet and a detailed single record simultaneously—improving data overview and entry efficiency. This functionality is increasingly vital in business scenarios where rapid data review is necessary.

Adjustments to the PetsReport involve adding the missing PetID field as the first column, grouping records by animal type, and calculating average ages per group. Proper formatting of prices using Currency formatting enhances financial clarity. Embedding the store logo and adding the report title "Pet Inventory Report" improves branding and report identification. Including page numbers in centered footer, formatted as "Page N," and ensuring the report fits on a single page wide are critical for readability and presentation quality. Further adjustments in design view to streamline the report's width ensure it is print-ready.

Similarly, the SalesReport must include additional fields—LastName, FirstName, Phone (from Customers table), and AnimalType, Breed, Price (from Pets table)—properly placed to the right of PetID. Adjusting column widths prevents text wrapping, maintaining a clean appearance. Grouping data by sale date by month, summing the total Price, and formatting currency fields provide valuable insights into sales performance. Embedding the store logo, setting the report title "Detailed Sales Report," and adding page numbers follow best practices for professional report standards. Switching orientation to landscape ensures all data fits within one page across, and further adjusting report width optimizes space utilization.

Applying the Organic theme across all forms and reports ensures visual consistency, which is vital for branding and professional presentation. The final step involves closing the database, saving the updated project file, and submitting it for grading, demonstrating mastery of the skills involved in form and report creation, customization, and presentation within Microsoft Access 2013.

References

  • Simms, R. (2013). Microsoft Access 2013 Programming by Example: Beginner’s Guide. Wiley Publishing.
  • Carter, R. (2013). Microsoft Access 2013 Bible. Wiley Publishing.
  • Gaskin, J. (2014). Microsoft Access 2013 Step by Step. Microsoft Press.
  • Gaskin, J. (2014). Microsoft Access 2013 Programming. Microsoft Press.
  • Martyn, S. (2013). Access 2013: The missing manual. O'Reilly Media.
  • Microsoft Support. (2015). Create and format forms in Access. https://support.microsoft.com
  • Microsoft Support. (2015). Create reports in Access. https://support.microsoft.com
  • Bell, S. (2014). Effective report design in Access. Journal of Business & Technology Communication.
  • Schwede, K. (2014). The complete guide to Microsoft Access 2013. Pearson.
  • TechNet. (2015). Designing effective data reports. Microsoft documentation.

Related Assignments