A parameter query can be easily written. First, a select query is developed. Then it is opened in design view. There appear different rows pertaining to a specific field. In the Criteria row, that text is added which a person wants to show in the parameter pack (Microsoft. n.d.). This text is surrounded by square brackets. I will use the name of the dieter to check the record for weekly workout and nutrition. I will use parameter query because it permits to employ the similar query again and again without involving the need for persistently opening it in design view and changing the text in criteria row (Microsoft. n.d.).
The second query that I will create is select query. This kind of query can be developed in design view or in query wizard. The fundamental steps followed by the two techniques are identical to each other (Microsoft. n.d.). To develop a select query those tables are chosen that act as means of information and then, those fields are specified that a person want to take from data places. For instance, I will choose the name, foot intake and duration of the workouts. I will use select query because it assists in gathering data from different data places.
The third query that I will develop is update query. Firstly, a select query is developed to recognize the records that a person desires to update. Later, this query is changed to an update query. By choosing the data at the start, it is validated that the records are updated prior to any alterations in data. I will develop this query because it helps in updating the desired data in a feasible way. For example, for updating the BMI I will use an update query.
Access helps in tracing, showing and handling huge quantities of data. Access is a well-organized method to contrast the information in worksheets (Taylor, n.d.). Access database can keep the data separately for each item. Access offer usage of reports and queries and additional records can be added for free. It saves the data at one location and mentions about it at several locations (Chung, n.d.). Therefore, I believe that it would be finer to use Access as compared to the Excel.
Microsoft. (n.d.). Use parameters to ask for input when running a query. Retrieved from: https://support.office.com/en-us/article/use-parameters-to-ask-for-input-when-running-a-query-c2806d3d-d500-45a8-8507-ec6af351b6ed
Microsoft. (n.d.). Create a simple select query. Retrieved from: https://support.office.com/en-us/article/create-a-simple-select-query-de8b1c8d-14e9-4b25-8e22-70888d54de59
Microsoft. (n.d.). Create and run update query. Retrieved from: https://support.office.com/en-us/article/create-and-run-an-update-query-9dddc97c-f17d-43f4-a729-35e5ee1e0514
Taylor, H. (n.d.). How to compare excel spreadsheets in access. Retrieved from: https://itstillworks.com/compare-excel-spreadsheets-access-7156160.html
Chung, L. (n.d.). Microsoft Access vs. Microsoft Excel for data analysis and reporting. Retrieved from: http://www.fmsinc.com/microsoftaccess/dataanalysis/versus-excel.html
1
Workout Database Query Week 2
Hello everyone
, t
he first query that I will create
is parameter query.
A point of reference can be
utilized in parameter query to limit the deposit of records which are given back by the query.
A parameter query can be easily written. First, a select query is developed. Then it
is opened
in
design view.
There
appear different rows per
taining to a specific field.
In the Criteria row, that
text is added which a person wants to show in the parameter
pack
(Microsoft. n.d.).
This
text is
surrounded
by square brackets.
I will use the name of the dieter to check the record for weekly
workout and nutrition.
I will use parameter query because it permits to employ the similar
query
again and
again
without
involving the need for
persistently
opening it in design view and
changing the text in criteria row
(Microsoft. n.d.)
.
The second
query that I will create is select query.
This kind of query can be developed in design
view or in query wizard.
The fundamen
tal steps followed by the two techniques are identical to
each other
(
Microsoft. n.d.)
.
To develop a select query those tables are chosen that act as means
of information and then, those fields are specified that a person want to take from data places.
For
instance, I
will choose the name, foot intake and duration of the workouts.
I will use select
query because it assists in gathering data from different data places.
The third query that I will develop is update query.
Firstly, a select query is developed to
recognize the records that a person
desires
to update.
Later, this query is changed to an update
query.
By choosing the data at the start, it is validated that the records are updated prior to any
alterations in dat
a.
I will develop this query because it helps in updating the desired data in a
feasible way.
For example, for updating the BMI I will use an update query.
Access
helps in tracing, showing and handling huge quantities of
data
.
Access is a well
-
organized m
ethod to contrast the information in worksheets
(Taylor, n.d.)
.
Access database can
1
Workout Database Query Week 2
Hello everyone, the first query that I will create is parameter query. A point of reference can be
utilized in parameter query to limit the deposit of records which are given back by the query.
A parameter query can be easily written. First, a select query is developed. Then it is opened in
design view. There appear different rows pertaining to a specific field. In the Criteria row, that
text is added which a person wants to show in the parameter pack (Microsoft. n.d.). This text is
surrounded by square brackets. I will use the name of the dieter to check the record for weekly
workout and nutrition. I will use parameter query because it permits to employ the similar query
again and again without involving the need for persistently opening it in design view and
changing the text in criteria row (Microsoft. n.d.).
The second query that I will create is select query. This kind of query can be developed in design
view or in query wizard. The fundamental steps followed by the two techniques are identical to
each other (Microsoft. n.d.). To develop a select query those tables are chosen that act as means
of information and then, those fields are specified that a person want to take from data places.
For instance, I will choose the name, foot intake and duration of the workouts. I will use select
query because it assists in gathering data from different data places.
The third query that I will develop is update query. Firstly, a select query is developed to
recognize the records that a person desires to update. Later, this query is changed to an update
query. By choosing the data at the start, it is validated that the records are updated prior to any
alterations in data. I will develop this query because it helps in updating the desired data in a
feasible way. For example, for updating the BMI I will use an update query.
Access helps in tracing, showing and handling huge quantities of data. Access is a well-
organized method to contrast the information in worksheets (Taylor, n.d.). Access database can
Solomon Kane
Week2Discussion-DatabaseQueriessubmitted.docx
0
