Microsoft office access 2013 manual pdf free download.Microsoft Access 2013: Forms in pdf

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Page 9 of Didn’t match my screen. If you don’t want to see the introductory pages again, uncheck Show introductory pages? What You Will Learn. If you see a check box labeled Show introductory pages? You have to come and see our Database. In addition, you can embed a macro directly into the event property of an object or control. Carry out an action or a series of actions when a database first opens.❿
 
 

Microsoft Access Tutorial: MS Access with Example [Easy Notes]

 
Free PDF Book Access The Missing Manual, Computer Programming Books, Download Free Microsoft Office Access Step By Step, MS Access Tutorial. Access allows you to manage your information in one database file. Within Access there are four major objects: Tables, Queries,. Forms and Reports. A form in Access is a database object that you can use to create a user interface for a database application. A “bound” form is one that is directly.

❿

 

MICROSOFT ACCESS 2013 Tutorial and Lab Manual – Microsoft office access 2013 manual pdf free download

 

If there is more than one table with a one-to-many relationship to the table that you used to create the form, Access does not add any datasheets to the form. A split form gives you two views of the data at the same time — a Form view and a Datasheet view. Selecting a field in one part of the form selects the same field in the other part of the form. You can add, edit, or delete data from either part as long as the record source is updatable, and you have not configured the form to prevent these actions.

Working with split forms gives you the benefits of both kinds of forms in a single form. For example, you can use the datasheet portion of the form to quickly locate a record, and then use the form portion to view or edit the record. In the Navigation Pane, click the table or query that contains the data that you want on your form. Or open the table or query in Datasheet view. For more information about form views, see the Understand Layout view and Design view section.

When you create a form by using the Form tool, the form that Access creates displays a single record at a time. If you want a form that displays multiple records but is more customizable than a datasheet, you can use the Multiple Items tool. When you use the Multiple Items tool, the form that Access creates resembles a datasheet. The data is arranged in rows and columns, and you see more than one record at a time. However, a Multiple Items form gives you more customization options than a datasheet, such as the ability to add graphical elements, buttons, and other controls.

For more information about customizing your form, see the sections Fine-tune your form in Layout view and Fine-tune your form in Design view. To be more selective about what fields appear on your form, you can use the Form Wizard instead of the various form-building tools previously mentioned.

You can also define how the data is grouped and sorted, and you can use fields from more than one table or query, as long as you specified the relationships between the tables and queries beforehand. On the Create tab, in the Forms group, click Form Wizard. Note: If you want to include fields from multiple tables and queries on your form, do not click Next or Finish after you select the fields from the first table or query on the first page of the Form Wizard.

Instead, repeat the steps to select a table or query, and click any additional fields that you want to include on the form. Then click Next or Finish to continue. If the wizard or the form-building tools don’t meet your needs, you can use the Blank Form tool to build a form. You can also select contiguous columns and drag them all to a new location.

For more, see Introduction to tables. You can copy and paste data from another program like Excel or Word into an Access table. This works best if the data is separated into columns. If the data is in a word processing program, such as Word, either use tags to separate the columns or convert into a table format before copying.

If the data needs editing, such as separating full names into first and last names, do that first in the source program. Note: Access sets the data type of each field based on the information you paste into the first row of each column, so make sure that the information in the following rows match the first row. You can either import data from other sources , or you can link to the data from Access without moving the information from where it is stored.

Linking can be a good option if you have multiple users updating the data and you want to make sure that you are seeing the latest version or if you want to save storage space. You can choose whether you want to link to or import data for most formats.

See Import or link to data in another Access database for more information. The process differs slightly depending on the data source, but these instructions will get you started:. If you don’t see the right format, click More. What do you think of this book? We want to hear from you! This tutorial is designed for those people who want to learn how to start working with.

Microsoft Access. This course is intended for a strictly personal use, the file is of format pdf level Beginner , the size of this file is You have to come and see our Database. You will find your happiness without problem! Download an introduction to the Microsoft Access interface and covers the various aspects of database creation and management in Access When you create a new database, you typically begin by creating several database objects such as tables, forms, and reports.

Eventually, you reach a point where you have to add some programming to automate certain processes and tie your database objects together. This article helps orient you to the programming tools in Access. What is programming? Use the Command Button Wizard to perform common programming tasks. Understand macros. Understand VBA code. Convert macros to VBA code.

For example, suppose that you have created a form and a report, and you want to add a command button to the form that, when clicked, opens the report.

Programming, in this case, is the process of creating a macro or VBA procedure and then setting the command button’s OnClick event property so that clicking the command button runs the macro or procedure. For a simple operation, such as opening a report, you can use the Command Button Wizard to do all the work, or you can turn off the wizard and do the programming yourself. This can be confusing to Access users because, in Access, the term “macro” refers to a named collection of macro actions that you can assemble by using the Macro Builder.

Access macro actions represent only a subset of the commands available in VBA. The Macro Builder gives you a more structured interface than the Visual Basic Editor, enabling you to add programming to controls and objects without having to learn VBA code. You should remember that in Access Help articles, Access macros are referred to as macros. VBA code is contained in class modules which are part of individual forms or reports and typically contain code just for those objects and in modules which are not tied to specific objects and typically contain “global” code that can be used throughout the database.

Objects such as forms and reports and controls such as command buttons and text boxes have various event properties to which you can attach macros or procedures. Each event property is associated with a specific event, such as clicking the mouse, opening a form, or modifying data in a text box. Events can also be triggered by factors outside of Access, such as system events, or by macros or procedures that are attached to other events. Your database can get complex if you add many macros or procedures to several event properties of many objects, but in most cases, you can achieve the results that you want by using very little programming.

The decision to use macros, VBA, or both depends primarily on how you plan to deploy or distribute the database. For example, if the database is stored on your computer and you are the sole user, and if you are comfortable using VBA code, you might decide to use VBA to perform most of your programming tasks.

However, if you intend to share your database with other people by locating it on a file server, you might want to avoid using VBA for security considerations. You should base your decision to use either macros or VBA code on two concerns: security and the functionality that you want. Security is an issue because VBA can be used to create code that either compromises the security of your data or can harm files on your computer. When you use a database that was created by someone other than yourself, you should enable VBA code only if you know the database comes from a trustworthy source.

When you create a database that will be used by other people, you should try to avoid including programming tools that require the user to specifically grant trusted status to the database. General techniques for avoiding the need for users to trust your database come later in this section. To help ensure the security of your database, you should try to use macros when you can and use VBA programming only for operations that cannot be performed by using macro actions.

❿
 
 

Microsoft office access 2013 manual pdf free download

 
 

On the Create tab, in the Reports group, click Report. For more about viewing and printing your report, see the section View, print, or send your report as an e-mail message. After viewing the report, you can save it and then close both the report and the underlying table or query that you used as a record source.

The next time that you open the report, Access will display the most recent data from your record source. You can use the Report Wizard to be more selective about what fields appear on your report. You can also specify how the data is grouped and sorted, and you can use fields from more than one table or query, provided you have specified the relationships between the tables and queries beforehand.

On the Create tab, in the Reports group, click Report Wizard. Follow the directions on the Report Wizard pages. On the last page, click Finish. When you preview the report, you see the report as it will appear in print. You can also increase the magnification to zoom in on details. Note: If you want to include fields from multiple tables and queries in your report, do not click Next or Finish after you select the fields from the first table or query on the first page of the Report Wizard.

Instead, repeat the steps to select a table or query, and click any additional fields that you want to include in the report. Then, click Next or Finish to continue. In the Navigation Pane, open the table or query that will be the record source for your labels by double-clicking it. On the Create tab, in the Reports group, click Labels.

Follow the directions on the pages of the Label Wizard. Access displays your labels in Print Preview so that you can see them as they will appear when they are printed. You can use the slider control on the Access status bar to zoom in on details. For more information about viewing and printing your report, see the section View, print, or send your report as an e-mail message.

Note: Print Preview is the only view you can use to see multiple columns — the other views show the data in a single column. If you aren’t interested in using the Report tool or the Report Wizard, you can use the Blank Report tool to build a report from scratch. This can be a very quick way to build a report, especially if you plan to put only a few fields on your report. The following procedure explains how to use the Blank Report tool:.

On the Create tab, in the Reports group, click Blank Report. A blank report is displayed in Layout view, and the Field List pane is displayed on the right side of the Access window. In the Field List pane, click the plus sign next to the table or tables containing the fields that you want to see on the report.

Drag each field onto the report one at a time, or hold down CTRL and select several fields, and then drag them onto the report at the same time. In Access, the design of a report is divided into sections. You can view your report in Design view to see its sections. To create useful reports, you need to understand how each section works.

For example, the section in which you choose to place a calculated control determines how Access calculates the results. The following list is a summary of the section types and their uses:. Report Header This section is printed just once, at the beginning of the report. Use the report header for information that might normally appear on a cover page, such as a logo, a title, or a date. When you place a calculated control that uses the Sum aggregate function in the report header, the sum calculated is for the entire report.

The report header is printed before the page header. Page Header This section is printed at the top of every page. For example, use a page header to repeat the report title on every page. Group Header This section is printed at the beginning of each new group of records. Use the group header to print the group name.

For example, in a report that is grouped by product, use the group header to print the product name. When you place a calculated control that uses the Sum aggregate function in the group header, the sum is for the current group. Detail This section is printed once for every row in the record source. This is where you place the controls that make up the main body of the report.

Group Footer This section is printed at the end of each group of records. Use a group footer to print summary information for a group. Page Footer This section is printed at the end of every page. Use a page footer to print page numbers or per-page information. Report Footer This section is printed just once, at the end of the report. Use the report footer to print report totals or other summary information for the entire report.

Note: In Design view, the report footer appears below the page footer. However, when the report is printed or previewed, the report footer appears above the page footer, just after the last group footer or detail line on the final page. Controls are objects that display data, perform actions, and let you view and work with information that enhances the user interface, such as labels and images.

Access supports three types of controls: bound, unbound, and calculated:. Bound control A control whose source of data is a field in a table or query is a bound control. You use bound controls to display values from fields in your database. A text box is the most common type of bound control. For example, a text box on a form that displays an employee’s last name might get this information from the Last Name field in the Employees table.

Unbound control A control that doesn’t have a source of data a field or expression is an unbound control. You use unbound controls to display information, lines, rectangles, and pictures. For example, a label that displays the title of a report is an unbound control. Calculated control A control whose source of data is an expression rather than a field is a calculated control.

You specify the value that you want in the control by defining an expression as the source of data for the control.

For example, the following expression calculates the price of an item with a 25 percent discount by multiplying the value in the Unit Price field by a constant value 0. An expression can use data from a field in the report’s underlying table or query, or from a control in the report.

When you create a report, it is probably most efficient to add and arrange all the bound controls first, especially if they make up the majority of the controls on the report. You can then add the unbound and calculated controls that complete the design by using the tools in the Controls group on the Design tab. You bind a control to a field by identifying the field from which the control gets its data.

You can create a control that is bound to the selected field by dragging the field from the Field List pane to the report. The Field List pane displays the fields of the report’s underlying table or query.

Alternatively, you can bind a field to a control by typing the field name in the control itself or in the box for the ControlSource value in the control’s property sheet. The property sheet defines the characteristics of the control, such as its name, the source of its data, and its format.

Using the Field List pane is the best way to create a control for two reasons:. A bound control has an attached label, and the label takes the name of the field or the caption defined for that field in the underlying table or query as its caption by default, so you don’t have to type the caption yourself. A bound control inherits many of the same settings as the field in the underlying table or query such as for the Format , DecimalPlaces , and InputMask properties.

Therefore, you can be sure that these properties for the field remain the same whenever you create a control that is bound to that field. If you already created an unbound control and want to bind it to a field, set the control’s ControlSource property to the name of the field.

After you create a report, you can easily fine-tune its design by working in Layout view. Using the actual report data as your guide, you can adjust the column widths, rearrange the columns, and add grouping levels and totals. You can place new fields on the report design and set the properties for the report and its controls.

To switch to Layout view, right-click the report name in the Navigation Pane and then click Layout View. You can use the property sheet to modify the properties for the report and its controls and sections.

To display the property sheet, press F4. You can use the Field List pane to add fields from the underlying table or query to your report design. To display the Field List pane, do one of the following:.

You can then add fields by dragging them from the Field List pane to the report. You can also fine-tune your report’s design by working in Design view. You can add new controls and fields to the report by adding them to the design grid. The property sheet gives you access to a large number of properties that you can set to customize your report. To switch to Design view, right-click the report name in the Navigation Pane and then click Design View. You can use the property sheet to modify the properties for the report itself and the controls and sections it contains.

To add a single field, drag the field from the Field List pane to the section where you want it displayed on the report. To add several fields at once, hold down CTRL and click the fields that you want. Then, drag the selected fields onto the report. When you drop the fields onto a report section, Access creates a bound text box control for each field and automatically places a label control beside each field.

Some controls are created automatically, such as the bound text box control that is created when you add a field from the Field List pane to your report.

Many other controls can be created in Design view by using the tools in the Controls group on the Design tab. Click the tool for the type of control that you want to add. For example, to create a check box, click the Check Box tool. Click in the report design grid where you want to position the upper-left corner of the control. You can add, edit, or delete data from either part as long as the record source is updatable, and you have not configured the form to prevent these actions. Working with split forms gives you the benefits of both kinds of forms in a single form.

For example, you can use the datasheet portion of the form to quickly locate a record, and then use the form portion to view or edit the record. In the Navigation Pane, click the table or query that contains the data that you want on your form. Or open the table or query in Datasheet view. For more information about form views, see the Understand Layout view and Design view section.

When you create a form by using the Form tool, the form that Access creates displays a single record at a time. If you want a form that displays multiple records but is more customizable than a datasheet, you can use the Multiple Items tool. When you use the Multiple Items tool, the form that Access creates resembles a datasheet. The data is arranged in rows and columns, and you see more than one record at a time.

However, a Multiple Items form gives you more customization options than a datasheet, such as the ability to add graphical elements, buttons, and other controls. For more information about customizing your form, see the sections Fine-tune your form in Layout view and Fine-tune your form in Design view. To be more selective about what fields appear on your form, you can use the Form Wizard instead of the various form-building tools previously mentioned. You can also define how the data is grouped and sorted, and you can use fields from more than one table or query, as long as you specified the relationships between the tables and queries beforehand.

On the Create tab, in the Forms group, click Form Wizard. Note: If you want to include fields from multiple tables and queries on your form, do not click Next or Finish after you select the fields from the first table or query on the first page of the Form Wizard. Instead, repeat the steps to select a table or query, and click any additional fields that you want to include on the form. Then click Next or Finish to continue. If the wizard or the form-building tools don’t meet your needs, you can use the Blank Form tool to build a form.

This can be a very quick way to build a form, especially if you plan to put only a few fields on your form. On the Create tab, in the Forms group, click Blank Form. After the first field has been added, you can add several fields at once by holding down the CTRL key, clicking several fields, and then dragging them onto the form at the same time. The order of the tables in the Field List pane can change, depending on which part of the form is currently selected.

If the field you want to add is not visible, try selecting a different part of the form and then try adding the field again.

Use the tools in the Controls group of the Design tab to add a wider variety of controls to the form. For a slightly larger selection of controls, switch to Design view by right-clicking the form and then clicking Design View. Layout view Layout view is the most intuitive view to use for form modification, and it can be used for almost all the changes that you would want to make to a form in Access.

In Layout view, the form is actually running. Therefore, you can see your data much as it will appear when you are using the form. However, you can also change the form design in this view. Because you can see the data while you are modifying the form, this is a very useful view for setting the size of controls or performing almost any other task that affects the appearance and usability of the form. If you encounter a task that cannot be performed in Layout view, you can switch to Design view.

In certain situations, Access displays a message that states that you must switch to Design view before you can make a particular change. Design view Design view gives you a more detailed view of the structure of your form.

You can see the Header, Detail, and Footer sections for the form. The form is not actually running when it is shown in Design view. Therefore, you cannot see the underlying data while you are making design changes. However, there are certain tasks that you can perform more easily in Design view than in Layout view.

You can:. Add a wider variety of controls to your form, such as bound object frames, page breaks, and charts. After you create a form, you can easily fine-tune its design by working in Layout view. Using the actual form data as your guide, you can rearrange the controls and adjust their sizes.

You can place new controls on the form and set the properties for the form and its controls. To switch to Layout view, right-click the form name in the Navigation Pane and then click Layout View.

You can use the property sheet to change the properties for the form and its controls and sections. To display the property sheet, press F4. You can use the Field List pane to add fields from the underlying table or query to your form design. To display the Field List pane:. To add a single field, double-click it or drag it from the Field List pane to the section on the form where you want it displayed. To add several fields at once, hold down CTRL and click the fields that you want to add. Then drag the selected fields onto the form.

You can also fine-tune your form’s design by working in Design view. You can add new controls and fields to the form by adding them to the design grid. The property sheet gives you access to many properties that you can set to customize your form. To switch to Design view, right-click the form name in the Navigation Pane and then click Design View.

❿