levo
Log inStart

The Development Project: Analysis and Design

Designing the queries and reports

  • 3 things to know
  • A2 Unit 2

Overview

Parameter query, calculated field in a query and difference between a detail line and a summary line.

What you need to know

Answer each one before you reveal it.

Your recallNot started
Key term

What is a parameter query?

Key term

What is the difference between a detail line and a summary line?

Key term

Design in words a report showing overdue library loans.

Questions from this subtopic

Each one with the model answer underneath.

  1. 1

    What must be specified when a query is designed?

    Model answer

    A query specification states the question it answers, which tables and fields it uses, the criteria that select the rows, the sort order, any calculated fields, and who runs it and when.

  2. 2

    Why is a query designed against a stated question?

    Model answer

    Starting from the question the client actually asks keeps the query to what is needed and makes it testable, because the result can be checked against the answer the client expects.

  3. 3

    What is a parameter query?

    Model answer

    A parameter query asks the user for a value when it runs and uses it as the criterion, so one design serves every case — one query returns the bookings for whichever date is entered rather than needing a query per date.

  4. 4

    Why is a parameter query better than a query per case?

    Model answer

    One query is maintained instead of many, the results are guaranteed consistent between cases, and a new value needs no development work at all.

  5. 5

    What is a calculated field in a query?

    Model answer

    A calculated field is one worked out from other fields when the query runs, such as a line total from quantity and unit price, so it is always correct and does not have to be stored and kept in step.

  6. 6

    What should a report specification state?

    Model answer

    A report specification states its title, who receives it and how often, the data it contains and where that data comes from, the grouping and sort order, the subtotals and totals, and its layout including headers and footers.

See the rest and revise

Other ways to work this

The same content, four other ways.

What is inside Levo

Six ways to work the same material.

1Closed book
2Open book
3Closed book

The 3-step method, run for you

Answer cold, learn it, then prove it stuck. Levo tracks the jump between your first attempt and your last.

Systems Analysis and Development Approaches
Design, Development and Testing
Implementation and System Security
Programming

Cram a whole paper in one sitting

Sort every topic into what you know and what you do not, then drill only the weak ones.

A check requires a value.
presencerangeformat

Blank Blitz makes facts automatic

Rapid timed gap-fills on the terms and numbers you need to recall without thinking.

ANormal data is 12, which should be accepted.
BBoundary data is 1 and 50, which should be accepted.
C0 and 51, just outside the limits, should be rejected.

Build It gets the exam shape right

Assemble a full-mark answer from its marking points, in the order an examiner wants them.

One byte is made up of 8 bits.
TrueFalse

Test It catches misconceptions

Spot the fault in a statement. The traps are the mistakes students actually make.

721941163128510

Brain Breaks between sessions

Short focus games to reset attention, so the next set lands better than the last.

Every question in The Development Project: Analysis and Design, on a schedule.

Attempt a question from memory, write the correct version, then attempt it again. Levo records the jump between your first attempt and your last, and brings each question back on the day you are due to forget it.

Start revising, £5 a monthSee how the method works

Or £46 a year, about £3.83 a month. Cancel anytime.