Free Essay

Access Database Assignments

In: Computers and Technology

Submitted By nournournour
Words 755
Pages 4
Illustrated Access 2013
Unit A: SAM Project 1a
Contact Management Database creating a table AND BUILDING A RELATIONSHIP

Project Goal
M Project Name
Project Goal

Illustrated Access 2013
Unit A: SAM Project 1a
Contact Management Database creating a table AND BUILDING A RELATIONSHIP

Project Goal
M Project Name
Project Goal

PROJECT DESCRIPTION
Your sales manager created a database with one table named Customers that stores the company name and contact information for customers. He asks you to create a new table named SalesReps to store company sales representative data. You’ll create the new table and add two records to it. Then you’ll create the relationship between the SalesReps and Customers tables.

GETTING STARTED * Download the following file from the SAM website: * IL_Access2013_UA_P1a_FirstLastName_1.accdb * Open the file you just downloaded and save it with the name: * IL_Access2013_UA_P1a_FirstLastName_2.accdb * Hint: If you do not see the .accdb file extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically. * Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website. *
PROJECT STEPS
Create and save a new table in Design View with one field as follows: a. Add a field with the name SalesRepNum and the Number data type. b. Set the SalesRepNum field as the table’s primary key. c. Save the table with the name SalesReps.
In Table Design View, add another field to the SalesReps table using the field name RepFirst and the Short Text data type.
In Table Design View, add a field to the SalesReps table using the field name RepLast and the Short Text data type.
In Table Design View, add a field to the SalesReps table using the field name HireDate and the Date/Time data type.
In Table Design View, add a field to the SalesReps table using the field name StartingSalary and the Currency data type. Save the SalesReps table and switch to Datasheet View.
Enter the two records shown in Table 1 below into the SalesReps table. Save and close the SalesReps table.
Table 1: SalesReps Data
© 2014 Cengage Learning.
© 2014 Cengage Learning.

SalesRepNum | RepFirst | RepLast | HireDate | StartingSalary | 1 | Jonathan | Plank | 1/1/14 | $41,000.00 | 2 | Tia | Lee | 2/1/14 | $41,500.00 |

Open the Customers table in Table Design View. Change the name of the field named First to ContactFirst, then change the name of the field named Last to ContactLast.
In the Customers table, change the data type property of the Comment field to Long Text.
Add a new field to the Customers table after the Comment field. The field should be named SalesRepNum and have the Number data type. Save and close the Customers table.
Open the Relationships window, then add the Customers table and the SalesReps table to the Relationships window. Close the Show Table dialog box. Create a one-to-many relationship between the SalesReps and Customers tables using the common SalesRepNum field. (Hint: Resize the field list for the Customers table so that all fields are visible in the field list.) Enforce referential integrity on the relationship. Save and close the Relationships window.
Open the Customers table in Datasheet View and resize the CompanyName field to be as wide as needed to display all of the data in the field. Save the Customers table.
Find, select, and delete the record with the CompanyNum field value of R12668 (and the CompanyName field value of KBR) from the Customers table.
Navigate to the record with the CompanyNum field value of R14855 (and the CompanyName field value of Petrohawk), then add a value of 1 to the SalesRepNum field.
Navigate to the previous record (with the CompanyNum field value of R14420 and the CompanyName field value of Moody National Bank), then add a value of 1 to the SalesRepNum field. Save and close the Customers table.
Open the SalesReps table in Datasheet View, then expand the subdatasheet for SalesRepNum 1. (Hint: You should see the two related records from the Customers table.) In the subdatasheet, find the record with the CompanyNum field value of R14420. In that record, change the value of the CompanyName field to First National Bank. Close the SalesReps table.
Save and close any open objects in your database. Compact and repair your database, close it, and exit Access. Follow the directions on the SAM website to submit your completed project.

*
excel

Similar Documents

Premium Essay

Cis 210 Week 6 Assignment 3 Strayer

...CIS 210 WEEK 6 ASSIGNMENT 3 STRAYER To purchase this visit following link: https://coursehomework.com/product/cis-210-week-7-assignment-4-strayer/ Contact us at: HELP@COURSEHOMEWORK.COM CIS 210 WEEK 7 ASSIGNMENT 4 STRAYER Strayer CIS 210 Assignment 4: Databases Due Week 7 and worth 100 points You are working as a corporate trainer for a large organization. There are several other trainers and many training topics. The company has grown quickly and scheduling has become difficult. The current method for scheduling involves writing trainer names and courses on a dry-erase board. This has led to issues with trainers changing the assignments in their favor and accidental erasure of some course assignments. Write a 4-5 page paper in which you: 1. Discuss the requirements needed to build a database for the scheduling process. 2. Describe the advantages and disadvantages of moving the schedule to a database. 3. Create a graphical representation of your proposed database environment. 4. Explain how referential integrity can prevent mistakes in a database, and do the advantages outweigh the difficulty of setting it up? 5. Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements: a. Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number,......

Words: 1222 - Pages: 5

Premium Essay

Dbm 502 Expert Tutor/ Indigohelp

...DBM 502 Entire Course For more classes visit www.indigohelp.com DBM 502 Individual Assignment: Implementing an Enterprise DBMS DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 DBM 502 Individual Assignment: Data Dictionary DBM 502 Individual Assignment: Database Security DBM 502 Learning Team Assignment: DBMS Implementation Plan ………………………………………………… DBM 502 Individual Assignment Comparing Database Software PART 1 OF 2 For more classes visit www.indigohelp.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses Refer to “Standards for Written Work” and “Standards•your results. for Presentations” in your Program Handbook, which can be accessed through the student Web site. ………………………………………………… DBM 502 Individual Assignment Comparing Database Software PART 2 OF 2 For more classes visit www.indigohelp.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses your results. Refer to “Standards for Written......

Words: 537 - Pages: 3

Free Essay

Deped

...what information is available. This may help you develop a research plan. Fourth Step: Investigating a topic Try to find out: • What books are available in your library? • What books are available in other libraries? • Which subscription databases seem to have relevant and appropriate articles? Fourth Step: Investigating a topic Locating Books in the OCC Catalog • Start by accessing the OCC Library homepage: http://www.ocean.edu/library/welcome.html • Click the “Find Books and Movies” link Fourth Step: Investigating a topic Locating Books in the OCC Catalog This will take you to the OCC Catalog. You can search here for books, Ebooks, media items (like videos and CDs), as well as print periodicals Fourth Step: Investigating a topic Locating Articles in the OCC Databases If you are ON campus: • Access the OCC Library homepage • Click the “Find Articles” link Fourth Step: Investigating a topic Locating Articles in the OCC Databases If you are OFF campus: • Log in to Ocean Cruiser • Click the “Announcements” icon • Then select “Access Library Databases From Off-Campus” Fourth Step: Investigating a topic How Do I Choose a Database? Fourth Step: Investigating a topic How Do I Choose a Database? No two...

Words: 1203 - Pages: 5

Premium Essay

Dbm 502 Learning Consultant / Tutorialrank.Com

...tutorialrank.com DBM 502 Individual Assignment: Implementing an Enterprise DBMS DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 DBM 502 Individual Assignment: Data Dictionary DBM 502 Individual Assignment: Database Security DBM 502 Learning Team Assignment: DBMS Implementation Plan ---------------------------------------------------------------------------- DBM 502 Individual Assignment: Comparing Database Software PART 1 OF 2 (UOP) For more course tutorials visit www.tutorialrank.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a 2- to 3-page paper that discusses Refer to “Standards for Written Work” and “Standards•your results. for Presentations” in your Program Handbook, which can be accessed through the student Web site. ------------------------------------------------------------------- DBM 502 Individual Assignment: Comparing Database Software PART 2 OF 2 (UOP) For more course tutorials visit www.tutorialrank.com Individual Assignment: Comparing Database Software Create a list of criteria that can be used to compare database software. Create a table that uses the list of criteria to compare and contrast Microsoft® Access, SQL, DB2, and Oracle®. Write a......

Words: 548 - Pages: 3

Premium Essay

Bsa 375

... | | |College of Information Systems & Technology | | |DBM/380 Version 9 | | |Database Concepts | | |July 16, 2012 to August 13, 2012 | | |Group KM11BIT13 | Copyright © 2012, 2010, 2008, 2007, 2006, 2005, 2003 by University of Phoenix. All rights reserved. Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • University policies: You must be logged into the student website to view this document. • Instructor policies: This document is posted in the Course Materials forum. University policies are subject to change.......

Words: 3236 - Pages: 13

Free Essay

Booking Assesment

...Dependencies 9 6.1 Proposal and Customer 9 6.2 Proposal and Invoice 9 6.3 Proposal and Work order 9 6.4 Work order and Work assignment 10 6.5 Work order and Task 10 6.6 Work Assignment and Employee 11 6.7 Work assignment and Materials 11 6.8 Work Assignment and Employee 12 7. M: N Relationships 13 7.1 Work_Assignment and Employee 13 7.2 Work_Assignment and Materials 13 7.3 Work_Order and Tasks 13 8. All possible tables of the ER Design 14 9. Why we need ER Diagram for the Scenario 18 10. Why we used relational model rather than using the hierarchical model 19 10.1 Hierarchical Model 19 10.2 Relational Model 19 10.3 Why we used Relational Database 19 11. Suggestions for the Improvements 21 12. Importance of the Database Modeling phase in a Database Development Project 22 12.1 Modeling Steps 22 12.2 Database Deigning Process 22 * Abstract Short Message Technology (SMS) is commonly used among the students modern world as it is a reliable mobile technology. Thus, to simplify the process of assignment booking and to save time SMS technology can be used effectively. In this project, the development of an SMS based assignment booking system is presented. Using the SMS interface, students would be able to send requests for time slots and receive the availability of that slot. Online assignment booking system completely depends on internet connection and also it consumes time. However, GSM coverage required for SMS......

Words: 6238 - Pages: 25

Premium Essay

Computer

...Week One: Database Architecture | | Details | Due | Points | Objectives | 1.1 Explain database architectures. 1.2 Define database systems. 1.3 Define relational database architecture. | | | Reading | Read Ch. 1, “Database Systems,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Read Ch. 2, “Data Models,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Read Ch. 3, “The Relational Database Model,” of Database Systems: Design, Implementation, and Management. | 9/24 | | Reading | Reference Ch. 1, “Getting Started,” of Database Concepts as a supplemental reading. | 9/24 | | Reading | Read Ch. 1, “Introduction to Access,” of Exploring Microsoft® Office Access 2010 Comprehensive. | 9/24 | | Reading | Read this week’s Electronic Reserve Readings. | 9/24 | | Participation | Participate in class discussion. | All week | 2 | Nongraded Activities and Preparation SkillSoft® Registration | The first time you access SkillSoft®, you need to register.Do the following to register for SkillSoft®: Go to https://uopx.skillport.com Register by clicking on Register. The Register button is in the lower right corner, below the login boxes.Leave the Organization Code field blank.Use your phoenix.edu e-mail address.Use your student website login name as your user ID (the name before the @email.phoenix.edu).Click Submit. | 9/24 | ...

Words: 2242 - Pages: 9

Premium Essay

Cis 210 Week 7 Assignment 4 Str

...CIS 210 WEEK 7 ASSIGNMENT 4 STR TO purchase this tutorial visit following link: http://wiseamerican.us/product/cis-210-week-7-assignment-4-str/ Contact us at: SUPPORT@WISEAMERICAN.US CIS 210 WEEK 7 ASSIGNMENT 4 STR Strayer CIS 210 Assignment 4: Databases Due Week 7 and worth 100 points You are working as a corporate trainer for a large organization. There are several other trainers and many training topics. The company has grown quickly and scheduling has become difficult. The current method for scheduling involves writing trainer names and courses on a dry-erase board. This has led to issues with trainers changing the assignments in their favor and accidental erasure of some course assignments. Write a 4-5 page paper in which you: 1. Discuss the requirements needed to build a database for the scheduling process. 2. Describe the advantages and disadvantages of moving the schedule to a database. 3. Create a graphical representation of your proposed database environment. 4. Explain how referential integrity can prevent mistakes in a database, and do the advantages outweigh the difficulty of setting it up? 5. Impress your boss by creating a database in Microsoft Access that will match trainers with courses and meet the following requirements: a. Two (2) tables, one (1) containing trainer information and the other containing course information. Create data for five (5) instructors and five (5) courses. The trainer data should include: employee ID number, last name,...

Words: 786 - Pages: 4

Premium Essay

Distributed Databases

...Assignment 8: Distributed Databases Due Week 9 and worth 50 points A few years have passed, and the restaurant has grown to become a national restaurant chain. Now, they are concerned that remote and branch offices and restaurants in all fifty states will not have ready access to the data. Your supervisor has asked you to write a report to address the concerns of the customer and figure out how to expand the single server / single location database so the other 500 locations will be able to access and update the system. Write a 2-3 page paper in which you: 1.List three (3) reasons why an organization may have a need for distributed databases and best practices for implementation of distributed database. 2.List and explain: ◦The software and hardware components of a distributed database. ◦Techniques for distributed data placement. ◦Strategies for distributed query processing. 3.Briefly explain how an organization would allow programmatic access to a database through the Internet. 4.Please make any or all appropriate assumptions to answer the following. ◦Propose a solution for the national restaurant chain on a distributed database system that will work for them. ◦Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length. 5.Use at least three (3) quality resources in this assignment.......

Words: 440 - Pages: 2

Premium Essay

It 240 Set 2 Week 5 Dq 2

...Computer Science - General Computer Science iLab 3 : Database Construction Using Access (100 Points) i L A B  O V E R V I E W   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. i L A B  S T E P S STEP 1 Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your Access database. ERD iLab Image 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......

Words: 390 - Pages: 2

Premium Essay

Second Chapter

...Unit 2 Assignment 1: Homework Learning Objectives and Outcomes Review documents to discover relevant entities and attributes for database. Prepare interview questions and follow up. Prepare questionnaires. Observe work flow for process and exceptions. Identify the issues with the current database. Define and list requirements of a database. Define business rules of a database. Define entities and attributes of a database. Identify candidate keys for entities of a database. Assignment Requirements Answer the following True or False questions on the student answer sheet. Required Resources Textbook Submission Requirements Submit your written answers to your instructor at the beginning of Unit 3. Unit 2 True/False Questions Indicate whether the following statements are true or false on the student answer sheet. 1) A requirement is something a database needs to do in order to fulfill its purpose.t 2) You only need to include the most important stakeholders in the database discussions.f 3) Forms are used for gathering input.t 4) A transaction database is optimized to track transactions in real time.t 5) Data mining uses business intelligence tools and techniques on a variety of data sources brought together in a data warehouses.t 6) The domain is the focus or knowledge area of a database.t 7) Interviews are good for asking open ended questions.t 8) Open ended question are questions that don't have......

Words: 687 - Pages: 3

Premium Essay

Syllabus

...a PDF for offline viewing. MET CS669 Database Design and Implementation for Business This course uses the latest database tools and techniques for persistent data and object-modeling and management. Students gain extensive hands-on experience with exercises and a term project using Oracle, SQL Server, and other leading database management systems. Students learn to model persistent data using the standard Entity-Relationship model (ERM) and how to diagram those models using EntityRelationship Diagrams (ERDs), Extended Entity-Relationship Diagrams (EERDs), and UML diagrams. Students learn the standards-based Structured Query Language (SQL) and the extensions to the SQL standards implemented in Oracle and SQL Server. Students learn the basics of database programming, and write simple stored procedures and triggers. The Role of this Course in the MSCIS Online Curriculum This is a core course in the MSCIS online curriculum. It provides students with an understanding and experience with database technology, database design, SQL, and the roles of databases in enterprises. This course is a prerequisite for the three additional database courses in the MSCIS online curriculum, which are CS674 Database Security, CS699 Data Mining and Business Intelligence and CS779 Advanced Database Management. By taking these three courses you can obtain the Concentration in Database Management and Business Intelligence. CS674 Database Security also satisfies an elective......

Words: 10777 - Pages: 44

Premium Essay

Harvard Curtin

...Washington, DC. Note: A modified APA style is used for electronic sources to fit in with the Harvard referencing style provided by Curtin University Library as the Style manual does not cover this area fully. The information and examples contained on this page are chiefly derived from the above publications. It is very important that you check your department or school's assignment guide as some details, eg. punctuation, may vary from the guidelines on this page. You may be penalised for not conforming to your school's requirements. What is Referencing? Referencing is a standardised method of acknowledging sources of information and ideas that you have used in your assignment in a way that uniquely identifies their source. Direct quotations, facts and figures, as well as ideas and theories, from both published and unpublished works must be referenced. There are many acceptable forms of referencing. This information sheet provides a brief guide to the Harvard referencing style. Within the text of the assignment the author’s name is given first, followed by the publication date. A reference list at the end of the assignment contains the full details of all the in-text citations. Why Reference? Referencing is necessary to avoid plagiarism, to verify quotations, and to enable readers to follow-up and read more fully the cited author’s...

Words: 3341 - Pages: 14

Premium Essay

Hostel Management

...System Requirement Specifications (SRS) Assignment 1 Sample Solution System Requirement Specifications 1 Table of Contents 1 2 3 Table of Contents ......................................................................................................................................................... 1 Problem Statement ....................................................................................................................................................... 2 Overview ...................................................................................................................................................................... 2 3.1 Background ............................................................................................................................................... 2 3.2 Overall Description ................................................................................................................................... 2 4 Investigation & Analysis Methodology........................................................................................................................ 2 4.1 System Investigation ................................................................................................................................. 2 4.2 Analysis Methodology .............................................................................................................................. 3 4.2.1 Feasibility study and requirements elicitation...

Words: 2557 - Pages: 11

Premium Essay

System Requirment

...System Requirement Specifications (SRS) Assignment 1 Sample Solution System Requirement Specifications 1 Table of Contents 1 2 3 Table of Contents ......................................................................................................................................................... 1 Problem Statement ....................................................................................................................................................... 2 Overview ...................................................................................................................................................................... 2 3.1 Background ............................................................................................................................................... 2 3.2 Overall Description ................................................................................................................................... 2 4 Investigation & Analysis Methodology........................................................................................................................ 2 4.1 System Investigation ................................................................................................................................. 2 4.2 Analysis Methodology .............................................................................................................................. 3 4.2.1 Feasibility study and requirements......

Words: 2557 - Pages: 11