Customers DataBase

In this project you will create a simple database application for a small business. The Database must contain the following objects:

• A Table holding customer information (name, address, etc)
• A Query that will return a list with all active customers full name and phone, sorted by last name.
• A Form for creating, reading, updating and deleting customer records
• A Report with the active customers
• A Report with customers info and credit limit grouped by city

Instructions

You can watch this video for complete instructions

1. Create a Database

Create a new Database and with the name customers-database

2. Create the Customers Table

Create a Table in Design View with the name Customers. This table with hold the customer information.

3. Create table fields

The Field Name and Field Type are listed below

Primary Key. The ID field is the primary key of the Table and must have the AutoValue option to YES.

4. Enter table data

Open the customers table and enter at least 10 records

5 Create the Query

Create a query named Active Customers that will display all the active customers. The required query parameters are shown below:

6 Create the Form

Create a Form named Customers using the Wizard. The form must display all fields from Customers table except the ID field. You can choose any of the predefined layouts. A form example is shown below.

7. Create the Reports

Using the Reports Wizard create two Reports:

• Active Customers. A report that will display the active customers. This report will have as data source the Active Customers Query
• Customers by City and Credit Limit. A report that will display customers First Name, Last Name and Credit Limit. The Report must be grouped by City and sorted by Credit Limit.

In the attached pdf files you can see examples of the reports.

8. Edit the reports (optional)

Add the company logo provided to the header of each report.

9. Save and submit

Save the database using the default odb format and Submit