All other rights are reserved. When you click Create, Access prepares the template and opens the new database. If the Navigation pane is collapsed, click the chevron at the top of the pane to view the database objects included in this template. This chapter guides you in studying how to perform these operations and describes other important concepts and techniques involved in creating and managing an Access database—how to set and manage relationships between Access tables, how to navigate through a database, and how to export the data you store in Access to other programs and to other formats. View video tutorials about the on Microsoft exams. You must demonstrate that you can complete certain tasks or projects rather than simply answering questions about program features. Creating Access web appsWorking with application parts; Using earlier Access file formats; Practice tasks; 1.
Your work is scored based on its result, not on the method you use to achieve that result unless a specific method is indicated in the instructions. Relationships help reduce data redundancy by letting you store information in separate tables that you link together. Specifically, the following objectives are associated with this set of skills: 1. First click the specified tab, and then locate the specified group. We appreciate your input in ensuring the quality of the Microsoft Certification program.
You can create several types of relationships between tables in an Access database. Note that Microsoft will not respond directly to your feedback. You must dem- onstrate that you can complete certain tasks or projects rather than simply answering questions about program features. Who should take this exam? Relationships protect data integrity by preventing you from creating orphan records for example, an order with no custom- er. View video tutorials about the on Microsoft exams. Acquisitions Editor: Rosemary Caperton Editorial Production: Online Training Solutions, Inc. Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. If so, substitute a tap- ping action any time we instruct you to click a user interface element. In most cases, Access displays a default table or opens a form for data input. If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your. If you have any other queries related to Office products, feel free to reply and I'll be happy to further assist you. Access databases are made up of database objects, including tables, queries, forms, re- ports, and supporting objects such as macros.
A core-level candidate for the Microsoft Word 2013 exam should have a fundamental understanding of the Word environment and the ability to complete tasks independently. At the beginning of the exam, you will receive information about the questions or projects that are included in the exam. If you would like to be able to refer to the completed versions of practice files at a later time, you can save the practice files that you modify while working through the exercises in this book. As a certification candidate, you probably have a lot of experience with the program you want to become certified in. Study the graphics and ensure that you are familiar with all the options available for each tool.
Each project will require that you complete multiple tasks. For more information Exam 77-424 Microsoft Access 2013 Prerequisites 1 Create and manage databases 1. Each section includes review information, generic procedures, and practice tasks you can complete on your own while studying. Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. If you need additional support, email Microsoft Press Book Support at: Please note that product support for Microsoft software is not offered through the preceding addresses. As a certification candidate, you probably have a lot of experience with the program you want to become certified in.
They should know and demonstrate the correct application of the principal features of Word 2013. Introduction xiii We want to hear from you At Microsoft Press, your satisfaction is our top priority, and your feedback our most valuable asset. To build a select query, you add fields from one or more tables and then define criteria that Access uses to retrieve the records you want to view. Please use this preparation guide to prepare for the exam, regardless of its format. Along the left side of the window, Access displays a list of recent files and a link you can use to open other files. In a one-to-many relationship, a record in one table can be related to one or many records in another.
We want to hear from you! You can also create one-to-one relation- ships and many-to-many relationships. In some cases, graphics depict the tools you will use to perform procedures related to the skill set. The higher the percentage, the more questions you are likely to see on that content area on the exam. Hands-on experience with the tech- nology is required to successfully pass Microsoft Certification exams. Forms use controls such as text boxes, check boxes, and list boxes to provide a user interface for a database. The following table lists the practice files for this book.