70.2K

Verified Solution

Link Copied!

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 _________

Answer & Explanation Solved by verified expert

See Answer