Category Archives: Access

Access 2010: Designing Your Own Database – Lesson 15

Now that you know how to use and modify existing databases, you might be interested in designing your own. Database design can be very complicated– so complicated, in fact, that people take extensive courses just to learn how to plan databases. For that reason, we haven’t focused on creating a database from scratch in this […]

0  

Access 2010: Formatting Forms – Lesson 14

After creating a form, you might want to modify its appearance. Formatting your forms can help make your database look consistent and professional. Some formatting changes can even make your forms easier to use. With Access 2010’s formatting tools, you can customize your forms to look exactly the way you want. In this lesson, you will learn […]

0  

Access 2010: Creating Forms – Lesson 13

Creating forms for your database can make entering data much more convenient. When you create a form, you can design it in a way that works with your database and makes sense to you. In this lesson, you will learn how to create and modify forms. You’ll also learn how to use form options like design controls and form properties to make sure your form […]

0  

Access 2010: Modifying Tables – Lesson 12

After working with your database, you might find that you need to make some changes to the tables that store your data. Access makes it easy to modify your tables to suit your database’s needs. In this lesson, you’ll learn how to create and rearrange table fields. You’ll also learn how to ensure that your table data is correctly […]

0  

Access 2010: Advanced Report Options – Lesson 11

Access 2010 offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports.  Once you’ve created a report, whether through the Report Wizard or the Report command, you can then format it to make it look exactly how you want. In this lesson, you’ll learn how to […]

0  

Access 2010: Creating Reports – Lesson 10

If you need to share information from your database with someone, but don’t want them actually working with your database, you should consider creating aReport. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access 2010 makes it easy to create and customize a report using data from any query […]

0  

Access 2010: More Query Design Options – Lesson 9

Access 2010 offers many options that let you design and run queries that return exactly the information you’re looking for. For instance, what if you need to findhow many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to […]

0  

Access 2010: Designing a Query – Lesson 8

The real power of a relational database is in the ability to quickly retrieve andanalyze your data by running a query. Queries allow you to pull informationfrom one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-table query. Then you will learn how to plan and run […]

0  

Access 2010: Sorting and Filtering Records – Lesson 7

Access 2010 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. In this lesson, you’ll learn […]

0  

Access 2010: Working with Forms – Lesson 6

While you can always enter data directly into database tables, you might find it easier to use forms. Using a form to enter data lets you be certain that you’re entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using […]

0