How to Use the Create Tab in Microsoft Access 2007

Now we are going to explore the features and commands on the Create tab. So let’s click the Create tab right now. On this tab you will see four groups Tables, Forms, Reports and Other. These are all listed according to the database object. You can create a new table which will be a blank table. You can use one of five existing table templates to create new tables. Next to Table Templates is SharePoint Lists, you can create list on Windows SharePoint Services 3 sites. I am going to click the arrow to collapse the list again. Next to the SharePoint Lists button is the Table Design button and here you can create a new table in design view and we will discuss that in the tables lesson.

Next to the Tables group is the Forms group, and on here similar to the tables you can create new forms. We have a quick create form command here, a Split Form, Multiple Items, you can create a PivotChart form, a Blank Form will give you a blank design grid to start from scratch. The More Forms button has an arrow that you can click to display four options, Form Wizard, Datasheet, Modal Dialog and PivotTable. I am going to click that off and next to the more forms is Form Design, this creates a new form object, but in design view so that you can start creating a new form.

Next to the Forms group is Reports group, similar commands. You can open up a brand new quick create report based on this first button. Labels, you can use the label wizard to help you create custom labels for mailing addresses. The Blank Report button will create a new blank report and open it in the new layout view in Access 2007. If you need help designing a report, the Report Wizard is a great tool to help you get a jump start on creating reports. It will walk you through the process of creating a new report. We will show you this in the reports lesson. Next to the Report Wizard is the Report Design button and here you can create a new report and this opens it in design view as opposed to the layout view that the blank report button did.

Next to the reports is the other group and I like to think of this as the leftovers, all the remaining database objects. The Query Wizard will help you create a new query by using a wizard dialog box that will walk you through the process of creating your query. Query Design will open a new query in design view and you can design from scratch. This Macro button is a split button. The top of the button will vary depending upon the last object you created, the bottom button has three options, Macro, Module and Class Module. I just mentioned that the top of the button will change based on what you select. If I create a new module for instance, the next time I come to this button a Module icon will display in the upper part of this window.


Transcription by: Scribe4you Transcription Services