Wednesday, November 12, 2014

Access Blog Post

Microsoft Access is database software that allows the user to manipulate large amounts of data. The different components and features of Access lend to its easy-to-use, quick-learn format and make it beneficial for small and large office environments.

Three benefits of using Microsoft Access 2013 are;
1)Because Access is user-friendly and incorporates features that are used across other Microsoft Office applications, the learning curve is not very steep. Wizards make it easier to create an operational database in less than an hour

2)Large amounts of data can be integrated into the database without sacrificing performance. 
3)Information that is already available can be simply imported into the database; or, as stated earlier, the data can be keyed directly into the database. In a large office environment, Access can be programmed to take information from the enterprise resource software.

1)SQL=Structured Query Language (SQL), to manage the data and give users the information they are looking for
2)Field Lists=Small windows that display field names
3)Query grid=The lower pane in query design view
4)Syntax=Rules that determine how criteria are entered
5)Is Null=Criteria that finds all records where no entry has been made in the field

I could use access for charting weight loss program as well as financial reports like budget at home.

No comments:

Post a Comment