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 … Continue reading
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 … Continue reading
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. … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading