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 31 to 40 of 58 total

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

Grid  List 

Set Ascending Direction
  1. Martial Arts R Us MARU ERD

    COM 330 Martial Arts R Us (MARU) ERD and Access Database

    Regular Price: $20.00

    Special Price: $15.00

    Martial Arts R Us” (MARU) needs a database. MARU is a martial arts school with hundreds of students. It is necessary to keep track of all the different classes that are being offered, who is assigned to teach each class, and which students attend each class. Also, it is important to track the progress of each student as they advance.
    Create a complete Crow’s Foot ERD for these requirements:
    • Students are given a student number when they join the school. This is stored along with their name, date of birth, and the date they joined the school.
    • All instructors are also students, but clearly, not all students are instructors. In addition to the normal student information, for each instructor, the date that they start working as an instructor must be recorded, along with their instructor status (compensated or volunteer).
    • An instructor may be assigned to teach any number of classes, but each class has one and only one assigned instructor. Some instructors, especially volunteer instructors, may not be assigned to any class.
    • A class is offered for a specific level at a specific time, day of the week, and location. For example, one class taught on Mondays at 5:00 pm in Room #1 is an intermediate-level class. Another class taught on Mondays at 6:00 pm in Room #1 is a beginner-level class. A third class taught on Tuesdays at 5:00 pm in Room #2 is an advanced-level class.
    • Students may attend any class of the appropriate level during each week so there is no expectation that any particular student will attend any particular class session. Therefore, the actual attendance of students at each individual class meeting must be tracked.
    • A student will attend many different class meetings; and each class meeting is normally attended by many students. Some class meetings may have no students show up for that meeting. New students may not have attended any class meetings yet.
    • At any given meeting of a class, instructors other than the assigned instructor may show up to help. Therefore, a given class meeting may have several instructors (a head instructor and many assistant instructors), but it will always have at least the one instructor that is assigned to that class. For each class meeting, the date that the class was taught and the instructors’ roles (head instructor or assistant instructor) need to be recorded. For example, Mr. Jones is assigned to teach the Monday, 5:00 pm, intermediate class in Room #1. During one particular meeting of that class, Mr. Jones was present as the head instructor and Ms. Chen came to help as an assistant instructor.
    • Each student holds a rank in the martial arts. The rank name, belt color, and rank requirements are stored. Each rank will have numerous rank requirements. Each requirement is considered a requirement just for the rank at which the requirement is introduced. Every requirement is associated with a particular rank. All ranks except white belt have at least one requirement.
    • A given rank may be held by many students. While it is customary to think of a student as having a single rank, it is necessary to track each student’s progress through the ranks. Therefore, every rank that a student attains is kept in the system. New students joining the school are automatically given a white belt rank. The date that a student is awarded each rank should be kept in the system. All ranks have at least one student that has achieved that rank at some time.

    Learn More
  2. ITCO333 Unit 2 Word document

    ITCO333 Data Modeling and Design Unit 2 Individual Project

    Regular Price: $20.00

    Special Price: $15.00

    ITCO333 Data Modeling and Design Unit 2 Individual Project
    Deliverable Length: 1 Word document and 1 .accdb file

    Details: Create a SQL Server database called: ITCO333Database. Using Data Definition Language (DDL) and Data Manipulation Language (DML) you will create the below DEPARTMENTS and EMPLOYEES tables. Before you begin creating the new tables, review your tables created in Unit 1 IP to ensure that your database is in third normal form (3NF).

    Part 1:
    Your ITCO333 database should contain data related to the organizational departments in your Unit 1 chosen topic. Therefore, create a DEPARTMENTS table with the following field specifications:
    Field Name Data Type Other Comments and Requirements
    Department_ID   int Primary Key
    Department_Name nvarcha(50)
    Insert at least four records of sample data into the DEPARTMENTS table.

    Your ITCO333 database should contain data related to employees in your Unit 1 chosen topic. Therefore, create an EMPLOYEES table with the following field specifications:
    Field Name Data Type Other Comments and Requirements
    Employee_ID Int Primary Key Last_Name nvarchar(50) Cannot be null.
    First_Name nvarchar(50) Cannot be null.
    Birth_Date datetime
    Employment_Start_Date datetime
    Hourly_Pay decia(p[,s]) Must be greater that 0
    Department_ID Int Related to the DEPARTMENTS table.
    Create a foreign key constraint.
    Manager_ID Int Related to the Employee_ID in this table.
    Create a foreign key constraint.
    Insert at least eight records of sample data into the EMPLOYEES table.

    Part 2: Using your Unit 1 ERD, create tables, fields, primary keys and relationship constraints in your ITCO333Database.
    Insert your Unit 1 sample data into the newly created tables.

    Part 3: Generate a SQL Server Database Diagram.

    Additional Requirements: All tables must be in Third Normal Form (3NF). This may require you to normalize your Unit 1 data. Be sure to incorporate Instructor feedback from your Unit 1 IP. Use the following data types:
    Integers: int
    Decimals: decimal(p[,s])
    Strings: nvarchar(50)
    Date/Time: datetime

    Deliverable: One Word document with:
    SQL DDL to create database
    SQL DDL to create tables (including EMPLOYEES and DEPARTMENTS tables)
    SQL DML to insert data (including EMPLOYEES and DEPARTMENTS sample data)
    SQL Server Database Diagram

    The aforementioned SQL DML must be in text format (no screen shots).

    Learn More
  3. DBM 380 Week 4 Art Museum Visio ERD

    DBM/380 Week 4 Normalization of the Art Museum ERD

    Regular Price: $12.00

    Special Price: $10.00

    DBM/380 Week 4 Normalization of the Art Museum ERD


    The following assignment is based on the database environment chosen and created in that last request


    Your database project must meet the following assessment requirements:


    Design and develop a database using professional principles and standards.
    Provide a logical and physical design of the database.
    Use relational database software application to develop database.
    Provide an entity relationship diagram.
    Normalize the database.
    Generate and provide test data.


    Use a Microsoft® Visio® diagram to normalize the ERD to third normal form (3NF).


    Use the Microsoft® Access® database that you just created for me, create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.


    Note. Only the Microsoft® Visio® diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft® Access® database.


    Submit the ERD and final database.

    Learn More
  4. GetWell Inc MS Access Database

    GetWell Inc MS Access Database

    Regular Price: $15.00

    Special Price: $12.00

    GetWell, Inc. is a leading pharmaceutical organization. The organization wants to store all its customer and order details in an MS Access database. You need to perform the following tasks:

    Create a database called GetWell.
    Create two tables, Customer and OrderDetails, with the following information:

    Customer
    FieldName Type Size
    CustomerID Text 5
    CustomerName Text 25
    CustomerAge Text 3
    CustomerAddress Text 30

    CustomerID will be the primary key in the Customer table.

    OrderDetails
    FieldName Type Size
    OrderNumber Text 5
    CustomerID Text 5
    OrderDate Date/Time
    OrderValue Number
    Discount Number

    OrderNumber will be the primary key in the OrderDetails table.


    Enter following records in the Customer table:

    CustomerID CustomerName CustomerAge CustomerAddress
    C0001 Debbie Howe 28 123, Florida
    C0002 Ed Young 33 New York, 234
    C0003 Tom Wilkins 47 A-234 New Jersey
    C0004 XXXXX XXXXXe 76XXXXXSuite
    C0005 Ken Burton 52XXXXXNorth
    C0006 XXXXX XXXXX 65 53, N. Dakota
    C0007 XXXXX XXXXX 29 655, Wisconsin
    C0008 John Barrett 55 2234, Georgia

    Enter the following records in the Order table:

    OrderNumber CustomerID OrderDate OrderValue Discount
    O1207 C0003 10/1/2004 10500 10
    O2222 C0008 4/30/2005 26790 15
    O2657 C0001 11/23/2004 50000 15
    O3412 C0003 2/3/2004 222 0
    O4532 C0004 3/27/2005 12320 10
    O4578 C0006 6/8/2004 1110 5
    O4778 C0001 7/8/2004 3378 5
    O5732 C0007 4/15/2005 98700 15


    Write SQL statements for the database you have created to do each of the following:

    Display details of all the customers whose age is greater than 45 years.
    Display the names and addresses of all the customers who have placed orders with a value more than $10,000.
    Display the names of customers along with the values of the orders they placed after March 01, 2005.
    Create an INSTEAD OF trigger to display the message "You cannot update Order Value", if a user tries to update the OrderValue field in the Order table.

    Perform all the above activities using MS Access.

    Learn More
  5. Access VBA Tutorial 11 Challenge Case Problem 2 Parkhurst Health Center

    Access VBA Tutorial 11 Challenge Case Problem 2 Parkhurst Health Center

    Regular Price: $20.00

    Special Price: $15.00

    Case Problem 2
    Data File needed for this case problem: exercise.accdb (cont. from Tutorial 10)


    Parkhurst Health & Fitness Center Martha Parkhurst asks you to continue your work on the Exercise database by creating a new form and enhancing its accuracy and appearance. To help Martha with her request, complete the following steps:


    1. Open the Exercise database located in theAccess3\Case2 folder provided with your Data Files.


    2. Use the Form tool to create a form named frmMemberinfo using the tblMember table as the source table. Create a procedure for the frmMemberInfo form to convert City field values to proper case—capitalize the first letter of each word, and convert all other letters to lowercase. Test the procedure.


    3. Create a procedure to verify Phone field valuesin the frmMemberInfo form by doing the following:
    a. For a State field value of VA, the first three digits of the Phone field value must equal 703 or 804. If the Phone field value isinvalid, display an appropriate message, cancel the event, undo the change, and move the focus to the Phone field.
    b. No special action is required for other Phone field values.
    c. Test the procedure, and then save your form changes.


    4. Create a procedure for the frmMemberInfo form to do the following:
    a. Display the word current to the right of the MemberID text box in bold, magenta text only when the MembershipStatus field value is Active. Otherwise, display the
    word review in bold, blue text. (Hint: Remove all controlsfrom the control layout before resizing the MemberID text box and adding the label for the message. Use the Caption property in your VBA code, and make sure you enclose Caption property settings in quotation marks.)
    b. Test the modified form, and then save your form changes.


    5. Make a backup copy of the database, compact and repair the Exercise database, and then close the database.

    Learn More
  6. MIS582 iLab 3 Report 5 Student Info by Status

    MIS582 iLab 4 Forms and Reports

    Regular Price: $15.00

    Special Price: $12.00

    MIS582 iLab 4 Forms and Reports

    i L A B O V E R V I E W
    Scenario and Summary
    In this assignment, you will learn to create and save forms and reports in a provided Access database. To complete this assignment, you will need to be able to run Access 2010.

    Deliverables
    Name your Access database file using Lab4_, your first initial, and your last name (e.g., Lab4_JSmith.accdb). Create and save your Access database file. When you are done, submit your database to the Course Project Dropbox.

    i L A B S T E P S
    STEP 1
    • Download the Lab4_FormsReports.accdb database from Doc Sharing.
    • Rename the Lab4_FormsReports.accdb database with a name containing Lab4_, your first initial, and your last name as the file name (e.g., Lab4_JSmith.accdb).

    STEP 2:
    • Run Access 2010, either via Citrix or from Visio 2010 installed on your workstation.
    • Open the database you renamed in Step 1.

    STEP 3:
    Reports
    Create a report for each of the following requirements. Reports may be created using the wizard or an SQL query. Reports should follow the formatting guidelines given in the next step. Reports should be named as indicated below (e.g., Report1, Report2, etc.).
    1. Report1: Show Instructor information (Instructor_ID, First_Name, Last_Name) grouped by Approved Course_No.
    2. Report2: Show student information (Student_ID, First_Name, Last_Name, Status, Zip) grouped by Major.
    3. Report3: Show student information (Student_ID, First_Name, Last_Name, Major) grouped by Zip code. Zip codes should be in increasing order.
    4. Report4: Show student information (First_Name, Last_Name) grouped by Course Number and Course Name. Course Number should be in in increasing order.
    5. Report5: Show student information (Student_ID, First_Name, Last_Name, Address, Zip) grouped by Status. Students should be in alphabetical order by Last_Name and;then First_Name.

    STEP 4:
    Report Format
    • Reports should display two or more child rows for each parent row. For example, Report1 should display each Course_No with instructors who are approved to teach the course grouped under it. In this case, the parent row would be the Approved Course_No with Instructor listed as child rows underneath each parent row
    • There should be at least two child rows of data for each parent row. Add data to the tables in order to have reports show at least two child rows per parent.

    STEP 5:
    Form1: Create a form based on an SQL query.
    • Create and run an SQL query that displays Student Information (Student_ID, First_Name, Last_Name, Address, Zip).
    • Save the query in the database named Form1Query.
    • Create a form based on Form1Query. While Form1Query is selected, go to the Create menu and select Form to build the basic form.
    • Select the form and switch between the views (Forms, Layout, and Design) to change the properties or the form’s appearance as desired.
    • Save the form in the database named Form1Query.

    STEP 6:
    Form2: Create a form using the Form Wizard.
    • Invoke the Form Wizard as shown in the tutorials above.
    • Using the Form Wizard, create a form showing instructor information (Instructor_ID, First_Name, Last_Name, Office_No).
    • Switch between the views (Forms, Layout, and Design) to change the properties or the form’s appearance as desired.
    • Save the form in the database named Form2Wizard.

    STEP 7:
    Form3: Create a form using a master detail relationship. A master detail relationship is simply a 1:N relationship between two tables. Use subforms to format the form in a split data entry form as shown in Figure 1-9. You may use SQL queries or the wizard or both to create your form and subform.
    • Create a master form showing student information (Student_ID, First_Name, Last_Name, Address, Zip, Major, Status).
    • Create a detail Subform showing Student_ID, Class_ID, and Student_Grade.
    • For each student displayed, the student’s classes and grades should be displayed in the detail form.
    • Switch between the views (Forms, Layout, and Design) to change the properties or the form’s appearance.
    • Save the form in the database named Form3MaterDetail.

    STEP 8:
    When you are done, save the file on your local hard drive and upload it to the Course Project Dropbox. Your file should have the following filename format: Lab4_FirstInitialLastName.accdb.

    Learn More
  7. MIS582 iLab 3 Database Construction Using Access

    MIS582 iLab 3 Database Construction Using Access

    Regular Price: $15.00

    Special Price: $12.00

    MIS582 iLab 3: Database Construction Using Access

    iLAB OVERVIEW
    Scenario and Summary
    In this assignment, you will learn to create an Access database from a given ERD. To complete this assignment, you will need to be able to run Access 2010, either through Citrix or installed on your workstation or laptop.

    Deliverables
    Name your Access database file using Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). Create and save your Access database file. When you are done, submit your database to the Course Project Dropbox.

    iLAB STEPS

    STEP 1:
    Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your Access database.


    STEP 2:
    • Run Access 2010, either via Citrix or from Visio 2010 installed on your workstation.
    • Select the blank database icon in the main window.
    • Save the file with a name containing Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). In Citrix, 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.
    See the tutorials above for instructions on how to perform the following steps in Access 2010.


    STEP 3:
    Add tables to the Access database.
    • Add a table for each entity listed in the provided ERD diagram.
    • Add a column for each attribute listed in the provided ERD diagram.
    • Select a primary key for each table as indicated in the provided ERD diagram.

    STEP 4:
    For every column in every table, update the data type as needed to enforce the domain constraints of the data.
    • Dates should have a date data type.
    • Surrogate keys should be autonumbered.
    • Numeric data should have a numeric data type.
    • Character data should have a character data type.

    STEP 5:
    Draw relationships between your entities.
    • Selection Relationships under Database Tools. Move all your tables into the Relationship window by dragging them in or by using the Show Tables pop-up window.
    • Second item
    o Add the relationship between the tables in your database.
    o Enable referential integrity on the relationship.
    o Enable cascade updates on the relationship.

    STEP 6:
    Add at least two rows of data to each table in your database. Use any values you like for each of the columns. Remember that you must add data to parent tables before adding data to child tables, because referential integrity is enabled.

    STEP 7:
    Set the following column constraints in your database.
    • Student first and last name cannot be a null value.
    • Course credit hours must be between one and four.
    • Course name must be unique and cannot be a null value.
    • Instructor first and last name cannot be a null value.
    • Grade must be one of these values: A, B, C, D, F, I, W, or E. W signifies withdrawn and E signifies enrolled.

    STEP 8:
    When you are done, save the file on your local hard drive and upload it to the Course Project Dropbox. Your file should have the following filename format: Lab3_FirstInitialLastName.accdb.
    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.
    Note!
    Submit your assignment to the Dropbox located on the silver tab at the top of this page.

    Learn More
  8. DBM 380 Week 4 Art Museum Nomalized Access Database

    DBM 380 Week 4 Normalization of ERD

    Regular Price: $15.00

    Special Price: $12.00

    Individual Normalization of the ERD

    The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.

    Your database project must meet the following assessment requirements:

    Design and develop a database using professional principles and standards.

    · Provide a logical and physical design of the database.
    · Use relational database software application to develop database.
    · Provide an entity relationship diagram.
    · Normalize the database.
    · Generate and provide test data.

    Use a Microsoft® Visio® diagram to normalize the ERD to third normal form (3NF).

    Use the Microsoft® Access® database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.

    Note. Only the Microsoft® Visio® diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft® Access®database.

    Submit the ERD and final database to the appropriate Assignment link. Learn More
  9. DBM 380 Week 3 Art Museum Access Database

    DBM 380 Week 3 Entity Relationship Diagram

    Regular Price: $15.00

    Special Price: $12.00

    Individual ERD Creation Project

    The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.

    Use a Microsoft® Visio® diagram to create a detailed ERD using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty’s feedback.

    · Use a Microsoft® Access® database to create the preliminary database tables, columns with data types, primary keys, and relationships. Learn More
  10. CS251 Fundamentals of Database Systems Week 4 IP The Microsoft Access Database

    CS251 Fundamentals of Database Systems Week 4 IP The Microsoft Access Database

    Regular Price: $20.00

    Special Price: $15.00

    CS251 Fundamentals of Database Systems Week 4 IP The Microsoft Access Database

    Using Microsoft Access create the tables and relationships defined in your data model. Your Microsoft Access Database at this point should include the following:

    The Tables as defined in your Entity Relationship Diagram.
    The Relationships between the tables.
    3 Defined Queries. One of the queried needs to be created to show the data from the Many-to-Many relationship (or include three tables) originally identified from the initial requirements.
    Take a screenshot of the ERD and the Queries.

    Add the Screenshots to the section in your template titled: The Microsoft Access Database.

    Learn More

Items 31 to 40 of 58 total

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

Grid  List 

Set Ascending Direction