We’ve recently developed new resources to help clients achieve their Microsoft certification goals. We now offer a directory of Microsoft certification training, organized according to specific certification paths and the associated courses. More specifically, we have the Microsoft Office Specialist certification training.
You are browsing the Microsoft Access category:
To continue with the Edit Relationships Dialog box, the next area for discussion is the Cascade Updates section.
In one of my earlier blog posts about creating Relationships between tables, you saw the Edit Relationship Dialog Box. I want to take a moment to discuss this Edit Relationship Dialog Box in a little more detail. It did look like this.
Microsoft Access is a relational database system. That simply means that in the one file you can have multiple tables, forms, queries, and reports. It is pretty much like when you were back in junior high school and you kept all of your notes in a three-ringed binder with different sections for each of your individual classes. Access has a navigation pane on the left side that acts as a separator of each type of object. Read the rest of this entry »
In our databases we often want to be able to include relevant material with our records. For example, if you are in a health related field, you might want to include the latest information about a particular drug or the latest study about a particular medical ailment. Up to now, what you had to do was to either retype a short summary of the article or you could create a hyperlink data type to store the URL of the article on the web. In an employee database, you might want to also store the resumes with the applications. Now in Access 2010 and in Access 2007, you can use the new data type field of attachment to do this. This is where you can attach any type of file or multiple files to a particular record: a word document, an Excel worksheet, a chart, or an image to name a few. In the Employee table of your database, you may want to include the resumes of perspective employees. You can do this by simply adding the field of resume as an attachment data type in design view of your table. Read the rest of this entry »
How many times have you had to create an expression on a form to place the name field? For good table design in previous versions of Access, you had one text field for last name and another text field for first name. But when you wanted to have the complete name in one field, you had to build a form and then create an unbound text box to place the concatenated field. Well, now in Access 2010 there is a new data type called calculated. And it does allow you to concatenate two fields that are in the same table into a new separate field that can be seen in the datasheet view. The only concession that it has is that the new field must be created based on two or more fields within the same table. Let me show you how easy it is to do that. Read the rest of this entry »
With so much collaboration in today’s business world, we often assign two or more people to the same project. In previous versions of Access, you had to enter separate records for each person to that project. Not anymore! Access has now included a multivalue field in the database. Is it hard to set up? Not at all. For example, in your database you already have a table listing the employees. You will want to create a separate table for your projects. In this projects table, you will have the fields of Project Id, Project Name, Description, Due Date, and Employees.
Sometimes in a query, you want to do a calculation. I find that the easiest way is to use the Expression Builder within Access. When you first open it, it may look confusing but it really isn’t. It is like the Christmas that you received the big box present. Once you opened the box, inside you found a smaller box, and once you opened that box, you found another smaller box. Well, the Expression Builder is organized that same way. In the bottom half of the dialog box that comes up, you see three list areas. Read the rest of this entry »
Would you like to customize your Microsoft Access 2007 Database with a Title and a Custom Icon? Follow these easy steps below: Read the rest of this entry »