[nfbcs] Using Microsoft Access

[Andy B.]

We used it as a data transport mechanism to shuttle data from Excel to SQL
Server because it is easier than remapping Excel columns and data types to
SQL columns and data types. It is fairly easy to use when you get used to
the user interface. Try showing all object types in the sidebar. It makes
finding things easier.


-----Original Message-----
From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Chris Nestrud via
nfbcs
Sent: Monday, January 23, 2017 7:59 PM
To: Amanda M Baker via nfbcs <nfbcs at nfbnet.org>
Cc: Chris Nestrud <ccn at chrisnestrud.com>
Subject: Re: [nfbcs] Using Microsoft Access

You should be able to create tables and queries by using the design views
without to much trouble. It may be faster to switch to sql view when editing
queries.

Consider alternatives such as SQL Server Express if your goal is to create
something more than a class assignment.

Chris

On Mon, Jan 23, 2017 at 06:44:15PM -0500, Amanda M Baker via nfbcs wrote:
> Hey all,
> I see from previous conversations that people have attempted to use 
> Microsoft Access in the past. I was wondering if anyone has found a 
> way to use this application yet? I am using Microsoft 2016. I am 
> taking a class in databases so it would be great to receive some 
> feedback when y'all can. Thanks.
> Amanda
> 
> --
> Amanda Baker
> Masters of Science in Information Science Student representative on 
> Masters Committee
> 516-695-6698
> 
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for
nfbcs:
> http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/ccn%40chrisnestrud.
> com

_______________________________________________
nfbcs mailing list
nfbcs at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for nfbcs:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/sonfire11%40gmail.com