MS Access basic functions

  1. Microsoft (MS) Access. Review MS Access basic functions.
  1. Hoonuit MS Access Tutorials. Complete the Access 2016 tutorials: All (required). . List each module completed and provide a summary of what you learned within the module (Note: You do not have to provide a summary of each individual tutorial video within each module).

 

  1. What’s new?: We learn about the new changes brought to Access with the update that included two major things- tell me function which could be used to give commands and do things quickly and to export linked data source to excel.

 

  1. Getting Started: We begin from creating a template and learn about the features like tables, forms, reports and queries. We learn to enter data and understand these different functions.

 

  1. Basics: We learn the general overview of the functions of Access like using ribbon, customizing and resetting the customization. We use the quick access toolbar, customize and reset it. We learn to use the navigation pane, shutter bar and backstage view.

 

  1. Understand content security: Security is one of the biggest concerns in any database so, we enable a database that is not trusted in Access. We use the trust center and define trusted locations for our system.

 

  1. Create a database: This is the first step for which we create a new database based on an existing database or begin a database from scratch. We can find various templates for it making our work easier.

 

  1. Create a table: We can create a table in design view by entering data and using a template. We can assign a primary key or multiple keys and insert additional fields or delete them as per requirement. We learn how to navigate through the table, add, edit and delete records in the table.

 

 

  1. Work with a table: Once the tables are created we can edit the table by changing their height and width. We can freeze and unfreeze columns to view specific data and hide and unhide them based on our needs. We can find, replace, rename and copy fields or data in the table.

 

 

  1. Create a form:We can create a form and work with the property sheet in layout view. We can also create the form using the form wizard and modify the layout. We learn how to create a form from the scratch and add a field to it, design it, delete it and display it.

 

  1. Queries: We can create a detailed and a summary query in design view. We van add criteria to a query and logical operators. We can sort the query results and find the top values in a query.

 

  1. Reports: We can create various reports that may be detailed or a summary using a report wizard in Access. We can create it in design view or in layout view. We can also add a header and footer to the page and the report as a whole.

 

  1. MS Access. Open MS Access and explore the software. Summarize core structure, components, and capabilities of the application.

 

MS Access is suitable for beginner level to advanced level users where users can create and manage a database with macros and combine them using various commands. It has an advanced graphical user interface where users can quickly create, manage and analyze database and produce reports for analysis. It can be easily and widely sued along with other Microsoft products like word, excel and so on. It is a reliable software that has been in operation for a very long time.

 

 

  1. Alternatives to MS Access. Identify one alternative to MS Access. Compare the alternative’s capabilities to MS Access’ capabilities. Is the alternative you selected comparable? Explain.

 

Base is a great alternative for MS Access. The features of base are very much similar to the MS Access and they are based on the same source code. Base is offered by LibreOffice and OpenOffice but they barely differ from one another. Base is a Java based software which is similar to Ms. Access and works with a graphical user interface and provides the same basic functions for database generation and management.

 

 

  1. Business Uses of Databases. List one significant business use of desktop databases. Explain and comment on the significance of the identified database use for accounting practice. Hint: Search for “accounting uses of databases” and/or “business uses of databases”.

 

One of the significant use of desktop database is inventory tracking. An inventory tracking database can tell a business the amount of inventory is in a warehouse, in a storage room and on store shelves. Integrated bar codes and scanners form a complete tracking system, monitoring products as they move from one place to another and updating the database so you never need to count the inventory in a warehouse. A database can keep record and track of all this. A database can also create an alert when products and supplies are running low so that the inventory managers can place an order on time.