Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert Libby, Patricia Libby, Daniel Short, George Kanaan, Maureen Sterling

7th Canadian Edition

1260065952, 978-1260065954

More Books

Students also viewed these Accounting questions

Question

\f

Answered: 1 week ago

Question

What do you think Katsoudas means by the phrase one size fits one?

Answered: 1 week ago

Question

How do you think GM should handle this decision and why?

Answered: 1 week ago