Question: My employee's IT department refuses to install R for me (claiming the open source version is a security risk) and I tried to create reports with Microsoft Access 2010.

I got stuck trying to create a query on a simple table of hospital wards (for the purpose of keeping track of a data collection exercise):

[![example table](https://i.stack.imgur.com/YQwKc.png)](https://i.stack.imgur.com/YQwKc.png)

I did not manage to allocate each ward a sample size that would be proportional to its bed capacity (third column above) as I was not able to refer to the sum of the elements in the "bedCapacity" column. With Excel, I would try something like this:

[![Excel table](https://i.stack.imgur.com/z2uYU.png)](https://i.stack.imgur.com/z2uYU.png)

Cell D2 in Excel contains `=INT(C2/SUM(C$2:C$6)*50)+1` and cells D3 to D6 according formulae.

Is there any way I can refer to the sum in the `bedCapacity` column in Access 2010? I tried creating a separate query that would sum up the the 'bedCapacity` column, however could not figure out how to refer to the value in that query.

I'm trying to use Access 2010 so I can create standardised reports for the data collectors on their progress (which is not easily possible with Excel 2010, as it requires too much manual manipulation - I tried pivot tables etc.).

Would be grateful for any insights.

Answer: 
**Amazon Simple Storage Service (S3)**

> 
> It allows you to store an infinite amount of data that can be accessed
> programmatically via different methods like REST API, SOAP, web
> interface, and more. It is an ideal storage option for videos, images
> and application data.
> 
> 
> 

Features:

* Fully managed
* Store in buckets
* Versioning
* Access control lists and bucket policies
* AES-256 bit encryption at rest
* Private by default

Best used for:

* Hosting entire static websites
* Static web content and media
* Store data for computation and large-scale analytics, like analyzing
financial transactions, clickstream analytics, and media transcoding
* Disaster recovery solutions for business continuity
* **Secure solution for backup & archival of sensitive data**

**Use encryption to protect your data:**
If your use case requires encryption during transmission, Amazon S3 supports the HTTPS protocol, which encrypts data in transit to and from Amazon S3. All AWS SDKs and AWS tools use HTTPS by default

**Restrict access to your S3 resources:**
By default, all S3 buckets are private and can be accessed only by users that are explicitly granted access. When using AWS, it's a best practice to restrict access to your resources to the people that absolutely need it, you can see in that [Doc](https://aws.amazon.com/premiumsupport/knowledge-center/secure-s3-resources/).
I would go with aws s3 for such a use case where I want to store this kind of information.

[Setting default server-side encryption behavior for Amazon S3 buckets](https://docs.aws.amazon.com/AmazonS3/latest/userguide/bucket-encryption.html). Depending on the type of setup and amount of money I am willing to spend, I would choose to go with [Customer Managed Key](https://docs.aws.amazon.com/kms/latest/developerguide/concepts.html) for encrypting the bucket.

Considering the I am going through all the security checks AWS recommends [How can I secure the files in my Amazon S3 bucket?](https://aws.amazon.com/premiumsupport/knowledge-center/secure-s3-resources/).

Enable replication, Versioning, Logging and maybe IP based access for all the good keeping.

S3 provides all kinds of bells and whistles for security in that case.