Question
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,
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started