The other key difference is that you can build highly functional data entry screens and report templates to create an elaborate and elegant database system. “John David Smith” will never be accidentally duplicated as “John D. You can set up infinite ways to view and combine your data, but behind it all, the data will only ever exist in one place. Instead of having lots of worksheets or documents with similar, repeated data, you will have each piece of data stored one time, in an Access table. The biggest difference is summed up by the Access adage: “Each piece of data is stored one time, in one place.”

It does have some size limits, although the limits are high enough that most offices can use Access with no problems.Īccess differs from Excel in a couple of key ways, and in myriad small ways.It requires a lot more learning and training than other Microsoft programs.It doesn’t deploy very easily to the web or hand-held devices without using additional services like Sharepoint.It is robust and flexible, and it can do almost anything an office or industrial environment needs it to do.It is very affordable compared to other database packages.It is completely customizable to your individual and company needs.What are the Pros and Cons of using Access? Generally speaking, an Access database is a logical next step after Excel or other data programs when the data reaches a certain level of complexity or high volume, and when having multiple people using the same data is causing errors and confusion. And, it has tools for creating reports and mailings using your data. You also use a database to manage information through data entry and edits. Understanding and Using a Split Database Sharing with Other UsersĬompact and Repair Microsoft Trust CenterĪccess is the database software that is part of the Microsoft Office Suite, which contains familiar programs like Word, PowerPoint, and Excel.Īn Access database is a place to store information such as names, addresses, activities, and any other type of personal or business data. Reports Working with an Existing Database TABLE OF CONTENTS: CLICK TO JUMP TO A SPECIFIC SECTION Introduction Interested in more than just a guide? Check out a full course.

Microsoft access 2013 tutorial 6.3