Transcription of Simple Invoicing Desktop Database with MS Access 2013/2016
{{id}} {{{paragraph}}}
Simple Invoicing Desktop Database with MS Access 2013/2016 David W. GerbingSchool of Business AdministrationPortland State UniversityJuly 7, 2018 CONTENTS1 Contents1 Create a New Database12 Customer and Product Customer Table .. the Customer Table .. the Changes .. Key .. Type .. Fields .. Remaining Customer Fields .. Customer Data .. Customer Data .. Product Table .. Table .. Fields and Primary Key .. Description and Price Fields .. Products .. Product Data ..63 Database Order and OrderLine Tables .. the Order table .. the Order Table Foreign key .. and Close the Order Table .. the OrderLine Table and Fields.
column, the Field Name column, and enter the name of the eld. The Customer table should contain the following elds in addition to the Customer ID: FirstName, LastName, Addr, City, State, and Zip. To add the FirstName eld, just enter in the name of the eld and accept the default Data Type of Short Text. c 2016 David W. GerbingJuly 7, 2018
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}