job description questions

[lezawang]

Hi

Sorry if this off topics. I am reading the job description below. I would appreciate if you can answer my questions just to get an idea what is the requirement and where I am at.


1) Validate MS Access databases to align with current excel model

My question: Is this Access, Excel or VBA question?

2) Develop interface for data exchange between MS Access database and MS excel model that can be easily maintained / modified

My question: Is this Access, Excel or VBA question. What does MS excel model mean here? Do you have an example to understand this question.

3) Conduct user acceptance test with documentation

My question: What does "user acceptance test" mean


4) Prepare model documentation and training material

 

[Joe4]

Since no one has replied, I will add in my two cents.

It looks like this would require a pretty good knowledge of Excel, Access, and VBA (probably for both Excel and Access).
If you do not have all that knowledge, you probably would not be qualified for the job.

 

[MARK858]

My question: What does "user acceptance test" mean

Definition from techopedia...

User acceptance testing (UAT) is the last phase of the software testing process. During UAT, actual software users test the software to make sure it can handle required tasks in real-world scenarios, according to specifications.

or in more detail https://www.softwaretestinghelp.com/what-is-user-acceptance-testing-uat/

2) Develop interface for data exchange between MS Access database and MS excel model that can be easily maintained / modified

What does MS excel model mean here?

It probably means creating a data model...
https://support.office.com/en-ie/ar...in-excel-87e7a54c-87dc-488e-9410-5c75dbcb0f7b

or another take...
https://www.deskbright.com/excel/what-is-an-excel-model/

Basically the way the questions are worded they are looking for previous provable experience in these fields.