SECTION B - Microsoft Access

Answer 1 question only

Question 4

The table named "staffinfo" has the following structure:

\begin{tabular}{|c|c|c|}
\hline Field name & Data type & Description \\
\hline Sid & Autonumber & Staff identification number \\
\hline Department & Text & Department (e.g., teller dept., administration dept., store dept., maintenance dept., marketing dept.) \\
\hline Sname & Text & Staff name \\
\hline Address & Text & Address of staff \\
\hline Sphone & Text & Staff phone \\
\hline Post & Text & Post (e.g., junior teller, cashier, accountant, manager) \\
\hline Dol & Date/time & Date of joining \\
\hline Sdob & Date/time & Staff date of birth \\
\hline
\end{tabular}

b. Create a form on the basis of the "staffinfo" table and save it as "entryform".

c. Fill in at least 5 records using the "entryform".

d. Create a query named "depinfo" to display records including department name, staff name, and mobile number.

e. Create a query named "post" to display staff name, post, department, and phone number where the post is "teller" or "cashier".

f. Prepare a report based on the query named "depinfo".