Microsoft Access Simple Book Library Database 1/4

Опубликовано: 13 Июль 2026
на канале: Candidomx

41,298

414

Help me reach 1000 subscribers to upload the 4th part.

You will need to build the following tables: Books, Authors, Customers, Checkout, CheckoutDetail.

Books:
BookID (Autonumber)*
AuthorID (Number)
BookName (Short Text)
BookPrice (Currency)
BookEdition (Number)
ISBN (Number)

Authors:
AuthorID (Number)*
AuthorFirst (Short Text)
AuthorLast (Short Text)

Customer:
CustomerID (Number)*
CLastName (Short Text)
CFirstName (Short Text)
CStreeet (Short Text)
CCity (Short Text)
CZipcode (Short Text)
CPhone (Short Text)
CEmail (Short Text)

Checkout
CheckoutID (Number)*
Customer ID (Number)
CheckoutDate (Date/Time)
ReturnDate (Date/Time)

DetailCheckout
CheckoutID (Number)**
DetailCheckoutID (Number)**
BookID (Number)

Primary Key
** Composite Primary Key