Database

Need Help in Database Assignment?
We can help you if you are having difficulty with your Database Assignment. Just email your Database Assignment at admin@assignmentcache.com.
We provide help for students all over the world in Database Assignment.

Items 1 to 10 of 39 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction
  1. Microsoft Access 2010 Chapter 4 Lab 1 Customer Balance Report

    Microsoft Access 2010 Chapter 4 Lab 1 Presenting Data in the ECO Clothesline Database

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 Chapter 4 Lab 1 Presenting Data in the ECO Clothesline Database


    Problem: The management of ECO Clothesline already has realized the benefits from the database of customers and sales reps that you created. The management now would like to prepare reports and forms for the database.


    Instructions: If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 3. Otherwise, see your instructor for information on accessing the files required in this book.


    Perform the following tasks:
    1. Open in Layout view the Customer Balance Report you created in Chapter 1 and revised in Chapter 3. Modify the report to create the report shown in Figure 4–81. Group the report by Customer Type and sort by Customer Number within Customer Type. Add the Amount Paid field to the report and include totals for the Balance and Amount Paid fields.


    2. Create the Customers by Sales Rep report shown in Figure 4–82. Include a total for the Balance field. Change the orientation to landscape. Make sure the total control displays completely. (Hint: Use Layout view to make this adjustment.)


    3. Create the Customer Financial Form shown in Figure 4–83. The form includes the date.


    4. Create mailing labels for the Customer table. Use Avery labels C2163 and format the labels with customer name on the first line, street on the second line, and city, state, and postal code on the third line. Include a comma and a space after city and a space between state and postal code. Sort the labels by postal code.


    5. Submit the revised database in the format specified by your instructor.

    Learn More
  2. Microsoft Access 2010 CHAPTER 4 Client Financial Form

    Microsoft Access 2010 CHAPTER 4 Apply your Knowledge AC 261 and AC 262

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 CHAPTER 4 Apply your Knowledge AC 261 and AC 262


    Creating a Report and a Form
    Instructions: Start Access. If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the Babbage CPA Firm database that you used in Chapter 3. Otherwise, see your instructor for information on accessing the files required in this book.


    Perform the following tasks:
    1. Create the Clients by Bookkeeper report shown in Figure 4–75. The report is grouped by bookkeeper number and sorted by client number within bookkeeper number. Include totals for the Amount Paid and Balance Due fields. Change the orientation to landscape.


    2. Create the Client Financial Form shown in Figure 4–76 for the Client table. The form includes the current date and is similar in style to that shown in Figure 4–3 on page AC 212.


    3. Submit the revised database in the format specified by your instructor.

    Learn More
  3. MS Access Chapter 2 Lab 1 Answer Lab 2-1 Step 1 Query

    Microsoft Access 2010 Chapter 2 Lab 1: Querying the ECO Clothesline Database

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 Chapter 2 Lab 1: Querying the ECO Clothesline Database

    Problem: The management of ECO Clothesline has determined a number of questions it wants the database management system to answer. You must obtain answers to the questions posed by management.
    Instructions: Use the database modified in the In the Lab 1 of Chapter 1 on page AC 66 for this assignment, or see your instructor for information on accessing the files required for this book.
    Perform the following tasks:
    1. Open the ECO Clothesline database and create a new query for the Customer table that includes the Customer Number, Customer Name, Amount Paid, and Sales Rep Number fields in the design grid for all customers where the sales rep number is 49. Save the query as Lab 2-1 Step 1 Query.
    2. Create a query that includes the Customer Number, Customer Name, and Amount Paid fields for all customers located in Virginia (VA) with a paid amount greater than $1,000.00. Save the query as Lab 2-1 Step 2 Query.
    3. Create a query that includes the Customer Number, Customer Name, Street, and City fields for all customers whose names begin with T. Save the query as Lab 2-1 Step 3 Query.
    4. Create a query that lists all cities in ascending order. Each city should appear only once. Save the query as Lab 2-1 Step 4 Query.
    5. Create a query that allows the user to enter the city to search when the query is run. The query results should display the Customer Number, Customer Name, Balance, and Amount Paid fields. Test the query by searching for those records where the client is located in Ashton. Save the query
    as Lab 2-1 Step 5 Query.
    6. Include the Customer Number, Customer Name, and Balance fields in the design grid. Sort the records in descending order by the Balance field. Display only the top 25 percent of the records in the query result. Save the query as Lab 2-1 Step 6 Query.
    7. Join the Sales Rep and the Customer table. Include the Sales Rep Number, First Name, and Last Name fields from the Sales Rep table. Include the Customer Number, Customer Name, and Balance from the Customer table. Sort the records in ascending order by sales rep’s last name and customer name. All sales reps should appear in the result even if they currently have no customers. Save the query as Lab 2-1 Step 7 Query.
    8. Open the Lab 2-1 Step 7 Query in Design view and remove the Sales Rep table. Add the Amount Paid field to the design grid. Calculate the total of the balance and amount paid amounts. Assign the alias Total Amount to the calculated fi eld. Change the caption for the Balance field to Due. Save the query as Lab 2-1 Step 8 Query.
    9. Create a query to display the average balance amount for all customers. Save the query as Lab 2-1 Step 9 Query.
    10. Create a query to display the average balance amount for sales rep 51. Save the query as Lab 2-1 Step 10 Query.
    11. Create a query to display the average balance amount for each sales rep. Save the query as Lab 2-1 Step 11 Query.
    12. Create the crosstab shown in Figure 2 – 92. The crosstab groups the total of customers amount paid amounts by state and sales rep number. Save the crosstab as State-Sales Rep Crosstab.
    13. Submit the revised database in the format specified by your instructor.

    Learn More
  4. Small Access Database Customers Table

    Small Business Jewelry Store Access Database with Form and Reports

    Regular Price: $20.00

    Special Price: $15.00

    Create a database using Microsoft Access.

    The database should contain three tables: Customers, Products, and Transactions; three queries: list of customers, transactions by customer, and transactions by product; and be something that a small business, such as a jewelry store or used car lot, can use for its daily needs.

    The database must contain an input form for the transactions and one report that is based on any of the queries; the tables must each contain 10 records; and the records in the transactions table must be created by way of the input form.

    In this assignment, use Microsoft Access to create the following: Forms Tables Queries Reports

    Learn More
  5. MS Access VBA code Week 7 assignment frmUpdateMediaLink

    MS Access Advanced: VBA code Week 7 assignment

    Regular Price: $20.00

    Special Price: $15.00

    MS Access Advanced: VBA code Week 7 assignment


    Create a simple excel spreadsheet with data to update the database.  This can hold any type of data to be used in this database In MS Access
    1) Create a form (frmUpdateMediaLink) to link the spreadsheet to a table in the database (you can link the spreadsheet manually using the wizard but you will lose 4 points). Please Create a FORM to accomplish this step… A Wizard, built into MS Access can accomplish the same task and if you do this, please let me know.

    2) Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any form of grid. This is another FORM… VBA CODE is needed to complete this step, I check this by Pressing Control-G and I see your VBA code. This step will take the information in this form and extract it and then populate a listbox, dropdownbox or a grid.

    3) Integrate the spreadsheet data into the application.
    HINT: the spreadsheet can contains any special list such new DVDs, or updated notes.
    Write a code to update (your inventory table, can be CD list or DVD list) from the list.
    HINT: for the update (the easy way) Same as above but an easier way to accomplish this
    - delete the current records then insert the records from the spread sheet extra credit (advanced way)
    - compare each record if it is new add it to the table, if it exists update the info from the spread sheet. If you are going to do this option please indicate in the student comments so I can look for it, make sure you upload the spread sheet with the database.

    Learn More
  6. MS Access Advanced: VBA code Week 6 assignment

    MS Access Advanced: VBA code Week 6 assignment

    Regular Price: $20.00

    Special Price: $15.00

    MS Access Advanced: VBA code Week 6 assignment


    You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report.
    1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run.


    2) Your code (for the button) will dynamically read the caption from the table and assign it to the button.
    HINT: Variables (table name) in other areas of the code should not be "hard-coded". If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change – the caption on the button for that table must change as well. Test it out …


    3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.
    HINT: Like the hint for #2 above do the same for the reports. No names should be hard-coded. This prevents errors in the long run which often break a program, and maintenance does not become a nightmare!! This approach is a widely utilized practice amongst professional developers in support of friendly user experience enhancements! Our users want to be able to press buttons that are logical, practical, and smart

    **My professor said that this assignment has to use the "DLookup" element in VBA.**

    Learn More
  7. Access Chapter 7 Make It Right Query 1

    Microsoft Access 2010 Chapter 7 Make It Right Correcting Errors in the Query Design

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 Chapter 7 Make It Right Correcting Errors in the Query Design

    Analyze a database, correct all errors, and/or improve the design.

    Instructions: Start Access. Open the College Pet Sitters database. See the inside back cover of this book for instructions for downloading the Data Files for Students, or see your instructor for information on accessing the files required in this book.

    College Pet Sitters is a database maintained by a small pet-sitting business owned by college students. The queries shown in Figure 7 – 37 contain a number of errors that need to be corrected before the queries run properly. The query shown in Figure 7 – 37a displays the Enter Parameter Value dialog box, but this is not a parameter query. Also, the owners wanted to assign the name, Total Amount, to the Balance + Paid calculation. Save the query with your changes.

    When you view the results for the query shown in Figure 7 – 37b, you get 30 records. You know this is wrong. Also, the query did not sort correctly. The query results should be sorted first by sitter number and then by descending balance. Correct the errors and save the query with your changes.

    Change the database properties, as specified by your instructor. Submit the revised database in the format specified by your instructor.

    Learn More
  8. Microsoft Access 2010 CHAPTER 3 Lab 2 Reorder Filter

    Microsoft Access 2010 Chapter 3 Lab 2 Maintaining the Walburg Energy Alternatives Database

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 Chapter 3 Lab 2 Maintaining the Walburg Energy Alternatives Database


    Problem: The management of the Walburg Energy Alternatives recently acquired some items from a store that is going out of business. You now need to append these new items to the current item table. You also need to change the database structure and add some validation rules to the database.
    Use the database modified in the In the Lab 2 of Chapter 2 on page AC 134 for this assignment. You also will use the More Items database from the Data Files for Students. See the inside back cover of this book for instructions for downloading the Data Files for Students, or see your instructor for information on accessing the required files.


    Perform the following tasks:
    1. Open the More Items database from the Data Files for Students.
    2. Create a new query for the Item table and add all fields to the query.
    3. Using an append query, append all records in the More Items database to the Item table in the Walburg Energy Alternatives database, as shown in Figure 3 – 87.
    4. Save the append query as Walburg Append Query and close the More Items database.
    5. Open the Walburg Energy Alternatives database and then open the Item table in Datasheet view. There should be 20 records in the table.
    6. The items added from the More Items database do not have a vendor assigned to them. Assign items 1234 and 2234 to vendor JM. Assign item 2216 to vendor AS. Assign items 2310 and 2789 to vendor SD.
    7. Create an advanced filter for the Item table. The filter should display records with fewer than 10 items on hand and be sorted in ascending order by Description. Save the filter settings as a query and name the filter Reorder Filter.
    8. Make the following changes to the Item table:
    a. Change the field size for the On Hand field to Integer. The Format should be fixed and the decimal places should be 0.
    b. Make Description a required field.
    c. Specify that the number on hand must be between 0 and 50. Include validation text.
    d. Add a calculated field Inventory Value (On Hand*Cost) following the Cost field. Format the field as currency.
    9. Save the changes to the table design. If a dialog box appears indicating that some data may be lost, click the Yes button.
    10. Add the Inventory Value field to the Inventory Status Report. Place the field after the Cost field. Save the changes to the report.
    11. Specify referential integrity between the Vendor table (the one table) and the Item table (the many table). Cascade the update but not the delete.
    12. Submit the revised More Items database and the Walburg Energy Alternatives database in the format specified by your instructor.

    Learn More
  9. Microsoft Access 2010 Chapter 3 Lab 1 Maintaining the ECO Clothesline Database Customer Split Form

    Microsoft Access 2010 Chapter 3 Lab 1 Maintaining the ECO Clothesline Database

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 Chapter 3 Lab 1 Maintaining the ECO Clothesline Database


    Problem: ECO Clothesline is expanding rapidly and needs to make some database changes to handle the expansion. The company needs to know more about its customers, such as the type of business, and it needs to ensure that data that is entered is valid. It also needs to update the records in the database.
    Use the database modified in the In the Lab 1 of Chapter 2 on page AC 132 for this assignment, or see your instructor for information on accessing the files required for this book.
    Perform the following tasks:
    1. Open the ECO Clothesline database and then open the Customer table in Design view.
    2. Add a Lookup field, Customer Type, to the Customer table. The field should appear after the Postal Code field. The field will contain data on the type of customer. The customer types are SAL (Salons, Studios, Fitness Clubs), SPG (Sporting Goods), and WMN (Women’s Wear). Save these changes to the structure.
    3. Using a query, change all the entries in the Customer Type column to WMN. Save the query as Customer Type Update Query.
    4. Open the Customer table and make the following changes. You can use either the Find button or Filter By Selection to locate the records to change:
    a. Change the customer type for customers CY12, FN19, LB20, RD03, TT21, and TW56 to SAL.
    b. Change the customer type for customer WS34 to SPG.
    c. Change the name of customer LB20 to Le Beauty Salon & Spa.
    5. Change the alternate background color on the datasheet to white and remove the vertical gridlines. Save the changes to the layout of the table.
    6. Create the following validation rules for the Customer table and save the changes.
    a. Specify the legal values SAL, SPT, and WMN for the Customer Type field. Include validation text.
    b. Assign a default value of WMN to the Customer Type field.
    c. Ensure that any letters entered in the Customer Number field appear as uppercase.
    d. Make Customer Name a required field.
    7. Open the Customer table and use Filter By Form to find all records where the customer is located in Lowton and has a customer type of WMN, and then delete these records.
    8. ECO Clothesline has signed up a sporting goods store, Ralph's (Customer Number RA21) and needs to add the record to the Customer table. Ralph's is at 72 Main in Lowton, TN 37084. Terry Sinson is the sales rep assigned to the account. To date, Ralph's has not been billed nor does the company owe for any services. Create a split form for the Customer table and use this split form to add the record. Save the split form as Customer Split Form.
    9. Specify referential integrity between the Sales Rep table (the one table) and the Customer table (the many table). Cascade the update but not the delete.
    10. Add the Customer Type field to the Customer Balance Report. The field should follow the Customer Name field. Save the changes to the report.
    11. Submit the revised database in the format specified by your instructor.

    Learn More
  10. Multitable Forms Camashaly Design Business Analyst Master Form

    Microsoft Access 2010 CHAPTER 5 Multitable Forms Camashaly Design AC 274 - AC 326

    Regular Price: $20.00

    Special Price: $15.00

    Microsoft Access 2010 CHAPTER 5 Multitable Forms Camashaly Design AC 274 - AC 326

    Project — Multitable Forms
    Camashaly Design uses its database to keep records about clients and business analysts. After using the database for several months, however, Camashaly has found that it needs to maintain additional data on its business analysts. The company wants to identify those business analysts who have a professional certifi cate in business analysis, store the start date of each business analyst in the database, and include notes about each business analyst as well as the business analyst’s picture. Additionally, business analysts now maintain files about potential contacts. These files are separate from the database; some are maintained in Word and others in Excel. Camashaly would like a way to attach these files to the corresponding business analyst’s record in the database. Finally, Camashaly wants to add the Phone Number field to the Business Analyst Table. Users should type only the digits in the telephone number and then have Access format the number appropriately. If the user enters 7195558364, for example, Access will format the number as (719) 555-8364.

    After the proposed fields have been added to the database, Camashaly wants users to be able to use a form that incorporates the Client and Business Analyst tables and that includes the newly added fields as well as some of the existing fields. The form also should include the client number, name, amount paid, and current due amount for the clients of each business analyst. Camashaly would like to see multiple clients on the screen at the same time (Figure 5 – 1). The database should allow users to scroll through all the clients of a business analyst and to open any of the attachments concerning the business analyst’s Client Notes. Finally, Camashaly requires queries that use the Certification, Start Date, and Comment fields.

    Learn More

Items 1 to 10 of 39 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction