MS Access

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

Items 11 to 20 of 58 total

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

Grid  List 

Set Ascending Direction
  1. Chapter 3 Case Problem Level 1 Antiques

    Succeeding in Business with Access Chapter 3 Case Problem 1 and 3

    Regular Price: $25.00

    Special Price: $20.00

    Succeeding in Business with Access 2010
    Chapter 3 Analyzing Data for Effective Decision Making

    Case Problem Level 1 - managing Customer Information for NHD Development Group Inc.
    Antiques.accdb complete solution from Step 1 - Step 12.

    Case Problem Level 2 - Retrieving Employee Information for MovinOn Inc.
    MovinOn.accdb complete solution from Step 1 - Step 12.

    Learn More
  2. 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
  3. 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
  4. 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
  5. Chapter 7 Lab 1  ECO Clothesline Database

    Microsoft Access 2010 Chapter 7 Lab 1 Querying the ECO Clothesline Database Using SQL

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 7 Lab 1 Querying the ECO Clothesline Database Using SQL

    Problem: The management of ECO Clothesline wants to learn more about SQL and has determined a number of questions it wants SQL to answer. You must obtain answers to the questions posed by management.

    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 6. Otherwise, see your instructor for information on accessing the files required in this book.

    Perform the following tasks:
    1. Find all customers where the customer type is SAL. Include the Customer Number, Customer Name, and Sales Rep Number fields in the result. Save the query as Lab 7-1 Step 1 Query.
    2. Find all customers located in Tennessee (TN) with a paid amount greater than $1,500.00. Include the Customer Number, Customer Name, and Amount Paid fields in the result. Save the query as Lab 7-1 Step 2 Query.
    3. Find all customers whose names begin with the letter, C. Include the Customer Number, Customer Name, and City fields in the result. Save the query as Lab 7-1 Step 3 Query.
    4. List all cities in descending order. Each city should appear only once. Save the query as Lab 7-1 Step 4 Query.
    5. Display the customer number, name, sales rep number, first name, and last name for all customers. Sort the results in ascending order by sales rep number and customer number. Save the query as Lab 7-1 Step 5 Query.
    6. List the average balance amount grouped by sales rep number. Name the average balance as Average Billed. Save the query as Lab 7-1 Step 6 Query.
    7. Find the customer number and name for every pair of customers who are located in the same city. Save the query as Lab 7-1 Step 7 Query.
    8. Find the customer numbers, names, and sales rep numbers for all customers that have open orders. Use the alias O for the Open Orders table and C for the Customer table. Each customer should appear only once. Save the query as Lab 7-1 Step 8 Query.
    9. Use a subquery to find all sales reps whose customers are located in Pineville. Save the query as Lab 7-1 Step 9 Query.
    10. Find the average balance amount for sales rep 44. Save the query as Lab 7-1 Step 10 Query.
    11. Submit the revised database in the format specified by your instructor.

    Learn More
  6. 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
  7. MIS582 Week 4 Course Project ABC Company Order Inventory System Database

    MIS582 Week 4 Course Project ABC Company Order Inventory System Database

    Regular Price: $25.00

    Special Price: $20.00

    MIS582 Week 4 Course Project ABC Company Order Inventory System Database


    PROJECT OVERVIEW:
    Scenario and Summary
    In this assignment, you will learn to create a physical database model in Visio from business requirements. To complete this assignment, you will need to be able to run Visio 2010, either through Citrix or installed on your workstation or laptop.


    Deliverables
    Name your Visio file as Lastname_Task2.vsd. Create and save your database model in your Visio file. When you are done, submit your document to the Week 4: Course Project Task 2 Dropbox.


    STEP 1
    Read the following business requirements closely to determine the entities and relationships needed to fulfill the requirements. The nouns in the paragraph will tell you the entities that will be needed. The adjectives that describe those nouns are the attributes of that entity. The verbs in the paragraph will help you determine the relationships between the entities.


    ABC Company Order Inventory System
    Database Requirements
    The ABC company has many stores in many locations that are divided in regions. The company supplies products to these stores. For the purposes of this database you may think that it is an American company in terms of regions such as Midwest.
    Each store is their customer/client. The company recognizes these stores by their store ID. They also keep track of the store name, address, and contact name.
    Stores may place orders online, or by phone/fax. Each order must be uniquely identified by an order number. Each order has a date on which the order was made, a date when the order was shipped, an employee who took the order (or it could be an online order), and the mode of payment.
    To make sure that the stores get their order on time, the stores are assigned to different warehouses in different regions. Currently, there is one warehouse for every region. Each warehouse is identified by its warehouse number. The company also tracks the address of the warehouse as well as a contact phone number.
    There are five regions: West, Midwest, Southwest, Southeast, and Northwest. Each region is identified by its unique name and unique number.
    Each warehouse holds many products for this company. A product may be found in many warehouses. The company keeps track of this inventory. At any point in time, the company must be able to find which warehouses carry this item, the quantity in stock, reorder point and whether this item is out of stock.
    Each product has a unique id, a description, a price. Each product could be on many orders, and an order may have multiple products on it. The company needs to track what quantity was ordered for each product and the total price for those products.
    Phone/Fax orders are processed by the employees of the company. The company keeps track of the employee’s id, first and last names, position, hire date, department they work for, their supervisor, and their salary.


    STEP 2
    • Run Visio 2010 either via Citrix or on your workstation.
    • Click on the Software and Database template group in the main window.
    • Double-click on the Database Model Diagram template to open a new file.
    • Save the file with the name Lastname_Task2.vsd. You will need to click the computer icon in the Save As window to see the different drives. Be sure to save the file to a local drive so it will be on your workstation.
    STEP 3
    Add an entity for each entity you identified in the requirements.
    • Drag the entity icon onto the drawing area in Visio.
    • In the Database Properties window, add a physical name to identify it.
    STEP 4
    For each entity, create a list of attributes you think would be useful to describe the entity.
    • Select an entity in the drawing area of Visio.
    • In the Database Properties window, select the Columns category.
    • Use the table to add your attributes to the selected entities.
    • Select the primary key (PK).
    STEP 5
    Set the diagram to use crow's feet notation.
    • On the Database tab, in the Manage group, click Display Options.
    • In the Database Document Option dialog, select the Relationship tab.
    • Select the Crow's Feet check box, and then click OK.
    STEP 6
    Draw relationships between your entities.
    • Drag the relationship icon onto a blank part of the drawing area.
    • Connect the two ends to each of the two entities in the relationship. The parent entity must have a PK defined. The entity will be outlined in bold red lines when it connects to one end of the relationship.
    STEP 7
    Set the cardinality of your relationships.
    • Select a relationship line in the drawing area that is connecting two entities.
    • In the Database Properties window, select the Miscellaneous category.
    • Select the cardinality for the selected relationship.
    STEP 8
    When you are done, save the file on your local hard drive and upload it to the Week 4: Course Project Week 4 Task 2 Dropbox. Your file should have the following filename format: Lastname_Task2.vsd.
    For instructions on how to copy files between the Citrix server and your local machine, watch the iLab tutorial, Copying Files From Citrix, located in the iLab menu tab under Course Home.


    Rubrics
    Points for will be awarded according to the following rubrics.
    • 10 Points: Visio drawing: E-R model is provided as a Visio diagram.
    • 10 Points: Entities: A minimum of six entities are present.
    • 10 Points: Attributes: There are more than two attributes per entity; in most cases there should be several.
    • 10 Points: Relationships: A minimum of six correct relationships are present.
    • 10 Points: Correct cardinality is specified on each relationship with crow's foot notation.


    Tutorials to Consult With
    DBP-e13-Appendix-F.pdf in the folder titled Visio Instructions Documents in Doc Sharing for how to use Visio 2013.
    kroenke_dbp12e_appendix_f.pdf in the folder titled Visio Instructions Documents in Doc Sharing for how to use Visio 2010.

    Learn More
  8. 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
  9. Microsoft Access 2010 Chapter 11 Lab 1 Designing a Database for Phils Limousine

    Microsoft Access 2010 Chapter 11 Lab 1 Designing a Database for Phils Limousine

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 11 Lab 1 Designing a Database for Phils Limousine


    Lab 1: Designing a Database for Phil’s Limousine
    Instructions: Consider the following set of requirements for Phil’s Limousine Service:
    • For each driver, the company keeps track of the driver’s name (first name and last name), driver’s address (street, city, state, postal code), driver’s license number, home telephone number, and cell telephone number.
    • For each limousine, the company keeps track of a unique limousine ID number, limousine license number, limousine color, and number of passengers the limousine can hold.
    • A driver can be assigned to more than one limousine. A limousine will have multiple drivers but only one driver at a time.
    Based on these requirements, do the following:
    1. Identify and list the entities and the attributes of those entities.
    2. Identify and list the functional dependencies.
    3. Create a set of 3NF relations using the shorthand notation given in the chapter. Be sure to identify all primary keys and foreign keys appropriately.
    Submit your database design in the format specified by your instructor.

    Learn More
  10. Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

    Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database


    Lab 1: Administering the ECO Clothesline Database
    Problem: ECO Clothesline has determined a number of database administration tasks that need to be done. These include creating a template, splitting the database, creating indexes, and adding table and field properties.


    Instructions: If you are using the Microsoft Offce Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 9. Otherwise, contact your instructor for more information about accessing the required files.


    Perform the following tasks:
    1. Open the Open Orders table in Datasheet view and add the Quick Start Priority field to the table. Assign a High priority to orders for customers AM23 and JN34. Assign a Low priority to the order for TT21. All other orders have a Normal priority.
    2. The Main Menu navigation form should display automatically when a user opens the database.
    3. Open the Customer table in Design view and create custom input masks for the following fields: Customer Number, State, Postal Code, and Sales Rep Number. The Customer Number field should consist of two uppercase letters followed by two numbers. The State field should contain two uppercase letters. Both the Postal Code and Sales Rep Number fields only can contain numbers.
    4. Create an index on the Customer Name field that does not allow duplicates. Create an index on the combination of Customer Type and Customer Name. Name the index TypeName.
    5. Save the ECO Clothesline database as a template with data but not as an application part. Create a new database from the ECO Clothesline template. Name the database ECO New. Split the ECO New database.
    6. Open the front-end database and add a logo to the Customer Master Form. You can create your own logo or use one o the sample pictures included with Microsoft Access. (Hint: See the BTW on page AC 645 for assistance with this task.)
    7. Submit the revised databases in the format specified by your instructor.

    Learn More

Items 11 to 20 of 58 total

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

Grid  List 

Set Ascending Direction