Practical. CIT125. Instructions PART ONE - Database & Table Creation Estimated Time to Complete: 20 minutes 20% 1. Create a new database. Name it as Quiz3_your_name. 2. Import an Excel spreadsheet called Members located on the Blackboard in Quiz3 folder into the database and call the new table Members_your_name. (4%) 3. Modify the table Members_your_name as following: (2% each) 1) Choose an appropriate data types and field sizes for each field. 2) Descriptions are optional. 3) Set a primary key using the correct field in this table. 4) Assign a default value of C to the Member Type field. 5) Update the table so the values for the number of employees may not be less than 50. 6) The expiration date may not be later than 12/31/2020. 7) Only G, S, B, and C are acceptable values for member type. 8) Default state is IL. PART TWO - Form & Report Creation Estimated Time to Complete: 10 minutes 10% 1. Create a Form based on the members table. Name it Your_Name Members_Data_Entry. (5% ) 2. Create a report showing, in this order: Member ID, Company, City, and State. It is a justified report, in formal style, printed landscape. Title the report Your_Name_Members_Listing. (5%) PART THREE - QUERIES Estimated Time to Complete: 50 minutes 70% (10% each) General Instructions: Read the directions carefully. Save each query as instructed. Use the Members table for all queries. Copy-and-Paste each query in the SQL view into a MS Word document called Quiz3_Your_Name_SQL. 1. The Director needs a membership list. Show all fields in a list of companies within member type. Save as Your Name Query 1. 2. The Director needs to know the average number of employees and the fewest number of employees for each membership type. Save as Your Name Query 2. 3. The Director needs to update a list of the members whose membership will expire on 3/31/2020 or sooner to the expiration date of 12/31/2020. Save as Your Name Query 3. 4. The director is sending a special bonus to the best clients. The best clients have membership type of G; however, the director will only send this bonus to companies who have more than 200 employees. Show the name, address, city, state, and zip of the companies that qualify. Save as Your Name Query 4. 5. The director is considering to open another branch to serve clients in Ashland and Angola. Create a new table called NewClients with the records from Ashland and Angola by running the Make-Table query. Save the query as Your Name Query 5. 6. The Director needs to know the total number of employees for all member cities. Save as Your Name Query 6. 7. Create a parameter query to see a member information by insert the member ID. Similar to this: Enter Parameter Value ? Enter please the Member ID OK Cancel 8. Submit the Quiz3_your_name database and the Quiz3_Your_Name_SQL document to the Blackboard in Quiz 3 Submission Button.
Answers
The instructions for creating a database, table, form, report, and queries in CIT125 include creating a new database with an imported Excel spreadsheet, modifying the table by choosing appropriate data types, creating a form and report based on the members table.
What are the instructions for creating a database, table, form, report, and queries in CIT125?The given instructions provide a hands-on practice on database and table creation, form and report creation, and querying using Microsoft Access.
The task requires the creation of a new database and importing an Excel spreadsheet into it, followed by modifying the table using appropriate data types, field sizes, primary key, default values, and constraints.
A form and a report need to be created based on the members' table. Several queries have to be designed to retrieve data based on specific criteria such as membership type, number of employees, expiration date, city, and member ID.
The queries need to be saved in a Word document. The final step involves submitting the database and the SQL document on the Blackboard.
The given task aims to enhance the database management skills of the learner and provide hands-on experience in Access.
Learn more about instructions
brainly.com/question/13278277
#SPJ11
Related Questions
Question: What Kinds Of Changes Do You Think We'll Need To Make So The App Will Be Well Received In Other Countries? You: Well, There Are Some Obvious Factors To Consider: Currency Variations And Selectlanguage Diversitymobile Computingnetwork Infrastructureforeign CompetitionItem 1 . However, Some Of The More Subtle Variations Will Affect Interface Design,
What kinds of changes do you think we'll need to make so the app will be well received in other countries?
You:
Well, there are some obvious factors to consider: currency variations and Selectlanguage diversitymobile computingnetwork infrastructureforeign competitionItem 1 . However, some of the more subtle variations will affect interface design, possible bandwidth limitations, and the overall feel of the user experience.
Answers
In order for the app to be well-received in other countries, there are several changes that will need to be made. These changes include:
1. Currency Variations: Different countries have different currencies, so the app will need to support multiple currencies. This will allow users in different countries to make purchases within the app without having to worry about currency conversion.2. Language Diversity: The app will need to support multiple languages so that users in different countries can use the app in their native language. This will require translating all the text within the app into multiple languages.3. Mobile Computing: The app will need to be optimized for mobile devices. This is because many users in other countries may not have access to desktop computers and will be using the app on their mobile devices.4. Network Infrastructure: The app will need to be able to work with different network infrastructures. This is because network speeds and data caps can vary widely between different countries.5. Foreign Competition: The app will need to be able to compete with other similar apps that are already popular in different countries. This may require some changes to the app's functionality and features.6. Interface Design: The app's interface will need to be designed to be intuitive and easy to use for users in different countries. This may require different layout and design choices based on cultural differences.7. Bandwidth Limitations: The app will need to be designed to work with limited bandwidth. This is because many users in other countries may have slower internet speeds than users in the US.8. User Experience: The app will need to provide a positive user experience. This may require different features and functionality based on cultural differences. These changes will need to be carefully considered and implemented in order to ensure that the app is well-received in other countries.
To know more about Language Diversity visit:-
https://brainly.com/question/29602436
#SPJ11
(25 POINTS)Which statement best reflects the importance of following safety guidelines?
Workplace injuries can result in losses to an organization’s profits.
OSHA responds to complaints of unsafe work environments, and can fine or take negligent employers to court.
Every year, thousands of people die as a result of workplace injuries.
Using equipment safely is faster and makes work more efficient.
Answers
Answer:
I think, Every year, thousands of people die as a result of workplace injuries.
Answer:
B
Explanation:
I need help 43 points and brainiest if you answer
Answers
Answer:
250
Explanation:
Is MOOC's potentially harmful to copyright? Why or why not ?
Answers
Answer:
Fair-use exceptions to traditional copyright protection face challenges as well, given a MOOC's potential for global reach. Nonetheless, fair use and MOOCs are not mutually exclusive ideas. MOOCs remain an experiment...
what is the example of HTML?
Answers
Answer:
For example, content could be structured within a set of paragraphs, a list of bulleted points, or using images and data table
in order to remove a slide from a presentation you should
Answers
Answer:
Right Click on the slide and press delete or the undo button if adding a slide was the last thing you did.
Explanation:
Have a splendiferous day!
Hope this helps!
Run a regression of Test scores (Testscr) on Teachers, Computers, percentage of English learners (el_pct), Average Income (avginc), and the percent qualifying for reduced-price lunch (meal_pct). a. If district avginc increases from $30,000$ to $40,000, how are test scores (Testscr) expected to change in the given school?
Answers
To estimate the expected change in test scores (Testscr) when the district average income (avginc) increases from $30,000 to $40,000, you would need the coefficient estimate for avginc from the regression model.
In a regression model, the coefficient estimate for avginc represents the expected change in test scores associated with a one-unit increase in average income, assuming all other variables are held constant.
So, if you have the coefficient estimate for avginc from the regression model, you can use it to calculate the expected change in test scores when avginc increases from $30,000 to $40,000.
For example, if the coefficient estimate for avginc is 0.05, it would mean that for every $1,000 increase in average income, test scores are expected to increase by 0.05 units (assuming all other variables are held constant).
To calculate the expected change in test scores when avginc increases from $30,000 to $40,000, you would calculate:
Change in test scores = Coefficient estimate for avginc * (New avginc - Old avginc)
Change in test scores = 0.05 * ($40,000 - $30,000)
Know more about regression:
https://brainly.com/question/32505018
what is a sandbox used for? group of answer choices to test malware in an isolated environment to clear infected files in the host system to perform static malware analysis to run new apps
Answers
Sandbox used for test malware in an isolated environment. Because it operates in a different system, sandboxing guards against malicious code from reaching an organization's vital infrastructure.
Additionally, it enables IT to examine dangerous code in a controlled environment in order to comprehend how it functions and to recognise malware attacks more quickly.
What is sandbox ?A sandbox is a security tool used in computer security to isolate running processes, typically to lessen the impact of system failures and/or the spread of software vulnerabilities.
Sandboxing is a cybersecurity technique in which code is executed, observed, and analysed in a secure, isolated setting on a network that resembles end-user operating systems. Sandboxing is widely used to analyse untested or untrusted code and is intended to stop dangers from entering the network.
Sandboxes might be considered a particular instance of virtualization in the sense that they offer a highly regulated environment. Unverified programmes that might contain a virus or other harmful code are routinely tested using sandboxing, which prevents the software from damaging the host device.
To learn more about sandbox refer :
https://brainly.com/question/26424029
#SPJ4
Troy, an aspiring screenwriter, aspires to work with a famous director known for his philanthropic work. Troy gets an appointment with the director to present his idea for a video project. The director asks Troy to send him a synopsis of the video project. What should Troy include in the synopsis?
Answers
Troy should include a short overview of the story that his video will tell and why he wants to tell it (or what the video will be about and why). It should also include the target audience, and where the video will be published.
Answer: a brief description of the story
i hope i was able to answer your question
Explanation: passed the test with this answer
#PlatoUser
#PlatoStudentAnswers
What value is displayed as a result of executing the code segment?
Answers
Answer:
A: 3
Explanation:
The MOD operator is used to calculate the remainder of dividing two numbers, so by the end of this operation, we are adding the MODs of each integer in this list, because this program ends once each integer in list has gone through the steps, and the result of calculating the MOD of each integer is then added back because of the third step. So it should look like this: (4 MOD 2) + (2 MOD 2)...(1 MOD 2) and the result of adding these values should then result in 3.
The value which is displayed as a result of executing the code segment is equal to: A. 3.
What is MOD?MOD is an abbreviation for modulo operation and it can be defined as a mathematical technique that is used in computer science to determine the remainder of an arithmetic operation such as the division of two numbers.
Based on the code segment, the value which is displayed as a result of executing the modulo operation would be equal to 3 at the end of the iteration or operation.
Read more on computer codes here: brainly.com/question/25619349
an individual can use a view to create reports, charts, and other objects that show database data. T/F
Answers
The creation of reports, charts, and other objects that display database data can be done using views, it is true.
What variety of views do DBMS have?Dynamic views and static views are the two categories of database views. Data from one or more tables can be included in dynamic views, which also include all of the selected table's columns by default.
Which sort of join combines all the data from one table with the matching data from the other?The results of a CROSS JOIN, sometimes referred to as a Cartesian JOIN, are all rows from one table crossed with all rows from the other table. In other words, every possible combination of rows from the connected tables can be found in the join table of a cross join.
To know more about database visit:-
https://brainly.com/question/30204950
#SPJ4
Using "Bird Dogs", when "PROSPECTING" for clients refers to:
You may mark only one answer
1. Free give-a-aways or add ons to your product or service.
2. Direct mail gimmicks.
3. Anyone who can help refer you to new leads.
4. Telemarketers or phone sales qualifiers.
5. Pyramid or multi-level chain letters.
Answers
"Bird Dogs" in the context of prospecting for clients refers to option 3: Anyone who can help refer you to new leads.
In the context of prospecting for clients, "Bird Dogs" are individuals or contacts who can help refer you to new leads or potential clients. They are people who have knowledge of your target market or have connections within the industry and can provide valuable referrals or introductions.
Bird Dogs act as scouts or intermediaries who help identify potential clients and facilitate the process of acquiring new leads. They can be individuals from various backgrounds, such as existing clients, business associates, industry experts, or even friends and family members. By leveraging their network and relationships, Bird Dogs can provide valuable information about potential clients and help expand your customer base.
Unlike options 1, 2, 4, and 5, which refer to different marketing tactics or strategies, the concept of Bird Dogs focuses on the idea of utilizing individuals who can act as referral sources and provide valuable leads for your business. Building relationships with Bird Dogs and encouraging them to refer potential clients can be an effective way to expand your client base and generate new business opportunities.
Learn more about marketing here: https://brainly.com/question/30699183
#SPJ11
Which textual evidence best supports the conclusion that the knights are intimidated by the visitor?.
Answers
There are ways to know text that support a conclusion. The textual evidence best supports the conclusion is that "So that many of the noble knights were afraid to answer, And all were struck by his voice and stayed stone still".
How do one support a conclusion?One can support a conclusion using;
Topic sentence. Here, one can rephrase the thesis statement.Supporting sentences. Here, one can make a summary or conclude the key points in the body of the passage and also explain how the ideas did fit.Closing sentence. Here, one can use the final words. One can connects them back to the introduction.Learn more about this passage from
https://brainly.com/question/24813043
What happens when you change just ONE character in your input string?
Answers
digital camcorders are similar to conventional camcorders. a. analog b. manual c. electronic d. binary
Answers
Digital camcorders are similar to electronic camcorders. The correct answer is option c.
What are digital camcorders?Digital camcorders are electronic devices that store videos and audio in a digital format. Digital camcorders are similar to electronic camcorders. Digital camcorders are devices that allow for the capture of still and moving images in digital form. It records videos on digital video tape or memory cards.
Electronic camcorders are recording devices that use solid-state memory or digital video tape to record video and audio data. They capture audio and video signals electronically, which are then stored in digital format. Some electronic camcorders have built-in hard drives, while others use removable media such as flash memory cards or tapes. Electronic camcorders are similar to digital camcorders since both utilize digital technology.
Learn more about Digital camcorders here: https://brainly.com/question/10944268
#SPJ11
What nomenclature will I use to denote the mass of a component in a given stream? Note: the T
2
symbol in the text editing options allows you to write a superscript. It has a down arrow to the right, click this and then select T
2
for subscript.
Answers
The mass of a component in a given stream is commonly represented as m[sub]2[/sub].
In the field of process engineering, it is common to use specific notations to represent different variables and parameters. When referring to the mass of a component in a given stream, the standard notation is to use the symbol m[sub]2[/sub]. The subscript "2" denotes the specific component being referred to within the stream.
This notation helps to distinguish and identify the mass of individual components in a system where multiple substances may be present. By utilizing this convention, engineers and researchers can accurately represent and analyze the mass flow rates and compositions of various components in a stream.
Learn more about m[sub]2[/sub]
brainly.com/question/33181571
#SPJ11
Which is true about caches/caching
1) Ram is never a cache
2) Exists only in CPUs as L1/L2/L3 cache
3) Increases performance of slow storage by using faster storage to store a copy of information
4) They are slow and large forms of storage
Answers
Caching refers to the process of temporarily storing data or files in a cache storage location so that they may be retrieved more quickly when accessed later.
This mechanism is used in computer systems to improve data processing and speed up the response times of frequently used data. The following are some of the characteristics of caches/caching: They are used to speed up access to data. They can exist at various levels, including memory caches, disk caches, and network caches.
They are used to reduce the load on the underlying storage system by storing frequently accessed data or information. Caches can be implemented in both hardware and software. RAM is a type of cache used in computer systems to temporarily store data and instructions that the processor will use frequently.
To know more about Caching visit:-
https://brainly.com/question/15873525
#SPJ11
When importing a comma-separated text file, what does Access create each time it encounters a comma? Select one: a. a new table b. a new record c. a new related table d. a new field
Answers
When importing a comma-separated text file, Access creates a new field each time it encounters a comma. Option a new record is the correct one.
This means that each value separated by a comma in the text file will be imported into a separate field in Access. Access also creates a new record for each row of data in the text file, meaning that each row will be imported as a separate record in the Access table. It is important to ensure that the structure of the text file matches the structure of the Access table to ensure accurate and complete data importation. Additionally, Access offers the option to specify the delimiter used in the text file, which can be a comma, tab, or another character, allowing for flexibility in importing different types of text files.
To know more about data importation visit:
https://brainly.com/question/30092258
#SPJ11
10 effects that you can find in Audacity.
Answers
Answer: Distortion.
Echo.
Limiter.
Paulstretch (extreme stretch)
Phaser.
Reverb.
Reverse.
Truncate Silence.
etc
Explanation: this is it
the tips of robotic instruments contribute to the maneuverability of the instruments of the instruments in small spaces the movement oof the tips to perform right and left
Answers
The movement of robotic instrument tips enhances maneuverability in small spaces, allowing them to perform precise right and left motions.
How do the tips of robotic instruments contribute to maneuverability?Robotic instrument tips play a crucial role in enhancing the maneuverability of these instruments in small spaces. The design and functionality of the tips enable them to perform precise movements, including right and left motions, which are essential for navigating tight spaces and performing delicate tasks.
The tips are often equipped with specialized mechanisms that allow for controlled and accurate movements, enabling surgeons or operators to manipulate the instruments with precision.
This level of maneuverability is particularly beneficial in minimally invasive surgeries, where the instruments must traverse narrow incisions and reach specific areas of the body. The ability to perform precise right and left motions with robotic instrument tips enhances the surgeon's dexterity and improves the overall outcome of procedures.
Learn more about robotic
brainly.com/question/7966105
#SPJ11
which two statements regarding the use of subqueries are true? (choose two.) a. a subquery used with the in operator must return multiple rows. b. a subquery can be used in a create view statement, regardless of the number of rows it returns. c. a subquery can be used in the values clause of an insert statement if it returns more than one row. d. a subquery can be used in the set clause of an update statement, regardless of the number of rows it returns. e. a subquery used in an into clause of a select statement must return only one column but can return multiple rows. f. a subquery cannot be used in the group by clause of a select statement.
Answers
There are two statements regarding the use of subqueries that are true a. a subquery used with the IN operator must return multiple rows and c. a subquery can be used in the values clause of an insert statement if it returns more than one row.
A subquery is a query that is nested within another query. It can be used in the SELECT, INSERT, UPDATE, and DELETE statements to help in retrieving or modifying data. Subqueries are mainly used to retrieve data from tables by comparing them with the data present in another table. They are also used to update, delete or insert into tables using another table's data.
There are six types of subqueries: Single-row subquery, Multiple-row subquery, Multiple-column subquery, Correlated subquery, Nested subquery, Co-related subquery. Example of subqueries: SELECT ProductName, UnitPriceFROM ProductsWHERE UnitPrice > (SELECT AVG(UnitPrice) FROM Products)ORDER BY ProductName; This query selects the ProductName and UnitPrice from the Products table for products whose UnitPrice is greater than the average UnitPrice. Therefore options A and C are correct.
Know more about Subquery here :
https://brainly.com/question/29522983
#SPJ11
What is the Army training Network?
Answers
The Army Training Network (ATN) is a secure, web-based portal that provides access to training and education resources. It is the Army’s primary delivery platform for training and training management: doctrine, tools, products, and services.
what are computer networks
Answers
Answer:
A computer network is a set of computers sharing resources located on or provided by network nodes. A computer network is a system that connects numerous independent computers in order to share information (data) and resources.
Explanation:
:)
Play to end-
Back to beginning
Answer the following questions about representing repetition algorithmically with programming
1) In order for a repetition to be reproduced unambiguously, what three attributes are needed to convey
the proper instructions?
2) How are these three attributes conveyed in the music notation above?
3) Find and record a set of instructions containing a repetition clause (eg, instructions on a shampoo
bottle, a recipe, etc.). How are these attributes conveyed there? If any are missing, how would the reader
infer them?
Answers
There must be a starting point, a point where the code ends, and it restarts back to the beginning.
2) How are these three attributes conveyed in the music notation above?
The starting point is the beginning of the phrase, the point of where it gets sent back is the is represented by the colon symbol at the end, and thus it starts again at the beginning of the phrase.
3) Find and record a set of instructions containing a repetition clause (e.g., instructions on a shampoo bottle, a recipe, etc.). How are these attributes conveyed there? If any are missing, how would the reader infer them?
How to download the McDelivery app from a McDonalds bag
- Download the uber eats app
- Select “McDonald’s”
- Order your favorite foods
In this set of instructions, it has a start where you download or open up the uber eats app, selecting the “McDonalds” option for delivery is part of the start or the middle part, and the point of repetition where the instructions can be a repeated is the ordering the food. It would’ve just been in a constant loop afterwards because the first two instructions have already been pre-completed.
hope this helps :)
Carlos wants to give a presentation to his staff with Present Online. What are the best ways for him to share the presentation using this option? Check all that apply.
Attach the presentation to an email.
Copy and paste the link to social media.
Copy and paste the link in a text message.
Send a link to the presentation in an email.
Email the file in the form of a Word document.
Send it as a PDF file through a Microsoft account.
Send a shortened link of the presentation in an email.
Answers
Answer:
2,3,4,7
Explanation:
edge
...............is a personal computer that fits on desk.
Answers
Answer:
desktop computer
Explanation:
New product ideas must fit into a company's mission statement and?
Answers
Answer:
Please give a better question :D
Explanation:
I don't understand your statement, below is a statement I wrote..?
_______
"The matching process of developing and maintaining a strategic fit between the organization's goals and capabilities and its changing marketing opportunities"
How to Find Length of List in Python?
Answers
The built-in len() method can be used to determine a list's length. The number of elements present in the sequence or collection is returned by the len() method, which takes a sequence or collection as a parameter.
What is the main use of Python?Python is essentially used frequently to create websites and applications, automate tasks, analyze data, and visualize data. Its design philosophy emphasizes code readability through the use of excessive indentation. Python has features like garbage collection and dynamic typing. It supports a variety of programming paradigms, including structured, functional, and object-oriented programming.
Because Python is comparatively easy to learn and can be used for a lot of typical tasks like handling finances, many non-programmers, including accountants and scientists, have adopted it. Python is one example of a high-level, general-purpose programming language.
To learn more about Python, visit:
https://brainly.com/question/30427047
#SPJ4
which of these steps comes first in the boot process
Answers
Answer:
Missing Reference
Explanation:
Where do you enter characters for a simple search?
Choose the answer.
Navigation Pane
Replace dialog box
Clipboard
Find Pane
Answers
Navigation Pane