Looking for:
MICROSOFT ACCESS Tutorial and Lab Manual – PDF Drive
Access allows you to manage your information in one database file. Within Access there are four major objects: Tables, Queries,. Forms and Reports. For more information, see “Download the practice files” in this book’s Introduction. Creating forms by using the Form tool. Before you begin creating a form for.
Microsoft access 2013 notes pdf free download
If the field contains another type of file, such as a Word document or PowerPoint presentation, the control displays the appropriate icon for that file type. After you add an attachment control to a form, you can add, edit, remove, and save attached files directly from that form.
When a record contains multiple attachments, you can also scroll through the attached files, which you cannot do when working with a table. Note: The person who designed the form may have made the form read-only.
If that is the case, you can use the Attachments dialog box only to save attached files to your hard disk drive or a location on your network. Open the form that displays your attachments, and locate the record to which you want to attach a file. The Mini toolbar appears:. Note: If you added the attachment control to the datasheet section of a split form, the Mini toolbar does not appear. For more information about split forms, see the article Create a split form. Click the View Attachments button the paperclip icon to open the Attachments dialog box.
Use the Look in list to navigate to the file that you want to attach, and then click Open. Note: The steps in this section apply to forms and reports. Click the Back left or Forward right arrows to scroll through the attached files. If you want to know the names of the files, click the View Attachments button to open the Attachments dialog box. The names of attached files appear in the Attachments list.
The steps in this section apply to tables, forms, and reports. You can save either one or all of the files that are attached to a given record to locations on your hard disk drive or network. Remember that when you choose to save all files, you cannot choose to save some of the files — you must save them all. To selectively save files, you need to do so one at a time. Open the table, form, or report that contains your attachments, and then open the Attachments dialog box.
Open the Attachments dialog box from a table. Open the table in Datasheet view, and then double-click the attachment field that contains the attachment you want to save.
Open the Attachments dialog box from a form or report. Use the Save in list to navigate to the new location for your file, and then click Save. Use the Look in list to navigate to the new location for your files, and then click Save. Double-click the attachment field in your table to open the Attachments dialog box.
In your form in either Layout view or Form view , navigate to the record that contains the attachment you want to remove, and click the View Attachment button on the Mini toolbar to open the dialog box. In the Attachments dialog box, select the file that you want to delete and click Remove. The following section explains how to use your keyboard to place focus in the Navigation Pane and open the table, form, or report that contains attached files. The steps also explain how to browse attached files and open the Attachments dialog box.
Note: If the Navigation Pane is closed, pressing F11 opens it and places the focus in the pane. If the pane is open, pressing F11 closes it. You must press F11 again to open the pane and shift focus to it.
If you open a table, Access places the cursor in the first field in the table. If you open a form or report, Access places the focus in the first field. Press the TAB key to move among the buttons in the dialog box and to move from the buttons to the list of attached files under Attachments. Note: Records may contain more than one attachment. If you need to select an attachment from a list of two or more files, press the TAB key to move to the file list, and then use the arrow keys to select the file that you want.
Next, press the TAB key to return to the buttons and select the action that you want. These steps apply only if you have a Microsoft Natural Keyboard and when a record contains more than one attachment.
As needed, press the TAB key to move the focus to the attachment control. By default, Access highlights the control and the label associated with the control, if the label exists. Press the TAB key to move among the buttons in the dialog box and to move from the buttons to the list of attached files under Attachments Double-click to edit. Records may contain more than one attachment. The following sections provide reference information about attachments, including the image and document file formats that attachments support, file-naming conventions, and some information about attaching files to records programmatically.
Access supports the following graphic file formats natively, meaning the attachment control renders them without the need for additional software. As a rule, you can attach any file that was created with one of the Microsoft Office programs.
You can also attach log files. In addition, file names must conform to these guidelines:. Microsoft Access Step by Step offers a comprehensive look at the features of Access that most people will use most frequently. Who this book is for Microsoft Access Step by Step and other books in the Step by Step series are designed for beginning-level to intermediate-level computer users. If part of your job involves entering data in or producing reports from a database designed by someone else, this book will help you understand the behind-the-scenes functionality of the database.
If you are tasked with the maintenance of an existing database, you will learn important techniques for ensuring data integrity. Although we don t cover the macro and VBA functionality that enables experienced developers to create full-featured database applications, we do touch on more advanced topics such as controlling access and preventing problems. Examples shown in the book generally pertain to small and medium businesses but teach skills that can be used in organizations of any size. The databases you create and work with are desktop databases, designed to be used in Access on a local computer.
Access has powerful new capabilities to enable more advanced users to create applications, called Access web apps, that are stored as SQL databases on a Microsoft SharePoint site and can be viewed and manipulated through a web browser.
Because of the behindthe-scenes requirements of these databases, we briefly describe them but don t cover them in depth. Whether you are already comfortable working in Access and want to learn about new features in Access or are new to Access, this book provides invaluable hands-on experience so that you can confidently create and work with many types of desktop databases Introduction xi. Part 1 explains how to get data into a database, either directly by entering it into tables or indirectly by using forms; and how to get information out of a database, either by displaying it on the screen or by printing it in reports.
Part 2 discusses ways to ensure that the data in related tables is accurate, how to use queries to extract data from related tables, and how to create forms and reports that use related tables. Part 3 covers more advanced Access techniques, including securing the database and customizing the program to fit the way you work.
With this three-part structure, readers who are new to the program can acquire basic skills and then build on them, whereas readers who are comfortable with Access basics can focus on material that is of the most interest to them. Chapter 1 contains introductory information that will primarily be of interest to readers who are new to Access or are upgrading from Access or an earlier version.
If you have worked with a more recent version of Access, you might want to skip directly to Chapter 2. This book has been designed to lead you step by step through all the tasks a beginninglevel or intermediate-level user is most likely to want to perform with Access If you start at the beginning and work your way through all the exercises, you will gain enough proficiency to be able to create simple databases and work with more complex databases created by experts.
However, each chapter is self-contained, so you can jump in anywhere to acquire exactly the skills you need. Download the practice files Before you can complete the exercises in this book, you need to download the book s practice files to your computer. You should purchase and install that program before using this book.
If you might want to repeat the exercises, save the modified practice files with a different name or in a different folder. Introduction xiii. Get support and give feedback The following sections provide information about getting help with this book and contacting us to provide feedback or report errors. Errata We ve made every effort to ensure the accuracy of this book and its companion content. Any errors that have been reported since this book was published are listed on our Microsoft Press site at oreilly.
If you need additional support, Microsoft Press Book Support at Please note that product support for Microsoft software is not offered through the addresses above. Please tell us what you think of this book at: The survey is short, and we read every one of your comments and ideas. Thanks in advance for your input! Stay in touch Let s keep the conversation going! We re on Twitter at: Introduction xv. Preview and print database objects. Work in the Access user interface. Explore tables, forms, queries, and reports.
This chapter introduces Microsoft Access and is designed to serve different purposes for different readers, depending on prior knowledge of this program and other Microsoft Office programs. If you are a beginning Access user, you might want to skip the lists of new features and start with Working in the Access user interface. If you have used other Office or Office programs but have not worked with Access before, you might want to skip down to Understanding database concepts.
If you have upgraded to Access from Access , you might want to read as far as the end of Working in the Access user interface and then skip to Chapter 2, Create databases and simple tables. If you have upgraded to Access from Access or Access , you might be interested in the new features that have been introduced in this version of the program, but you might not need to work through the exercises in the rest of this chapter.
Throughout this book, you ll be working with databases that contain information about the employees, products, suppliers, and customers of a fictional company. As you complete the exercises, you will develop an assortment of tables, forms, queries, and reports that can be used to enter, edit, and manipulate the information in a database in many ways. You ll explore the program s user interface, and the concepts and structure of data storage in Access.
Then you ll look at database objects such as tables, forms, queries, and reports, while learning about Access features and functionality that you ll explore in more depth in later chapters. Finally, you ll preview and print database objects. For more information, see Download the practice files in this book s Introduction. Identifying new features of Access Access builds on previous versions to provide powerful tools for all your database needs.
If you re upgrading to Access from a previous version, you re probably most interested in the differences between the old and new versions and how they will affect you, and you probably want to find out about them in the quickest possible way.
The following sections list new features you will want to be aware of, depending on the version of Access you are upgrading from. Start with the first section and work down to your previous version to get the complete picture. If you are upgrading from Access If you have been using Access , you might be wondering how Microsoft could have improved on what seemed like a pretty comprehensive set of features and tools.
The new features introduced between Access and Access include the following: Access web apps You can still create powerful database applications that are stored locally or in a central location.
But if your organization is running Microsoft SharePoint with Access Services, you can now create a web form of a database that anyone with the correct permissions can view and manipulate from a web browser.
Judging by the amount of effort Microsoft is putting into Access web apps, it is likely that this sophisticated evolution of the web capabilities introduced with Access will be the wave of the future, at least for larger enterprises. When it is running on the Windows 8 operating system, it not only has the sleek new Windows 8 look but it also incorporates the latest touch technologies designed for tablet and mobile devices.
Starting screen Access opens to a screen that provides easy access to new database templates, the databases you recently worked on, and locations where existing databases might be stored. Cloud access When you connect your Office or Access installation to a Microsoft account formerly known as a Windows Live account or a Microsoft Office account, you have the option of saving desktop databases in the cloud to a SharePoint document library or a Microsoft SkyDrive site, so that it is available when you are not at your desk.
You display the Backstage view by clicking the File tab, which replaces the Microsoft Office Button at the left end of the ribbon. Customizable ribbon Create your own tabs and groups to suit the way you work. Unifying themes Add pizzazz to database objects such as forms and reports by applying a professional-looking theme from a gallery of options. Web databases With Access , companies with employees and clients in different geographic locations can make their databases accessible over the Internet in a web browser.
This technology is still available in Access , but it has been superseded by Access web apps. An Access web database cannot be converted to an Access web app. Navigation forms Offering the sophisticated browsing techniques people are accustomed to using on websites, these forms provide an essential navigation tool that can increase the usability and data security of any database.
Identifying new features of Access. The database templates that come with Access are supplemented by those made available by a community of database developers through the Office website. Application parts Add predefined database objects to an existing database. In addition to various types of forms, several Quick Start parts are available.
For example, adding the Contacts part adds one table and associated queries, forms, and reports. Enhanced Layout view and layout controls It is easy to make design changes in Layout view while viewing the underlying data. Enhanced Expression Builder The layout of the Expression Builder dialog box has been refined to make building an expression more intuitive. In addition, a feature called IntelliSense has been incorporated to display options based on what you enter and to provide syntax guidance.
Improved conditional formatting You can use data bars to add at-a-glance insight into the data in Number fields. You can optimize the file size for printing or publishing online.
If you are upgrading from Access In addition to the features listed in the previous sections, if you re upgrading from Access , you ll want to take note of the following features that were introduced in Access The ribbon The user interface organizes the most common commands for any database object into tabs and groups so that the appropriate commands are immediately accessible for the current object.
Quick Access Toolbar Customize a portion of the toolbar to include commands you regularly use, regardless of which object is currently active. Navigation pane The customizable Navigation pane replaces the Database window from Access Display or hide all tables, queries, forms, reports, macros, and modules, or create a custom group that displays only the objects you want to work with at the moment. You can even hide the Navigation pane to make more room on the screen for your database object.
Tabbed documents Open multiple database objects and switch between them quickly by clicking tabs on a tab bar. Template library Quickly locate and download professionally designed templates for common database projects. Improved sorting and filtering Easily sort all records in a table based on one or more fields, or filter a table or form to display or hide records matching multiple criteria.
Layout view Redesign a form or report while viewing it. Stacked and Tabular layouts Group controls in a form or report layout so that you can easily manipulate the entire group as one unit. Click the calendar, and select the date you want. Rich Text Memo fields support most common formatting options, including fonts, color, and character formatting. The formatting is stored with the database. Create tab Quickly create a new table, form, query, report, macro, SharePoint list, or other Access object.
Totals function Add a totals row to a query, and select from a list of formulas to automatically calculate aggregate values for forms and reports. Field List Drag and drop fields from one or more related or unrelated tables onto your active table. Attachment data type Attach photos and other files to a database record. Embedded macros Macros embedded in a form or report offer a higher level of security in database applications. Microsoft Access Help Easily search end-user and developer help content from within Access.
Improved report design Quickly create a professional-looking report, complete with logo, header, and footer; and use Report view, combined with filters, to browse only selected records in the report. Group, Sort, and Total pane This feature makes it much easier to group and sort data in reports, and add totals from a drop-down list. Enhanced security Adding password protection to a database causes Access to automatically encrypt the database when it closes, and decrypt it when it opens.
Working in the Access user interface The program we work with and depict in images throughout this book is a desktop installation of Access , installed from a DVD as part of the Office suite of programs. You might have installed Access as a freestanding program or as part of an Office subscription that allows users to install the desktop programs from the Internet. Regardless of how you installed Access, the program has the same functionality and works the same way. TIP Office is a cloud-based solution that small, midsize, and enterprise businesses can use to provide a variety of products and services to their employees through a subscription licensing program.
As with all programs in Office , the most common way to start Access is from the Start screen Windows 8 or the Start menu Windows 7 displayed when you click at the left end of the Windows Taskbar. When you start Access without opening a database, the program s starting screen appears.
From this screen, you can create a new database or open an existing one. Either way, the database is displayed in a program window that contains all the tools you need to create database objects and enter and manipulate data. The Access interface is designed to closely reflect the way people generally work with a database.
If you are not familiar with this interface, which was first introduced with Access , here is a quick description of the program window elements. Identifying program window elements The program window contains the following elements: Title bar This bar across the top of the program window displays the name of the active database and by default display the path to the folder where it is stored. It also provides tools for managing the program and the program window.
Working in the Access user interface 9. At the left end of the title bar is the program icon, which you click to display commands to restore, move, size, minimize, maximize, and close the program window.
To the right of the Access icon is the Quick Access Toolbar. By default, the Quick Access Toolbar displays the Save, Undo, and Redo buttons, but you can customize it to display any command you want.
The various sections presented in this document will help you to build a solid knowledge foundation of the software. This booklet is the companion document to the Intro to Access workshop. It includes an introduction to the Microsoft Access interface and covers the various aspects of database creation and management in Access Preview the PDF. It is never too late to start learning and it would be a shame to miss an opportunity to learn a tutorial or course that can be so useful as Introduction to Microsoft Access especially when it is free!
You do not have to register for expensive classes and travel from one part of town to another to take classes. All you need to do is download the course and open the PDF file. This specific program is classified in the Database category where you can find some other similar courses.
Thanks to people like you? Who share their knowledge, you can discover the extent of our being selected to easily learn without spending a fortune! Before we create a Database, lets quickly understand the holistic picture of what Database is, with particular reference to MS Access. Result : The below window will appear. All the Database templates are displayed below.
Step 2 We can select any template by clicking on it. Click on Contact Template for further reverence. Step 6 Optionally, you can click on any of the objects from left navigation pane and open that object for further references and work.
For, E. The first step in this Microsoft Access tutorial to store data in the database is creating a Table where data will reside.
Post creation of the table, we can keep inserting the rows in the table. Step 1 First Click Create tab. Then from Tables group, click Table. Step 2 Table Dialog box appears. And Click on the View you need to display. Steps 2 Select the Datasheet view option in the ribbon and add some data by entering the values in It.
ms access tutorial pdf with examples
Access MVP Andrew Couch guides you through the entire web app life cycle, from design through deployment and upgrades. After introducing Microsoft Office and the web app development environment, he reviews key issues associated with moving data into a web app or creating cloud apps with new data.
Next, he drills down into app construction, from table design to integration. Learn the simplest ways to get things done with Microsoft Outlook Get the full-color, visual guide that makes learning Microsoft Outlook plain and simple!
Get the full-color, visual guide that makes learning Microsoft Project plain and simple! Learn the simplest ways to get things done with Windows See it. Learn it.
In color. Your text simplified as the essential facts to prepare you for your exams. Over 2, higly probable test items. You’re beyond the basics, so dive right in and really put your database skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts tackle Access — and challenge yourself to new levels of mastery! Master essential data management and design techniques Import and link to data from spreadsheets, databases, text files, and other sources Use action queries to quickly insert, update, or delete entire sets of data Create custom forms to capture and display data Design reports to calculate, summarize, and highlight critical data–and learn advanced techniques Automate your application with macros and Visual Basic for Applications VBA Use Access Services to extend your database application to the Web Try out the sample client and web database applications in both bit and bit versions A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD.
The sample client and web database applications are provided in both bit and bit versions. Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
Provides a collection of tips on fixing annoyances found in Microsoft Access, covering such topics as performance, security, database design, queries, forms, page layout, macros, and expressions. This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book.
Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment. Experience learning made easy-and quickly teach yourself how to build database solutions with Access Topics include building an Access database from scratch or from templates; publishing your database to the Web; exchanging data with other databases and Microsoft Office documents; creating data-entry forms; using filters and queries; designing reports; using conditional formatting; preventing data corruption and unauthorized access; and other core topics.
Explains how to perform everyday tasks and how to customize a desktop, set up a home network, manage digital media, and publish files on the Web. Skip to content. Microsoft Access Plain Simple. Microsoft Office Professional Plain Simple. Microsoft Excel Plain Simple. Microsoft Office Plain Simple. Microsoft OneNote Plain Simple. A download manager is recommended for downloading multiple files. Would you like to install the Microsoft Download Manager? Generally, a download manager enables downloading of large files or multiples files in one session.
Many web browsers, such as Internet Explorer 9, include a download manager. Stand-alone download managers also are available, including the Microsoft Download Manager. The Microsoft Download Manager solves these potential problems. It gives you the ability to download multiple files at one time and download large files quickly and reliably. It also allows you to suspend active downloads and resume downloads that have failed. Microsoft Download Manager is free and available for download now.
Windows 10, Windows 7, Windows 8, Windows 8. Warning: This site requires the use of scripts, which your browser does not currently allow. See how to enable scripts. Download Microsoft Access Runtime from Official Microsoft Download Center Microsoft Premium Office apps, extra cloud storage, advanced security, and more—all in one convenient subscription For up to 6 people For 1 person.
Microsoft Access Runtime. Select Language:. Choose the download you want. Download Summary:. Total Size: 0. Back Next. Microsoft recommends you install a download manager. Microsoft Download Manager. Manage all your internet downloads with this easy-to-use manager. It features a simple interface with many customizable options:.
Download multiple files at one time Download large files quickly and reliably Suspend active downloads and resume downloads that have failed.
Microsoft access 2013 notes pdf free download
If the 12 Chapter 1 Explore Microsoft Access Make sure you visit the web page above and fill out the survey for this class. Carousel Next. Then you ll look at database objects such as tables, forms, queries, and reports, while learning about Access features and functionality that you ll explore in more depth in later chapters.