Question
Microsoft Access Module 1 OKAY, its Practice Time! The following exercise is a test to make sure that you understand and have absorbed the key
Microsoft Access Module 1 OKAY, its Practice Time! The following exercise is a test to make sure that you understand and have absorbed the key points we have learned so far. Please read the entire assignment before you try it.
Open the Assignment1.accdb file
We need a table named Checkbook to record the checks and deposits from the company checkbook See the attached list of checks and deposits to be recorded Record the kind of information youd want to look up later. Set data types, field widths, etc. o The primary Key will be the check/deposit# o Suggestion: Enter deposit amounts as positive numbers, enter check-amounts as negative numbers. That way, you can add a total row that shows the current balance
Deposit #: _D001___ Date: _11/25/2021__ Amount Deposited: $_4120.25_____
Check # __C1004__ Date _1/4/2021___ To: __Rachel Green____ Amount: $_1969.00____ Amount (in words) __Nineteen hundred sixty nine_______
Memo: ___Cephalopod planted bed__________
Deposit #: __D002___ Date: _1/12/2021__ Amount Deposited: $__5042.33__
Check # __C1005_ Date __1/14/2021___ To: __Ross Geller___ Amount: $_1977.00___ Amount (in words) __Nineteen hundred seventy-seven ______
Memo: __Surveillance of investigators__________
Check # __C1006__ Date _2/5/2021___ To: ___Joey Tribbiani ____ Amount: $__1974.00____ Amount (in words) __Nineteen hundred Seventy four exactly____
Memo: __ Exterminating empress____________
Deposit #: _D003___ Date: _2/20/2012__ Amount Deposited: $__6734.55__
Check # __C1007__ Date __3/1/2021__ To: __Monica Geller ____ Amount: $__1979.00___ Amount (in words) __Nineteen Hundred Seventy Nine exactly___
Memo: _____Glass-encased communiqu _________
Check # __C1008__ Date __3/18/2021___ To: __Chandler Bing___ Amount: $__1965.00____ Amount (in words) __Nineteen Hundred Sixty-five exactly____
Memo: ___Tumbling boulder facsimile _________
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