Start learning with our library of video tutorials taught by experts. Get started
Viewed by members. in countries. members currently watching.
In Access 2010 Essential Training, Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010, whether using predefined database templates or building from scratch. This course covers each step of constructing and modifying databases for custom purposes, as well as working with tables, forms, queries, macros, and reports and charts for record keeping and analysis. Exercise files are included with the course.
Before we can start building our database, we need to plan it out. No matter how much enthusiasm you have for building your database to organize your business, you can't just jump in and start typing, then make corrections later. All of the components are interlaced, and the more time you spend in the beginning planning and designing, the less frustration you'll have later, or worse, the less work you'll have to redo. Plan ahead. What information can you imagine ever needing to collect, even if you're not using it now: customer referral sources for marketing, additional details about the product.
The more you build in from the start the less back-filling you'll need to do later. Let's take a look at the project for this course. TwoTreesOliveOil. What information do we need to track? Customers, Sales Reps, Products, and Orders. Next, what information do we need about each one? It's helpful to write these out on paper, or in a Word document. Think about the relationships within the data. How will you put one set of information into another? Then examine what kind of end results you'd like to see: an order form to take customer orders that automatically recognizes our products, a report of what products sold best, which customers sold the most, and reports for your sales reps, everything from contact information to how much money they made to company.
These are just a sample of the analysis we'll do on our own data. But as you think about these questions for your own project, be sure to include all the fields you'll need to generate these types of reports. Planning ahead can be over half the work in developing a database solution for your company.
Find answers to the most frequently asked questions about Access 2010 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.