Create a database of your customers information This databas

Create a database of your customers\' information. This database should have at least 10 customers as number of records and each record must contain ID, First Name, Last Name, Street Address, City, State, Zip Code, Phone, and Email. Leave the ID number to be the primary key of this database. Set the size of Zip Code equal to 10 (with the format similar to 12345-6789), the size of Phone equal to 14 (with the format similar to (703) 111-2222), the size of State equal to 2 and uppercase letter, and the format of the email to be hyperlink.

Using the Form Wizard in Access, create a Form with all the fields in your address book. Select your choice of layout and style, if you are prompted

. Create a Query by using Query Wizard with First Name, Last Name, Phone, and Email. Sort this query by Last Name in “Ascending Order”.

Create a Report from the above Query by using the Report Wizard. Group the Report by the Last Name. Select your choice of layout and style, if you are prompted.

Solution

Open the visual Foxpro/Microsoft access -goto Tools menu,choose wizards and click database .

Create the table .

2.to access the forms choose wizardals and click form.

Select the fields using the databases and tables .choose firm style time txt buttons and click finish.

3.to create build query.create-other-query wizard.-new query-simple querywizard ok.

Now enter below query.

Let ur table name be Customers.

Select Customers.LastName,Customers.FirstName,Customers.Phone,Customers.Email from Customers order by Customers.LastName Ascending.

Or u can use the GUI to do ascending filtering etc