Skip to main content

Return to Digital Learning

Microsoft Access 2013


 

Access Basics

Access 2010: Introduction to Objects

Microsoft Access is a database creation and management program. Before diving into Access 2010, it's important to understand what a database is; how they can be used; and the difference between data management in Access and Excel.

A database is a collection of information - or data - that's stored on a computer, allowing you to enter, access, and analyze it in a way you never could on paper. Databases are so useful, in fact, you see them all the time. Ever waited at the doctor's office while the receptionist punched in your information, or asked a store employee to check their system for a special item? Then you've seen a database in action.

 

 
Access 2010: Introduction to Databases

Access 2010 is a database creation and management program in the Microsoft Office suite. In order to understand Access, you must first understand databases. Essentially a database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easy.

This video introduces you to the concepts of an Access database. It also distinguishes between an Access database and Excel's spreadsheets which are also useful for data.

 

Getting Around in Access 2013

Whenever you're learning a new program, it's important to familiarize yourself with the program window and the tools within it. Working with Access is no different. Knowing your way around the Access environment will make learning and using Access much easier.

In this video, you will familiarize yourself with the Access environment, including the Ribbon, Backstage view, the Navigation Pane, the Document Tabs bar, and more. You will also learn how to navigate with a navigation form, if your database includes one.

 

Working with Data

Working With a Database

Each Access database consists of multiple objects that let you interact with data. Databases can include forms for entering data, queries for searching within it, reports for analyzing it, and of course, tables for storing it. Whenever you work with your database, you are working with many of these objects at once. Fortunately, Access makes managing these objects pretty easy.

 

Access 2013: Working with Tables

While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables, since that's where all your data are stored. Tables are at the heart of any database, so it's important to understand how to use them.

In this video, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with.

 

Database Design Tips

Customizing Tables

Each Access database consists of multiple objects that let you interact with data. Databases can include forms for entering data, queries for searching within it, reports for analyzing it, and of course, tables for storing it. Whenever you work with your database, you are working with many of these objects at once. Fortunately, Access makes managing these objects pretty easy.

 

Working with Forms

While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure that you're entering the right data in the right location and format. This can help keep your database accurate and consistent.

This video will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones.

 

Sorting and Filtering

Access gives you the ability to work with enormous amounts of data, which means it can be hard to learn anything about your database just by glancing at it. Sorting and filtering are two tools that let you customize how you organize and view your data, making it more convenient to work with.


Continue Learning

resized powerpoint-01       excel-01       word-01

PowerPoint         Excel                      Word

 Brought tou you by