Anyone with Visual Basic experience? I could use your expertise, please. Thanks.
ID: 3710890 • Letter: A
Question
Anyone with Visual Basic experience? I could use your expertise, please. Thanks.
Instructions:
Start Windows Application
*Create Structure* - Stores the data for a customer account
-------------------------------------------------------------------------------------
Last Name
First Name
Customer Number
Address
City
State
ZIP Code
Telephone Number
Account Balance
Date of Last Payment
------------------------------------------
User should have access to save the customer account records to the file.
User should be able to search the file for a customer by last name or customer number.
User should be able to print a report displaying all of the customer records in the file.
Include the following:
A Menu system that includes File, submenus (open, print, exit); Edit, submenus (Add new record); Search, submenus (By Customer Number, By Last Name); and About (brief description of your program purpose).
A GroupBox named "Account Information." In the GroupBox, include a label "Enter Customer Account Information" and the controls in Figure 9-29 on page 592 of your textbook. Outside the GroupBox, include another button "Next Record" to cycle through records saved.
Multiple forms (Main form and second form to add new customers). As an example, second form could be named AddForm.
A module
A structure to store the customer data
Coded instructions to print a formatted report with report header. Note: Use a monospaced font such as Courier New to avoid issues with aligning data in columns.
Exception handling (no entry left blank and account balance is numeric and not negative)
Flowchart
Use decision statements (If...Then ..., a Select Case Statement, For... Next loop, etc.)
Explanation / Answer
SELECT
Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,
Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;
QUERYING THE DATABASE: QUERIES and VIEWS
Query: Statement that allows data retrieval
View: A virtual table; a saved query (the SELECT statement, not the result)
SELECT statement (DML)
- retrieves a limited set of data from one or more tables using criteria specified in the WHERE clause
- often used to perform calculations on the data selected
- the result set is displayed as a table (columns and rows)
Single-table example (review):
Current Product List: all data comes from the Products table
SYNTAX
SELECT column list
FROM tablename
WHERE criteria
ORDER BY column list
JOIN OPERATOR
The JOIN operator specifies how to relate tables in the query. The JOIN operator is one of the set operations available in relational databases.
The following join types of join are available in most relational databases:
INNER
OUTER (LEFT. RIGHT, FULL)
CROSS
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.