Credit Homework Database Questions

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW

Mr McGivern
Mr Carey
Mrs Smith
Mr Munro

There are some similarities between a database and a spreadsheet. Part of a database and part of a spreadsheet are shown.
A computed field in a database is similar to a formula in a spreadsheet.
Explain what is meant by a computed field. [KU] (2 points)

What part of the spreadsheet shown above holds the same information as a record in the database? [PS] (1 point)

What part of the spreadsheet shown above holds the same information as a field in the database? [PS] (1 point)

The formula (B2+C2) / 2 is in cell D2 of the spreadsheet. The formula is replicated to cell D3 and D4.
What would the formula be in cell D3 if relative referencing was used? [PS] (1 point)

What would the formula be in cell D3 if absolute referencing was used? [PS] (1 point)

Which type of referencing would give the correct answer? [PS] (1 point)

Basic Operations

Advanced Topics & Practice

Helpful Extras

Homework

Credit Homework Questions

Database Homework 6

Name:
Email: (optional)