Description
Unformatted Attachment Preview
CSC 121 - USING A COMPUTER SYSTEM I
Assignment #10 - Access - Creating and Using a Database
40 Points
Due February 19, 2015 at Midnight
Terms:
A database is a structured repository for storing data; it is a single file
that contains everything needed to define, analyze, manipulate, publish
and work with the data.
The data itself is stored in tables. A database can have one or more
tables. For example, you might have one table for storing employee
information, another table for storing client information and other tables
for storing information about service vehicles, replacement parts, sales
information, etc. Each table can be described as a grid of rows and
columns.
Each column in a table is a field which contains a specific piece of
information about that record (e.g. a name, a salary, a part number).
Each row in a table is a record which contains information about one
entity (e.g. one employee, one client).
Problem: A real estate company located in an ocean resort community provides
a rental service for apartment/condo owners. The company rents units by the
week to interested tourists and “snowbirds” (people who spend their winters in
warmer climates). The database consists of two tables. The Rental Unit table
contains information on the units available for rent.
Instructions: Perform the following tasks.
1. Create a new database in which to store all the objects related to the
rental data. Call the database Resort Rentals.
2. Create the Rental Unit table using the structure in Figure 10a. Use the
name Rental Unit for the table.
Figure 10a – Structure of Rental Unit Table
3. Add the data shown in Figure 10b to the Rental Unit table.
Figure 10b – Data for Rental Unit Table
4. Using the Report Wizard create a Rental Unit report for the Rental Unit
table.
5. Select the following fields to appear on the report:
Rental ID
Address
City
Weekly Rate
6. Select Next to continue.
7. Select Next to continue.
8. Select Next to continue.
9. Select Next to continue.
10. Change the title of the report to Available Rental Units Report.
11. Select Finish.
12. The report should look similar to Figure 10c
Assignment #10 Microsoft Access – Creating and Using a Database
2
Figure 10c – Report for Rental Unit
13. Upload the Resort Rentals database to Bb using the Assignment #10 link.
Assignment #10 Microsoft Access – Creating and Using a Database
3
Purchase answer to see full attachment
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Just what I was looking for! Super helpful.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
ITS 3102 SU SQL Statements Discussion
Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete ...
ITS 3102 SU SQL Statements Discussion
Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete, copy and paste the SQL statements in a Microsoft Word document:Write SQL statements:To update the publisher name from READ WITH US to READ FOR USTo verify the updated name field for the publisher with ID 6To make the following updates to the Publisher table (be careful with WHERE):Make Contact="John Travolta" for publisher with ID number 4Make Phone=888-999-7777 for TEXT AND MORETo list the customer numbers and names of all individuals who have purchased books in the information systems categoryTo identify the book written by an author with the last name Cain. Perform the search by using the author nameTo produce a list of all the customers who live in the state of Indiana and have ordered books on information systemsTo display a list of all the books in the Books table. If a customer has ordered a book, list the corresponding order number and the state in which the customer residesTo identify the authors of the books ordered by Sheila Smith. Perform the search by using the customer nameTo list the customer numbers and names of all the individuals who have purchased books in the children categoryTo add the following items to the Books table:ISBNTitleAuthorPubDateCostRetailCategoryPubID1234567890A Good BookJohn Jeffries10/11/200513.515.00Non-Fiction72314569874Trains for EveryoneCorey Berkey12/15/201110.2525.25Children81598745682Eating InSusan Smythe09/09/201220.0030.50Cooking699954123654Another Vampire StoryAnn Oats09/05/201011.2313.52Fiction41025874159Databases are Fun!Tony Stevens01/01/20134.125.23Information Systems9To delete the last record addedTo update the name Susan Smythe to Susan Smythe-Brown
CSU Module 5 Critical Thinking DNS Servers Projects
Consider the subject of DNS servers.
Why would a host contact a DNS server?
If a local DNS server does not know the I ...
CSU Module 5 Critical Thinking DNS Servers Projects
Consider the subject of DNS servers.
Why would a host contact a DNS server?
If a local DNS server does not know the IP address for a host name, what will it do?
What kind of organization must maintain one or more DNS servers? Why?
How does your organization protect itself from DNS cache poisoning? Do you think this is sufficient? Why or why not?
loops, programs, abstracts, Programming Essentials exam help
Question 1 A loop can also be known as a
DecisionSequenceIterationStructure 2 points ...
loops, programs, abstracts, Programming Essentials exam help
Question 1 A loop can also be known as a
DecisionSequenceIterationStructure 2 points Question 2 Abstracts a program’s various tasks or function into separate named blocks of code.
ModularizationCode blocksSubroutinesFlowcharts 2 points Question 3 Boolean expressions are only true True False 2 points Question 4 Component of a function used to get an output directly from that function.
foroutputreturnprint 2 points Question 5 Considered the brain of the computer
GPUCPURAMHDD 2 points Question 6 Loops are similar to decisions in that they have a condition statement which evaluates to a TRUE or FALSE value. True False 2 points Question 7 Serves the same purpose as a list, but is considered less flexible.
IterationArraysFlowchartCode 2 points Question 8 The Python Framework does inform you where an error occurred. True False 2 points Question 9 This programing element begins with the keyword def.
variablesfunctionskeywordslists 2 points Question 10 Used to define the scope in Python
{ }subindentation( ) 2 points Question 11 ____ within a list are identified by an index number, placed within square brackets after the name of the list. For example, names[0]
DecisionsItemsElementsCode 2 points Question 12 Python requires the user to specify a variable’s data type during creation. True False 2 points Question 13 It is arguable that recursion is just another way to accomplish the same thing as a while loop. True False 2 points Question 14 Scope is defined the same way in all programming languages True False 2 points Question 15 In Python, this serve as an alternative to a lists which offer slightly different functionality by replacing index values with names.
DictionariesEncyclopediasArraysObjects 2 points Question 16 Which of the following is NOT true about recursion
It is usually studied at the advanced levelIt can accomplish the same tasks as a for loopRecursion is used to solve complex problemsRecursion functions require more memory 2 points Question 17 Which is the following is NOT a basic programming concept listed in the lecture
Logic and SyntaxObjectsCode BlocksProduce Output 2 points Question 18 Is an example of an exception object in Python
TryDefValueErrorExcept 2 points Question 19 Incorporates the use of the three primary programming structures and logic strategies that create well organized, easy to read, and easy to understand program code.
Unstructured ProgrammingFlowchartPseudocodeStructured Programming 2 points Question 20 An example of declaring a new class object.
menuSelection = displayMenu()pets = {}pets = Pet()elif menuSelection == 4: 2 points Question 21 while True: , in Python, can be used to create an infinite loop. True False 2 points Question 22 The Python Framework does inform you where an error occurred True False 2 points Question 23 ____ is a critical component to being able to store data and information long term.
File AccessMemoryPrint functionwith 2 points Question 24 Error handling is also known as ___ handling
ResultRecursionExceptionCrash 2 points Question 25 We use a ______ block to handle thrown exceptions.
tryexceptkeywordslists 2 points Question 26 When does python limit access to global objects from within a scope?
When there is the presence of a newly created local variable with the same name as a global variable.When there is the presence of a newly created local variable with a different name than the global variable.When there are no new variables.When there is the presence of any newly created variable. 2 points Question 27 Passes multiple values into a function for processing
Global variableCode blockReturnParameter list 2 points Question 28 There is no limit to the number of except blocks a program can have. True False 2 points Question 29 When we pass a variable into a function and then modify that variable inside of the function, it also modifies the variable outside of the function that we passed into the function. True False 2 points Question 30 def calcBMI(hgt, wgt); BMI = wgt * 703 / hgt ** 2 return BMIWhat is wrong with the above code syntax
(hgt, wgt) should be (hgt; wgt)The ; should be a :The ** should be a ^The function code block needs to be closed with enddef 2 points Question 31 The function that can be used to generate a list of index values, useful in controlling a for loop:
list()range()rand()str() 2 points Question 32 The function used to import python code and objects from other python files.
buildaddimportprint 2 points Question 33 An interpreter converts the entire source code into an executable. True False 2 points Question 34 Compilers and interpreters have the following in common:
Reads the source code into machine code, all at once.Translates machine code into byte code.Reads the course code one line at a time.Translates source code into machine code. 2 points Question 35 The _______ block is used to perform normal operations, but allow an exception to be thrown, thus ending the _______ block.
TryExceptThrowCatch 2 points Question 36 def setPhone(self, phone): self.phone = phoneThe above code is an...
Mutator methodAccessor methodGlobal functionExcept Function 2 points Question 37 What does this operator mean <=
EqualApproximatelyGreater than or equal toLess than or equal to 2 points Question 38 Write a 4 element Python dictionary object that contains four colors as the names and their values as examples of something that is that color. Example: “red”: “apple”
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Content EditorUse arrow keys to select functionsPath: Words:0
2 points Question 39 Write a Python class definition for an Employee object that contains the following elements:Attributes:idnamewagedepartmentMethods:Initializer which sets ID, name, and wageSet NameSet DepartmentGet IdGet NameGet WageGet Department
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Content EditorUse arrow keys to select functionsPath: Words:0
2 points Question 40 In Python, all exceptions must be instances of a class that derives from BaseException. True False 2 points Question 41 Attributes are to variables, as methods are to ______________.
declarationsobjectsfunctionsexceptions 2 points Question 42 Programming method of solving a problem by solving a smaller version of the same problem, repeatedly
RepetitionProblem SolvingDebuggingRecursion 2 points Question 43 Function used to close a file once the program is done with that file.
end()close()finish()detach() 2 points Question 44 The len() function accepts an object and returns:
the object’s size in kilobytes.the number of elements in the object.part of the object.number of parameters in the object 2 points Question 45 _____ are part of the UML and is used to illustrate how your program’s functions will relate and support your organization’s various functions.
FlowchartsUse case diagramsClass diagramsCommunication diagrams 2 points Question 46 Comments in Python begin with:
///>*# 2 points Question 47 A UML diagram used to examine the various states that any objects will go through at various points in time
State machine diagramsUse case diagramsCommunication diagramsObject diagrams 2 points Question 48 The simplest way to produce output is using the _____ statement
GetTryPrintUse 2 points Question 49 Separates the keys when defining the contents of a dictionary.
({:[ 2 points Question 50 Statement used to delete a dictionary element
removedeleraseterminate 2 points Question 51 Which of the following is NOT a number type supported by python
charintlongfloat 2 points Question 52 What is the output of the following Python code:SIZE = 10numbers = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0]index = 0while index < SIZE: numbers[index] = index * 10 index = index + 1while index > 0: index = index - 1 print(numbers[index])
CS 520 UNH Exception Handling for C Programs on The Intel 64 Architecture Lab Report
The goal of this lab is for your exception handling support specified in Program 4 for
a C program to be able to specify ...
CS 520 UNH Exception Handling for C Programs on The Intel 64 Architecture Lab Report
The goal of this lab is for your exception handling support specified in Program 4 for
a C program to be able to specify a single exception handler (multiple/nested
exception handling will not be tested). Test cases will not include any error handling.
California University of Management and Sciences R Programming NLP Text Mining
Create bar charts showing the most common words that appear in The War of the Worlds with these four words (affect, denoun ...
California University of Management and Sciences R Programming NLP Text Mining
Create bar charts showing the most common words that appear in The War of the Worlds with these four words (affect, denounce, perish, soil) Show charts and your code with line by line comments. Create a network graph of words that show a .10 correlation of appearing together in the same section of The War of the Worlds. Comment your code line by line. Please add your commentary, in your own words, on what the graphs are showing. Related materials and code for references can be found here: https://www.tidytextmining.com/ngrams.htmlI need the rmd file so that I can execute the code on my mac and pdf of the output you executed. Always repeat the question you are answering. Thank you!
Similar Content
Linux Migration Proposal Presentation
Interacting with Linux
One of the topic areas you'll be addressing in your presentation for Faster Computing is graphical ...
ITS 450 CSUGC Javascript Programming for Public Health Initiatives Exam Practice
LOOK AT THE QUIZ QUESTION AND GET BACK TO ME WITH THE WRITE ANSWER ASAP...
Boston University Javascript Static Line Chart
Hello. I am build a static line chart contains five data points. However, my tooltips (d3.js version of chart legend) is o...
Wilmington University Countering Biological Table Top Exercise
It is critical that you attend this session over any other session. There is a level of interactivity that is going to tak...
Project 8 HTML
For this part of the project, we will focus on and search engine optimization. Search engine optimization is more than jus...
write a discussion
IPV4 is running out of addresses for devices in the world. Read the following article to understand more (IPV Article) IPV...
Template 2
Purpose: To promote understanding of the business need and to provide information to decisionmakers for resources and staf...
Final
1.) Explain the difference between direct costs, indirect costs, fixed costs, and variable costs, provide a real-world exa...
Erd
Problem 1: For each table in the database, identify the primary key and the foreign key(s). If a table does not have a for...
Related Tags
Book Guides
All Quiet on the Western Front
by Erich Maria Remarque
Orphan Train
by Christina Baker Kline
Little Fires Everywhere
by Celeste Ng
Herzog
by Saul Bellow
And Then There Were None
by Agatha Christie
12 Rules for Life
by Jordan Peterson
The Goldfinch
by Donna Tartt
The Scarlet Letter
by Nathaniel Hawthorne
Siddhartha
by Hermann Hesse
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
ITS 3102 SU SQL Statements Discussion
Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete ...
ITS 3102 SU SQL Statements Discussion
Write the following SQL statements in Microsoft Access by using the Books database from Week 2 Assignment 2. Once complete, copy and paste the SQL statements in a Microsoft Word document:Write SQL statements:To update the publisher name from READ WITH US to READ FOR USTo verify the updated name field for the publisher with ID 6To make the following updates to the Publisher table (be careful with WHERE):Make Contact="John Travolta" for publisher with ID number 4Make Phone=888-999-7777 for TEXT AND MORETo list the customer numbers and names of all individuals who have purchased books in the information systems categoryTo identify the book written by an author with the last name Cain. Perform the search by using the author nameTo produce a list of all the customers who live in the state of Indiana and have ordered books on information systemsTo display a list of all the books in the Books table. If a customer has ordered a book, list the corresponding order number and the state in which the customer residesTo identify the authors of the books ordered by Sheila Smith. Perform the search by using the customer nameTo list the customer numbers and names of all the individuals who have purchased books in the children categoryTo add the following items to the Books table:ISBNTitleAuthorPubDateCostRetailCategoryPubID1234567890A Good BookJohn Jeffries10/11/200513.515.00Non-Fiction72314569874Trains for EveryoneCorey Berkey12/15/201110.2525.25Children81598745682Eating InSusan Smythe09/09/201220.0030.50Cooking699954123654Another Vampire StoryAnn Oats09/05/201011.2313.52Fiction41025874159Databases are Fun!Tony Stevens01/01/20134.125.23Information Systems9To delete the last record addedTo update the name Susan Smythe to Susan Smythe-Brown
CSU Module 5 Critical Thinking DNS Servers Projects
Consider the subject of DNS servers.
Why would a host contact a DNS server?
If a local DNS server does not know the I ...
CSU Module 5 Critical Thinking DNS Servers Projects
Consider the subject of DNS servers.
Why would a host contact a DNS server?
If a local DNS server does not know the IP address for a host name, what will it do?
What kind of organization must maintain one or more DNS servers? Why?
How does your organization protect itself from DNS cache poisoning? Do you think this is sufficient? Why or why not?
loops, programs, abstracts, Programming Essentials exam help
Question 1 A loop can also be known as a
DecisionSequenceIterationStructure 2 points ...
loops, programs, abstracts, Programming Essentials exam help
Question 1 A loop can also be known as a
DecisionSequenceIterationStructure 2 points Question 2 Abstracts a program’s various tasks or function into separate named blocks of code.
ModularizationCode blocksSubroutinesFlowcharts 2 points Question 3 Boolean expressions are only true True False 2 points Question 4 Component of a function used to get an output directly from that function.
foroutputreturnprint 2 points Question 5 Considered the brain of the computer
GPUCPURAMHDD 2 points Question 6 Loops are similar to decisions in that they have a condition statement which evaluates to a TRUE or FALSE value. True False 2 points Question 7 Serves the same purpose as a list, but is considered less flexible.
IterationArraysFlowchartCode 2 points Question 8 The Python Framework does inform you where an error occurred. True False 2 points Question 9 This programing element begins with the keyword def.
variablesfunctionskeywordslists 2 points Question 10 Used to define the scope in Python
{ }subindentation( ) 2 points Question 11 ____ within a list are identified by an index number, placed within square brackets after the name of the list. For example, names[0]
DecisionsItemsElementsCode 2 points Question 12 Python requires the user to specify a variable’s data type during creation. True False 2 points Question 13 It is arguable that recursion is just another way to accomplish the same thing as a while loop. True False 2 points Question 14 Scope is defined the same way in all programming languages True False 2 points Question 15 In Python, this serve as an alternative to a lists which offer slightly different functionality by replacing index values with names.
DictionariesEncyclopediasArraysObjects 2 points Question 16 Which of the following is NOT true about recursion
It is usually studied at the advanced levelIt can accomplish the same tasks as a for loopRecursion is used to solve complex problemsRecursion functions require more memory 2 points Question 17 Which is the following is NOT a basic programming concept listed in the lecture
Logic and SyntaxObjectsCode BlocksProduce Output 2 points Question 18 Is an example of an exception object in Python
TryDefValueErrorExcept 2 points Question 19 Incorporates the use of the three primary programming structures and logic strategies that create well organized, easy to read, and easy to understand program code.
Unstructured ProgrammingFlowchartPseudocodeStructured Programming 2 points Question 20 An example of declaring a new class object.
menuSelection = displayMenu()pets = {}pets = Pet()elif menuSelection == 4: 2 points Question 21 while True: , in Python, can be used to create an infinite loop. True False 2 points Question 22 The Python Framework does inform you where an error occurred True False 2 points Question 23 ____ is a critical component to being able to store data and information long term.
File AccessMemoryPrint functionwith 2 points Question 24 Error handling is also known as ___ handling
ResultRecursionExceptionCrash 2 points Question 25 We use a ______ block to handle thrown exceptions.
tryexceptkeywordslists 2 points Question 26 When does python limit access to global objects from within a scope?
When there is the presence of a newly created local variable with the same name as a global variable.When there is the presence of a newly created local variable with a different name than the global variable.When there are no new variables.When there is the presence of any newly created variable. 2 points Question 27 Passes multiple values into a function for processing
Global variableCode blockReturnParameter list 2 points Question 28 There is no limit to the number of except blocks a program can have. True False 2 points Question 29 When we pass a variable into a function and then modify that variable inside of the function, it also modifies the variable outside of the function that we passed into the function. True False 2 points Question 30 def calcBMI(hgt, wgt); BMI = wgt * 703 / hgt ** 2 return BMIWhat is wrong with the above code syntax
(hgt, wgt) should be (hgt; wgt)The ; should be a :The ** should be a ^The function code block needs to be closed with enddef 2 points Question 31 The function that can be used to generate a list of index values, useful in controlling a for loop:
list()range()rand()str() 2 points Question 32 The function used to import python code and objects from other python files.
buildaddimportprint 2 points Question 33 An interpreter converts the entire source code into an executable. True False 2 points Question 34 Compilers and interpreters have the following in common:
Reads the source code into machine code, all at once.Translates machine code into byte code.Reads the course code one line at a time.Translates source code into machine code. 2 points Question 35 The _______ block is used to perform normal operations, but allow an exception to be thrown, thus ending the _______ block.
TryExceptThrowCatch 2 points Question 36 def setPhone(self, phone): self.phone = phoneThe above code is an...
Mutator methodAccessor methodGlobal functionExcept Function 2 points Question 37 What does this operator mean <=
EqualApproximatelyGreater than or equal toLess than or equal to 2 points Question 38 Write a 4 element Python dictionary object that contains four colors as the names and their values as examples of something that is that color. Example: “red”: “apple”
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Content EditorUse arrow keys to select functionsPath: Words:0
2 points Question 39 Write a Python class definition for an Employee object that contains the following elements:Attributes:idnamewagedepartmentMethods:Initializer which sets ID, name, and wageSet NameSet DepartmentGet IdGet NameGet WageGet Department
For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). Content EditorUse arrow keys to select functionsPath: Words:0
2 points Question 40 In Python, all exceptions must be instances of a class that derives from BaseException. True False 2 points Question 41 Attributes are to variables, as methods are to ______________.
declarationsobjectsfunctionsexceptions 2 points Question 42 Programming method of solving a problem by solving a smaller version of the same problem, repeatedly
RepetitionProblem SolvingDebuggingRecursion 2 points Question 43 Function used to close a file once the program is done with that file.
end()close()finish()detach() 2 points Question 44 The len() function accepts an object and returns:
the object’s size in kilobytes.the number of elements in the object.part of the object.number of parameters in the object 2 points Question 45 _____ are part of the UML and is used to illustrate how your program’s functions will relate and support your organization’s various functions.
FlowchartsUse case diagramsClass diagramsCommunication diagrams 2 points Question 46 Comments in Python begin with:
///>*# 2 points Question 47 A UML diagram used to examine the various states that any objects will go through at various points in time
State machine diagramsUse case diagramsCommunication diagramsObject diagrams 2 points Question 48 The simplest way to produce output is using the _____ statement
GetTryPrintUse 2 points Question 49 Separates the keys when defining the contents of a dictionary.
({:[ 2 points Question 50 Statement used to delete a dictionary element
removedeleraseterminate 2 points Question 51 Which of the following is NOT a number type supported by python
charintlongfloat 2 points Question 52 What is the output of the following Python code:SIZE = 10numbers = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0]index = 0while index < SIZE: numbers[index] = index * 10 index = index + 1while index > 0: index = index - 1 print(numbers[index])
CS 520 UNH Exception Handling for C Programs on The Intel 64 Architecture Lab Report
The goal of this lab is for your exception handling support specified in Program 4 for
a C program to be able to specify ...
CS 520 UNH Exception Handling for C Programs on The Intel 64 Architecture Lab Report
The goal of this lab is for your exception handling support specified in Program 4 for
a C program to be able to specify a single exception handler (multiple/nested
exception handling will not be tested). Test cases will not include any error handling.
California University of Management and Sciences R Programming NLP Text Mining
Create bar charts showing the most common words that appear in The War of the Worlds with these four words (affect, denoun ...
California University of Management and Sciences R Programming NLP Text Mining
Create bar charts showing the most common words that appear in The War of the Worlds with these four words (affect, denounce, perish, soil) Show charts and your code with line by line comments. Create a network graph of words that show a .10 correlation of appearing together in the same section of The War of the Worlds. Comment your code line by line. Please add your commentary, in your own words, on what the graphs are showing. Related materials and code for references can be found here: https://www.tidytextmining.com/ngrams.htmlI need the rmd file so that I can execute the code on my mac and pdf of the output you executed. Always repeat the question you are answering. Thank you!
Earn money selling
your Study Documents