Part 2: Provider Database In MS Access Use The Project Descr
Part 2provider Database Ms Accessuse The Project Description Here T
Use The Project Description Here T
Paper For Above instruction
The assignment requires creating a provider database in Microsoft Access to manage contact information for potential PC component suppliers. The database should include a table, form, reports, and a Word document answering specific questions.
First, launch MS Access, create a new blank database, and save it with a specific naming convention, for example, “JSmith Provider Information.” The main table, named “Provider Information Table,” must contain fields for provider details. These fields include an autonumber primary key called Provider ID, and text fields for company name, contact first and last names, billing address, city, state (2 characters), zip code (5 characters), phone area code (3 characters), phone number, currency field for YTD orders, and a Yes/No field indicating whether the provider is preferred based on YTD order criteria.
For each field, appropriate caption properties should be set to be displayed in reports. The data for seven providers should be entered via a form created using the Form Wizard with a columnar layout. The form must be themed differently from the default Office theme and named “Provider Data Entry Form,” with full visibility of field names. Data entry should include fictitious and realistic information, and at least one provider should be marked as preferred based on a YTD order threshold you set.
Next, use the Report Wizard to create a landscape-oriented report that displays provider company name, contact name, complete address, and phone number, sorted by contact last name. The report should be styled for readability with a style other than the default. Name the report “Provider Contact Information.” Additionally, create mailing labels in a report format, including contact name, full provider name, and address, and save this as “Provider Mailing Labels.”
Finally, develop a Word document set to double-spaced, Arial font, 12-point size, including a title page with the project title, your name, course ID, and due date. Answer two questions in four to five sentences: 1) what additional fields might be useful for selecting providers for purchasing computers? and 2) could Excel replace Access for this activity? Discuss the advantages and disadvantages of using Excel versus Access in this context. Save the Word file as “[Your First Initial][Your Last Name] Access Questions” and attach both the database file and Word document for submission.