[AccessD] Video Rental DB

[James Button]

I was learnt -  by experience:
You need to be able to show enough consideration of legal needs to the 'gvmnt'
people who call on you - that they will accept you are trying to be open and
honest.
You need to have records of problems - and identify the source of those problems
You need to identify, at an early stage, what, within your business is costing
you -
But remember that loss leaders, providing there is not too much loss, may be
worth presenting, but they have to bring in covering profits on other items sold
at the same time
Also they should not just get taken as freebies by your usual customers who
would have brought you profit anyhow, and will be annoyed at seeing others get
goodies they enabled you to give away.
So - if the "Disney goes Dallas" DVD brings in customers, who also hire/buy
other profitable stuff and you can get  "Disney goes Dallas" stickers in bulk &
cheap - well maybe that's something to consider as a freebie for customers
taking 5 other - profitable items.

My lernt viewpoint - if you are going to put effort into a computer system -
then have the basic infrastructure within the facility - 
And just because it can record 'stuff' you don't have to actually have the front
end to require that 'stuff' be entered
Access being a good vehicle for prototyping - and form design - although you may
want to look at a facility designed for creating web based applications.   

Also - maybe consider a process to put data into Excel for analysis - if you
load excel 'tables' with data from the Access datastore - you can manipulate it
using the excel functions, VBA - and even SQL 


But - whatever - do, within the design and setup,  consider the systems openness
to corruption and loss of data caused by ongoing problem areas such as wireless
connection dropout.
A computer system is pointless if you cannot rely on the data being correct when
it's Analysed and summarised. 

JimB
 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David
McAfee
Sent: Saturday, July 2, 2016 4:41 AM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Video Rental DB

This just made my head hurt :D

Tax inspectors? Courts? :O
On Jul 1, 2016 1:55 PM, "James Button" <jamesbutton at blueyonder.co.uk> wrote:

> Swift assessment of the needs  - guesswork -
> Stock item - code, title, media type, Discs in set , booklet, loan
> limitations -
> as in content type,  current reported condition, date purchased, source,
> Brand,
> cost, depreciation anticipated each year, depreciation to-date, date
> written-off
> from stock
> Customer - Account,  name, address, phone - home mobile, email, payment
> method
> and payment account - bank account (reference - and confirmation of id
> address),
> id validation presented - type and reference - social services -
> government id,
> guarantor, registered date, last borrowing date, number of borrowings  -
> problems level marker - scuffed, returned as damaged, damage admitted at
> return,
> Damage found at return, incomplete at return, payment problems - etc...
> and a
> freeform text comment area 2000 characters (warning to staff on the form
> about
> libellous entries and the possibility of them being required to justify
> their
> entries at court.)
>
> Borrowing entry - Customer account, date,  Invoice number, Billed amount,
> Excess
> charge, Paid amount , closed entry - all returned, or excess paid
> Invoice entry line - invoice number, stock code,  date out, expected loan
> duration, returned OK marker
> If not returned OK - then there will be a 'line-item problem report'
> As in customer, invoice, stock code, excess charge, Problem customer
> grading,
> and commentary entry
>
> So you can monitor the profitability of each item you bought - and maybe
> still
> have.
> You can monitor customers for frequent damage, complaints
> You can monitor customer business - at a gross level, and using invoices
> at a
> very specific level
> You can easily generate summary reports of the business's processing during
> whatever period you consider appropriate.
>
>
> So - considerations
> Security and backup -  practical day-by-day, to put on a new system when
> the
> store gets robbed, Auditors, tax inspectors, and courts
> Access recording - I haven't included anything to do with who made the
> entries -
> that would imply individual access and logons - maybe bar-code card or
> proximity
> tag/card readers - and that would imply a log of every action made in the
> database.
> Going to use views and access permissions by user
> Going to use imbedded VBA to validate and process form entry onto the data
> tables
> Back-end and multiple front-end PC's (tablets?) encryption for  connections
> between the back end and front-end devices - Access run-time?
> What will you be using as a database management facility when you have
> finished
> the prototyping and development
> And - backup and recovery to address corruption of the database - Ah! Yes
> wireless input ! - maybe create flat file input sets to be passed from the
> input
> form presentation  devices back to the data store - so all updates are
> done as
> processing input transaction set files.
>
> JimB
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com