Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: MAKING QUERIES IN ACCESS
ASSIGNMENT 1: MAKING QUERIES IN ACCESS
In this assignment, you will design and run two queries.
EPS Query
Create a query named EPS that computes and shows earnings per share for each company in each year. Your
output should look like that in Figure 12-6, although the figure shows only the first few output records.
FIGURE 12-6
EPS query output
Note that EPS values are formatted for Currency. If this formatting does not happen automatically, go to
Design view, highlight the output column, select Properties in the drop-down menu, and then select Currency
Format.
PE Ratio Query
Create a query named PERatio that computes and shows the PE ratio for each company in each year. Your
output should look like that in Figure 12-7, although the figure shows only the first few output records.
FIGURE 12-7
PERatio query output
Note that ratios are formatted for zero decimal places. In Design view, highlight the output column and
select Properties in the drop-down menu. Select Standard Number as the Format and zero for Decimal Places.
When you finish the queries, save and close the Breweries.accdb file.
 
Search JabSto ::




Custom Search