Chapter AE, Problem AE5.3

Explanation of Solution

a)

Double click on the file that is downloaded and it will appear as shown below:

After opening the file

Explanation of Solution

b)

The below are the steps to create new database:

• Click “File->New” and then choose on the option “Blank desktop database”.
• Provide the name of the database and click “Create”...

Explanation of Solution

c)

Import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

• A get external data-Excel spreadsheet dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Get external data dialog box

• Now Import Spreadsheet wizard get opened.

Import spreadsheet wizard

• Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”...

Explanation of Solution

d)

Import the spreadsheet into the database click on the “External Data” tab and click on “Excel”.

• A get external data-Excel spreadsheet dialog box gets opened, then click on the “Browse” button and choose the file that location where the file is available.

Get external data dialog box

• Now Import Spreadsheet wizard get opened.

Import spreadsheet wizard

• Now click on the “Next” button and click on the “First Row contains Column Heading” and click “Next”.

Import spreadsheet wizard

Explanation of Solution

e)

In the menu bar, click on “Database Tools” menu and click on “Relationships” button.

• A “show Table” dialog box appears, then clicks on the required table, then click “Add” and once after completing click the close button.

Screenshot of adding the table to establish relationship

Explanation of Solution

f)

In the create menu click on the “Form Wizard” button, a Form wizard dialog box appears click on the required table and add all the fields into it by clicking on “>>” button.

• Now all the fields of the table are being added into the form wizard.

Form Wizard

• Click on the next button and choose “by Employee” option and click on the “Next” button.

Form Wizard

• Again click on the “Next” button and name the form as required.

Form Wizard

Explanation of Solution

h)

To add the new item using form choose the Employee ID of “Michael Murphy” and click in the “*” button available and start adding the required data that are specified ...

Explanation of Solution

i)

Right click on the record that needs to be deleted and click “Delete Record” of the “Stan Larsen”...

Explanation of Solution

j)

In the create menu choose the report wizard, a report wizard dialog box gets opened now choose the required table and corresponding fields into the report wizard.

Report Wizard

• Now click on the “Next” button and choose the view which needs to be viewed as shown below:

Report Wizard

• Click “Next” and choose whether any grouping is required or not and click “Next” to avail any sorting order in which data needs to be displayed.

Report Wizard

• Click “Next” and choose the layout of the report:

Report Wizard