Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: MAKING QUERIES IN ACCESS
Some players are in the starting lineup almost every day, and they accumulate hundreds of plate
appearances in a season. Other players only appear in games when the starters need a rest. Player data is included
in a table only if the player had at least 10 plate appearances in each of the past two seasons.
A database file is available for you to use with the following assignments. To get the file, go to your data
files, select Case 11, and then select BaseballAnalysis.accdb.
ASSIGNMENT 1: MAKING QUERIES IN ACCESS
In this assignment, you will design and run two queries.
ThisYearsData Query
Create a query named ThisYearsData that computes and shows performance measures for all players who had
100 or more plate appearances this year. Your output should look like that in Figure 11-3; only the first few
output records are shown.
FIGURE 11-3
ThisYearsData query output
The following output values are defined specifically for this query:
￿
Total Bases
s hits. A single is one
base, a double is two bases, a triple is three bases, and a home run counts for four bases.
This value is the number of bases accumulated by the player
￿
Batting Average
This value is the ratio of the player
s hits to at-bats.
￿
Slugging Percentage
s total bases to at-bats. If two players
have the same number of hits and at-bats, they will have the same batting average. However, a
player who has more doubles, triples, and home runs will have a higher slugging percentage than
a singles hitter.
This value is the ratio of the player
￿
OPS
This value is the sum of the player
s slugging percentage and on-base percentage. OPS is a
combined measure of a player
s ability to get on base and hit for power.
￿
OnBasePercentage
s hits plus walks divided by at-bats plus walks; it
shows how frequently the player reached base.
This value is the player
Note that ratios are formatted for three decimal places. In Design view, highlight the output column and
select Properties from the drop-down menu. Select Standard Format and 3 Decimals.
LastYearsData Query
Create a query named LastYearsData that computes and shows performance measures for all players who had
100 or more plate appearances last year. Your output should look like that in Figure 11-4; only the first few
output records are shown.
FIGURE 11-4
LastYearsData query output
s age this year. Other output values are
calculated in the same way as the values in the ThisYearsData query.
When you finish the queries, save and close the BaseballAnalysis.accdb file.
Note that Age Last Year is one year less than the player
 
Search JabSto ::




Custom Search