Recent orders
Personal Insurance, Inc.
right
-580505
Shelly Cashman Access 2019 | Module 2: SAM Project 1a
0
Shelly Cashman Access 2019 | Module 2: SAM Project 1a
Personal Insurance, Inc.
Creating Queries
3875
16510
0
0
GETTING STARTED
Open the file
SC_AC19_2a_
FirstLastName
_1.accdb
, available for download from the SAM website.
Save the file as
SC_AC19_2a_
FirstLastName
_2.accdb
by changing the “1” to a “2”.
If you do not see the
.accdb
file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
Support_AC19_2a_UmbrellaData.xlsx
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 STEP
S
Personal Insurance, Inc. is a national company that insures homeowners and renters. It also offers umbrella policies that provide additional coverage. As a regional manager, you need to be able to query the database to help make decisions and to answer questions from other employees.
Create a query based on the
Customers
table in Query Design View with the following options:
Add the
CustomerID
,
FirstName
,
LastName
, and
DateOfBirth
fields to the design grid in that order.
Sort
the records in
ascending
order by
LastName
.
Save the query using
CustomerLastNameSorted
as the name.
Open the query in Datasheet View, then close it, saving if necessary.
Open the
HomeownersPremium
query in Design View and make the following changes to the query:
Delete
the
CustomerID
column from the design grid.
Add criteria to select only those records where the
Premium
field value is
greater than
2,000
.
Save the changes to the
HomeownersPremium
query.
Open the query in Datasheet View, then close it, saving if necessary.
Open the
LiabilityOrProperty
query in Design View and add criteria to select only those records where the
Liability
field values
equal
75,000
or
the
PersonalProperty
field values
equal
75,000
. Save the changes to the query. Open the query in Datasheet View, confirm that 3 records appear in the
LiabilityOrProperty
query results, then close the query, saving if necessary.
Open the
ComparisonBirth
query in Design View and make the following changes to the query:
Add
the
FirstName
field to the query design grid. The
FirstName
field should immediately follow the
CustomerID
field.
Add criteria to select only those records where the
DateOfBirth
field value is
less than 1/1/1950
.
Set the format to
Medium Date
for the
DateOfBirth
field.
Set the caption to
BirthDate
for the
DateOfBirth
field.
Save the changes to the
ComparisonBirth
query.
Open the query in Datasheet View, confirm that the results match Figure 1, then close it, saving if necessary.
Figure 1: ComparisonBirth query results
Personal Freedom and Mask Mandate
Student’s name
Professor
Course
Date
Personal Freedom and Mask Mandate
John Stuart Mill suggests that personal freedom is very important in any society, however, this personal freedom must always go hand in hand with the desires and the will of the society. This is to means that personal freedom must never go above the general societal needs because society and the people around a person need to be respected and given their freedom as well. Therefore he asserts that if an action satisfies an individual then it is good. However, if it satisfies an individual and goes ahead to hurt those around the person then that act cannot be considered good. In light of his explanation, the mask mandate especially in the United States is a reflection of this since some people feel it is okay not to put on a mask.
However the question of the health of their neighbors and the people they walk along with comes into question and therefore there is a need for examination if the mask mandate is being applied for the protection of the general society or the individual. Upon determination of this, it is possible for a person to clearly understand what it means for them to put on their masks. Therefore this paper discusses the mask mandate in light of mills liberalism and individual liberty assertions (Mill, 02).
In his freedom mill states that there are boundaries to personal freedom and therefore this is seen to be a rule adopted by most of the governments in law making whereby personal freedom is never at any point allowed to conflict with the public interests. It is also upon this issue that the protection of societal values becomes more important than personal freedom and therefore through this most governments enact laws that forbid certain practices. For example, some states in the united states forbid the use of marijuana. Marijuana even though termed as a personal way of relaxing is seen as a negative force in society that can expand and be more and therefore it is upon this that this kind of law is made(Mill, 03). Sometimes as well the concerns about the government on the health of its individuals also override personal freedom and therefore in these cases the governments make decisions to protect the individuals and not to provide them with personal freedom.
This kind of decision has been witnessed over a long period of governance and most of the time they are seen as a way of making society better. In mills discussion whatever can harm the society even if okay at a personal level is not encouraged at any point. Masks mandate whereby a person is supposed to put on a mask to prevent them from transferring coronavirus to another person can be explained as going against personal freedom(Mill, 04). However, from Mill’s belief system this is not bad as it tries to keep society safe and make it better every day.
Mills two aspects of freedom especially with political power and control are first to make sure that the political leaders were not using their powers to mistreat their subjects. Secondly that it was important for some things to be decided upon by the general population or a larger group of representatives and not by an individual. This is the American system that can be seen as congress. Congress has the mandate to make most decisions that pertain to the united states and therefore its power and decisions are seen to pertain to what the people of America like and wish to happen.
Mills states that the warrant for which a person or a leader is allowed to act not accordingly or in line with societal needs is only when the needs of the society have to be protected and they are vested with the ability to make decisions at that particular point. In regards to mask mandate, this has been seen to happen in many countries over the world whereby being guided by health professional advises some presidents and heads of states have mandated that every person is to put on a mask. This, therefore, is seen as a way to protect the needs of society. However, in other countries, it is already a law that a person can only stay without a mask maybe at their homes and in public they have to put on masks otherwise there are consequences like being arrested. All these efforts are geared towards the protection of individuals as well as the general society.
During the period of the corona is evident that personal freedom has not been crossed over so many times while trying to protect the general public good. The issue of masks though not favoring everyone has been emphasized by so many people even apart from the government and therefore a person feels the inability to go to the public without it as they will feel awkward and feel like they are the wrong ones in such situations. Therefore even though it is true that masks are important there is also a need for personal involvement since some people are generally weak in their health and putting on masks may lead them to even worse medical conditions (Mill, 05).
In conclusion, mills personal freedom is of very great significance in our current society as it helps us to see the mask mandate from a different perspective of not just the promotion of social and societal good but also from the side of personal freedom and what mask mandate means for personal freedom as Miller puts it.
Works cited
Mill, John Stuart. “On liberty.” A selection of his works. Palgrave, London, 1966. 1-147.
Personal Essay
Personal Essay
Student’s Name
Institutional Affiliation
Professor’s Name
Date
Personal Essay
My personal experience, when I worked to enhance a community to which I feel connected, was during the COVID-19 pandemic. During this time many families were affected; some lost their loved ones, and others lost their jobs. Since schools were closed during the pandemic, I could see the turn of events and how people struggled to survive, which broke my heart. For safety precautions, my mother was asked to work from home, and thus we traveled to live in the village since we assumed it could be safer there, considering the place was less populated. Living in the village made me feel connected to the Hispanic community, a chance I never got while we lived in the city. Therefore, I worked hard to enhance my community by providing food to the less fortunate ones.
Since I did not have enough resources to cater to the needs of each individual in the community, I sought support from a charity organization in the city which offered me financial support. During this time, my mother supported me greatly, and I am thankful for everything she did for me. On Saturdays, I would do some shopping and then prepare food, which I packed into medium lunch boxes enough to feed one person. I would then take the food to the church within the community, where I could distribute it to people. Seeing the joy and happiness in people’s eyes as I gave them the lunch boxes gave me motivation and a reason to keep helping them.
My charity work touched my people, and several fortunate ones joined me in serving our community. This time we could raise more funds and do some shopping which we distributed on Wednesdays. Since many people had lost their jobs following the safety guidelines brought about by the pandemic, many could not provide food for their families. Our efforts in supplying them with shopping meant a lot to them, and it made me happy to see that they were not starving.
My efforts in serving this community are meaningful to me since I now understand how it feels to help someone in need. Besides, interacting with people from this community helped me learn Spanish. My friends volunteered and assisted me in learning Spanish so that I could easily communicate with the people I was helping. Learning Spanish during the pandemic has been helpful in my Spanish classes. In addition, my effort in serving this community is meaningful because some families blessed me with Rosaries, which I treasure, as it was an honor to receive them.