Instructions

Create a Microsoft Access database with the table definitions as provided below.

Here is the list of tables and its definition:

CATEGORY
Column Name	Type	Size
CategoryID	Long Integer	-
CategoryName	Text	20
Description	Long Text	-
CUSTOMER
Column Name	Type	Size
CustomerID	Long Integer	-
CompanyName	Short Text	40
CustomerName	Short Text	30
CustomerTitle	Short Text	30
EmailAddr	Short Text	30
Address	Short Text	60
City	Short Text	15
Region	Short Text	15
PostalCode	Short Text	10
Country	Short Text	15
Phone	Short Text	24
Fax	Short Text	24
EMPLOYEE
Column Name	Type	Size
EmployeeID	Long Integer	-
LastName	Short Text	20
FirstName	Short Text	10
Title	Short Text	30
TitleOfCourtesy	Short Text	25
BirthDate	Date/Time	-
HireDate	Date/Time	-
Address	Short Text	60
City	Short Text	15
Region	Short Text	15
PostalCode	Short Text	10
Country	Short Text	15
HomePhone	Short Text	24
Extension	Short Text	4
Notes	Long Text	-
ReportsTo	Long Integer	-
EMPLOYEE_PHOTO
Column Name	Type	Size
EmployeeID	Long Integer	-
Photo	OLE Object	-
ORDER
Column Name	Type	Size
OrderID	Long Integer	-
CustomerID	Long Integer	-
EmployeeID	Long Integer	-
OrderDate	Date/Time	-
RequiredDate	Date/Time	-
ShippedDate	Date/Time	-
ShipVia	Long Integer	-
Freight	Currency	-
ShipName	Short Text	40
ShipAddress	Short Text	60
ShipCity	Short Text	15
ShipRegion	Short Text	15
ShipPostalCode	Short Text	10
ShipCountry	Short Text	15
ORDER_DETAIL
Column Name	Type	Size
OrderID	Long Integer	-
ProductID	Long Integer	-
UnitPrice	Currency	-
Quantity	Integer	-
Discount	Decimal	-
PRODUCT
Column Name	Type	Size
ProductID	Long Integer	-
ProductName	Short Text	40
SupplierID	Long Integer	-
CategoryID	Long Integer	-
QuantityPerUnit	Short Text	20
UnitPrice	Currency	-
UnitsInStock	Integer	-
UnitsOnOrder	Integer	-
ReorderLevel	Integer	-
Discontinued	Yes/No	-
PRODUCT_IMAGE
Column Name	Type	Size
ProductID	Long Integer	-
Image_Number	Integer	-
Photo	OLE Object	-
SHIPPER
Column Name	Type	Size
ShipperID	Long Integer	-
CompanyName	Short Text	40
Phone	Short Text	24
SUPPLIER
Column Name	Type	Size
SupplierID	Long Integer	-
CompanyName	Short Text	40
ContactName	Short Text	30
ContactTitle	Short Text	30
Address	Short Text	60
City	Short Text	15
Region	Short Text	15
PostalCode	Short Text	10
Country	Short Text	15
Phone	Short Text	24
Fax	Short Text	24
Website	Short Text	50