Lance A. Profile

5.0

(1 review)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$35 USD / hour

el dorado hills,

united states

$35 USD / hour

It's currently 11:08 AM here

Joined August 21, 2016

0 Recommendations

Lance A.

@lanceanderson

5.0

(1 review)

0.8

100%

$35 USD / hour

el dorado hills,

united states

$35 USD / hour

100%

Jobs Completed

100%

On Budget

100%

On Time

50%

Repeat Hire Rate

Database Development, Coding, Academic Writing

New to Freelancer with 20 years of experience in databases design & programming, academic writing, and content creation. I do very efficient work, and am meticulous in detail. Microsoft Access; SQL; Visual Basic: - Relational database design - Visual Basic code behind programming for modules and macros - Advanced & attractive input forms - Powerful & easy to use queries - Attractive & accurate reports - SQL backend for networking - Advanced security settings - Share you database on the web! - Live linking to other applications Microsoft Excel: - Logical and attractive spreadsheet design - Advanced formulas - Attractive & easy to read formatting - Live linking to other applications - Beautiful graphs & visual data Academic Writing; Editing; Proofreading: - 25 years of experience in academic writing - Medical journal publications - Degrees in Biology and medicine - Graduated with Highest Honors from undergraduate and graduate school

See all Microsoft Access Developers in United States

Contact Lance A. about your job

Portfolio

This is an example of a macro written in Visual Basic to extract information from Google Docs directly into Excel.

Visual Basic Macro to Extract Information from Google Docs

An example of an excel macro, written in Visual Basic, which obtains data from an Outlook address book.

Excel Visual Basic Macro linking to MS Outlook

3457424

Example of multiple table relationships in a MS Access database I developed.

Electronic Medical Record Database I created.

3459274

I am an expert at Visual Basic coding for advanced MS Access database development.

Visual Basic for Modules in Medical DB I created.

3416541

Published Article: Rural Telepsychiatry Is Economically Unsu

This contractor requested a site featuring his work, with a nice use of white space. It has a database linked for change orders.

Website designed for construction company

Visual Basic Macro to Extract Information from Google Docs

Excel Visual Basic Macro linking to MS Outlook

3457424

Electronic Medical Record Database I created.

3459274

Visual Basic for Modules in Medical DB I created.

3416541

Published Article: Rural Telepsychiatry Is Economically Unsu

Website designed for construction company

Reviews

Changes saved

Showing 1 - 1 out of 1 reviews

Filter reviews by:

5.0

$25.00 USD

microsoft access

lanceanderson did terrific work for me! I will definitely hire him again. I was in a real bind and needed complicated programming changes done to a MSAccess database with Visual Basic code behind.Our photography company was left with this database by an employee who left, and we needed these changes immediately. Lance has great communication skills, was meticulous in making sure he understood the project, and worked very well with us. He even threw in a security upgrade after pointing out a security flaw.

Microsoft Access

Microsoft SQL Server

Elizabeth T.

@lizewphotography

•

7 years ago

Experience

NWPG

Oct 2001 - Jan 2017 (15 years, 3 months)

Database design & programming, spreadsheet formulas & programming, IT, security, scheduling, billing, bookkeeping.

Education

MD -- AOA Medical Honors Society

Michigan State University College of Human Medicine,

United States

1991 - 1996

(5 years)

BA Biology -- Highest Honors

University of California, Santa Barbara,

United States

1986 - 1990

(4 years)

Publications

The Physical and Economic Dangers of Lead-Based Paint in the Homes of Individuals Below The Poverty

Michigan State University College of Human Medicine, Department of Medical Ethics. Lansing Journal.

A literature review of the physical and economic dangers of lead-based paint in the homes of individuals below the poverty line.

Should Parents Be Able to Make Healthcare Decisions for their Children Based on Religious Beliefs?

Michigan State University College of Human Medicine, Department of Medical Ethics. Lansing Journal.

A literature review of the effects of parents making healthcare decisions for children based on religious beliefs.

Cold Medication Ingredients and Psychosis

Poster. American Psychiatric Association, 1998

We performed a retrospective study of the effects of common ingredients in cold medications on thought disorders.

Economic Grand Rounds: Rural Telepsychiatry Is Economically Unsupportable: The Concord Crashes in a

Psychiatric Services 49:10, 1998

Telepsychiatry, the use of communication technologies to offer psychiatric services, has become a topic of great interest as a means of overcoming the effects of the shortage of psychiatrists in rural areas (1,2,3,4). The idea of using telecommunication in psychiatry is not new. In fact, examples can be found as far back as 1959, and the topic has been well reviewed (1,4,5,6).