Exam Microsoft Access - Certifications | Microsoft Docs.

Looking for:

77-424 microsoft access 2013 pdf free 

Click here to DOWNLOAD

     

77-424 microsoft access 2013 pdf free.1200+ Free Certificate Courses [2022 AUGUST][UPDATED]

 

TEST4U is used by educational institutions, enterprises and public sector in order to reassure the best learning outcome. Therefore TEST4U MOS Access Test ensures your learning result because it asks you to perform a series of actions , not just watch a video-lesson and answer some multiple choice questions. In case your knowledge of a topic is limited, you can consult our short video-solutions which guide you step-by-step.

By successful completion of our MS-Access TEST4U Module, you will have gained experience over using MS-Access, creating and managing Databases, building tables, creating queries, forms and reports, working with indexes and relationships, using functions. Our team of experts has incorporated the years of classroom training experience and teaching techniques into TEST4U.

Live question means that TEST4U assesses the result of your answer, not the way of answering a question. So when you use TEST4U , it is the real application software you train yourself on just as the one you will have to use at your work place. In order to answer it, you will have the real MS-Word at your disposal. There are many ways of answering the previous question.

After selecting the correct word, you use: 1. So, whichever way you choose to answer, if the result is correct, TEST4U will accept the answer as correct.

This is the case because TEST4U uses real application software; it does not simulate applications as it happens with simulation tests.

In the latter case the correct answer is the one set by the programmer, not the one accepted by MS-Word TEST4U allows you to train on the real applications, not on their simulations. Do not forget that when you need to use MS-Word or another application at your workplace, you have to be able to use the real application software, not one of its simulations.

TEST4U uses real application software e. Word, Excel. It is not a simulation application in Flash version. Actions taken by a candidate to create and complete the document are not predetermined.

Understanding is the essential prerequisite of completing the document. So the candidate must be able to understand the structure of the document and then hierarchize all necessary actions. In order to answer the question, the candidate needs to understand the number of columns and rows that the suggested table is consisted of first table and the differences between this one and the table of his document second table. Candidates will have to use these data to create a pivot table.

This means that they will have to analyze the presentation: the number of slides it is made of, the kind of objects displayed on every slide, if there are any transition effects etc. Interapplication questions require that the candidate is able to navigate to 2 applications at least. This series includes a complete classroom instructional program.

This Access text is mapped to the Access certification exam objectives and is designed to re-enforce workforce skills. With this book students learn to create and manage a database, build tables and forms, create and manage queries, design reports and much more.

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections or of the United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc.

Other product and company names mentioned herein may be the trademarks of their respective owners. The example companies, organizations, products, domain names, e-mail addresses, logos, people, places, and events depicted herein are fictitious.

No association with any real company, organization, product, domain name, e-mail address, logo, person, place, or event is intended or should be inferred. The information contained in this book is provided without any express, statutory, or implied warranties.

Thus our mission is to make our instructional programs trusted educational companions for life. To accomplish this mission, Wiley and Microsoft have partnered to develop the highest quality educational programs for Information Workers, IT Professionals, and Developers.

The Microsoft Official Academic Course series focuses on workforce development. These programs are aimed at those students seeking to enter the workforce, change jobs, or embark on new careers as information workers, IT professionals, and developers. Microsoft Official Academic Course programs address their needs by emphasizing authentic workplace scenarios with an abundance of projects, exercises, cases, and assessments. The textbooks focus on real skills for real jobs.

As students work through the projects and exercises in the textbooks they enhance their level of knowledge and their ability to apply the latest Microsoft technology to everyday tasks.

These students also gain resume-building credentials that can assist them in finding a job, keeping their current job, or in furthering their education. The concept of life-long learning is today an utmost necessity. Job roles, and even whole job categories, are changing so quickly that none of us can stay competitive and productive without continuously updating our skills and capabilities.

The Microsoft Official Academic Course offerings, and their focus on Microsoft certification exam preparation, provide a means for people to acquire and effectively update their skills and knowledge. Change views. This is the default view after starting Access. Validation Text Enter text that appears when a value violates the Validation Rule. Choose Plain Text to store only text. Precision Specify the total number of digits allowed, including those both to the right and the left of the decimal point when decimal Field Size property is set using Number data type.

Scale Specify the maximum number of digits that can be stored to the right of the decimal separator when decimal Field Size property is set using Number data type. Expression Specify the expression used for the Calculated data type to generate a value. Double-click the Events table in the Navigation Pane to open the table in Datasheet view, if it is not already open.

Both rows should have a key displayed beside them. The resulting composite key is more valid. Click the Save button on the Quick Access Toolbar. CLOSE the table. LEAVE the database open to use in the next exercise. This may be the case if you never initially designed your table with good database design principles in mind and never chose a primary key.

It will be up to you to determine what makes practical sense for your database. Keep in mind that composite keys can further complicate your database design. However, using composite keys may make sense in cases where you may need to quickly add a primary key where one never existed or may need a composite key that contains more meaningful data. These features may be accessed from the Find and Replace dialog box.

The Replace command can be used to automatically replace a word or number with another. If you want to replace the data, key the new data into the Replace With box and click Replace or Replace All. Step by Step Exercises Bottom Line 1.

A menu of installed programs appears. Another menu appears. Click Microsoft Access The Access startup screen opens, as shown in Figure The Access startup screen should be on the screen from the previous exercise.

Click the Open Other Files command on the left side of the Access startup screen. The Open screen appears, as shown in Figure When you open an existing database, you access not only your previously entered and saved data, but the elements you created to organize that data.

In this exercise, you open a database that is in the beginning stages of development. Click the location, and the folders will be displayed in the folder list. From this list, you can double-click the folder you want to open. Figure The Open screen 2. Click the Open button in the Open dialog box see Figure The existing database opens, as shown in Figure By default, Access blocks potentially harmful content that might contain viruses or present other security issues.

CLOSE the database. When you create a new blank database, Access opens a database that contains a table where you can enter data, but it creates no other database objects. In this exercise, you create a new blank database. The Access work area window should be on the screen from the previous exercise. Modify Tables and Fields 1. In the templates section of the New screen, click the Blank desktop database icon.

A Blank desktop database screen appears in the center of the screen, as shown in Figure Click Yes to delete the table. Take Note If the table was related to one or more additional tables, Access would ask if you wanted to delete those relationships before deleting the table. Cross Ref You can also delete information from individual records or delete entire records from a table, as you learned in Lesson 3.

Update Records. Delete Records. Filter Records. Hide Fields in Tables. Set Foreign Keys. Create and Modify Relationships.

Edit References Between Tables. View Relationships. Column 1 Column 2 1. You can use the Navigation buttons to search for data in a table. Use a template to create a database for the contacts. Select the Desktop call tracker database template. Click Create to create and open the database. Click Enable Content, if necessary.

Click the Supporting Objects header in the Navigation Pane to display the database objects in that group. Right-click the Customers table under the Customers header to display the menu and click Copy. Right-click in the white area of the Navigation Pane and click Paste on the menu.

In the Paste Table As dialog box, key Customers structure. Click the Structure Only option button the table contains no record data so choosing Structure Only will have the same effect as choosing Structure and Data. Click OK. Project Database for Restaurants As a regional manager for a franchise restaurant chain, you want to keep track of restaurant locations and customer comments.

You decide to create a database to store the necessary information. Click the Create button. Right-click the Table1 tab and click Save. Lesson 2 6. In the Save As dialog box, key Locations.

Project Adding Tables You need to add some tables to the database that you just created for information about the restaurants. USE the database that is open from the previous project. Use the Application Parts gallery to create a table for comments.

In the Create Relationship dialog box that appears, click the Cancel button. Rename the Comments table Uptown Comments. Copy the structure of the Uptown Comments table to create a new table. Name the new table Downtown Comments. Project Nutrition Tracker You have become health conscious and want to track your activity, exercise, and food logs using Access. If necessary, log on to the Internet. Click Enable Content on the Message Bar. Because you are the one who is most knowledgeable about computers, you will be responsible for keeping track of the listings and other relevant information.

Click the OK button on the form. Open the Tips table to view the tips stored in the database. Project 1: Create a Database and Tables 7. Explore the other useful forms and information available. After sketching out a plan on paper, you are ready to begin creating the database and tables.

Launch Access if it is not already running. Near the center of the screen, click the Blank desktop database icon. Click the Create button to create a new blank database.

Mastery Assessment 5. Click Click to Add and click Short Text on the shortcut menu. Key Address as the column name and press Enter. Project Northwind Traders 8. You have just joined the sales force at Northwind Traders. Mastery Assessment Projects 2. Enable the content. Log in as a sales representative, Jan Kotas, by selecting that name from the Select Employee drop-down menu and clicking the Login button.

Click Yes, if necessary, to close and save the Listings table, then click Cancel in the Create Relationship dialog box that appears. Open the Contacts table. Click Yes if you receive a dialog box warning you about the deletion. SAVE the table as Agents. Delete all the objects in your database except the Agents and Listings tables.

LEAVE the database open to use in the next project. Project 2: Modify Tables and Fields Now that you have created the tables for your database, you need to modify them to suit your needs.

The Agents table should be displayed. In the Property Sheet's Description property box, key Agent contact information. Microsoft and Wiley teamed up to produce a series of textbooks that deliver compelling and innovative teaching solutions to instructors and superior learning experiences for students.

Infused and informed by in-depth knowledge from the creators of Microsoft Office and Windows, and crafted by a publisher known worldwide for the pedagogical quality of its products, these textbooks maximize skills transfer in minimum time.

Students are challenged to reach their potential by using their new technical skills as highly productive members of the workforce. Because this knowledgebase comes directly from Microsoft, architect of the Office system and creator of the Microsoft Office Specialist MOS exams www.

With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. The MOAC program endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student—technical and curriculum training for instructor readiness with new software releases; the software itself for student use at home for building hands-on skills, assessment, and validation of skill development; and a great set of tools for delivering instruction in the classroom and lab.

All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the MOAC program. We think about the model below as a gauge for ensuring that we completely support you in your goal of teaching a great course. As you evaluate your instructional materials options, you may wish to use the model for comparison purposes with available products.

Many pedagogical features have been developed specifically for Microsoft Official Academic Course programs. Unique features of our task-based approach include a Lesson Skills Matrix that correlates skills taught in each lesson to the MOS objectives; Certification, and three levels of increasingly rigorous lesson-ending activities: Competency, Proficiency, and Mastery Assessment. Presenting the extensive procedural information and technical concepts woven throughout the textbook raises challenges for the student and instructor alike.

More than a standard list of learning objectives, the skill matrix correlates each software skill covered in the lesson to the specific MOS exam objective domain. This feature provides an overview of the soft- ware features students will be working with in the lesson. The orientation will detail the general properties of the software or specific features, such as a ribbon or dialog box; and it includes a large, labeled screen image. Numbered steps give detailed, step-by-step instructions to help students learn software skills.

The steps also show results and screen images to match what students should see on their computer screens. The images reinforce key concepts, provide visual clues about the steps, and allow students to check their progress. When these terms are used later in the lesson, they appear in bold italic type with yellow highlighter and are defined. The Glossary contains all of the key terms and their definitions.

Reader aids also provide additional relevant or background information that adds value to the lesson. They provide students with a chance to check their understanding of that particular MOS exam objective and, if necessary, review the section of the lesson where it is covered.

These new features preview how the Microsoft Office system applica- tions are used in real-world situations. These files are indicated by the file download icon in the margin of the textbook. For more information about the features in each lesson, refer to the Illustrated Book Tour section.

Words in all capital letters indicate instructions for opening, saving, or closing files or programs. They also point out items you should check or actions you should take. This feature signals the point in the text where a specific certification objective is covered.

It provides you with a chance to check your understanding of that particular MOS objective and, if necessary, review the section of the lesson where it is covered. Take Note Reader aids appear in shaded boxes found in your text. Take Note provides helpful hints related to particular tasks or topics. Another Way provides an alternative procedure for accomplishing a particular task. Another Way Cross Ref These notes provide pointers to information discussed elsewhere in the textbook or describe interesting features that are not directly addressed in the current topic or exercise.

Keys that you are instructed to press in an exercise will appear in the font shown here. A shared printer can be used by many individuals on a network. Key terms appear in bold italic. Key My Name is Any text you are asked to key appears in color. Click OK Any button on the screen you are supposed to click on or select will also appear in color. The names of data files will appear in bold, italic and red for easy identification.

These data files are available for download from the Student Companion Site www. Step-by-step tutorial videos are available for many of the activities throughout this course. For information on how to access these videos, see the Student Companion Site www.

These resources provide all the materials instructors need to deploy and deliver their courses. A complete answer key is provided. These projects cover topics from within one specific lesson. Solution files suitable for grading with OfficeGrader are also provided.

These projects are suitable for a final exam or final project for the course. These projects cover a range of topics from throughout the entire book. NET Framework concepts addressed in the text.

You can incorporate them into your PowerPoint presentations, or create your own overhead transparencies and handouts. Save tens or hundreds of hours each semester with automated grading. The Wiley Faculty Network connects teachers with technology, facilitates the exchange of best practices, and helps to enhance instructional efficiency and effectiveness.

Faculty Network activities include technology training and tutorials, virtual seminars, peer-to-peer exchanges of experiences and ideas, personal consulting, and sharing of resources. For details visit www. To learn more about becoming a Microsoft Certified Professional and exam availability, visit www.

The membership provides a complete solution to keep academic labs, faculty, and students on the leading edge of technology. Software available through the DreamSpark Premium program is provided at no charge to adopting departments through the Wiley and Microsoft publishing partnership.

Contact your Wiley rep for details. Visit Microsoft. Students can access it online and download to their computer for off line access and access read and study on their device of preference—computer, tablet, or smartphone. Microsoft Office Specialist MOS is a valuable credential that recognizes the desktop computing skills needed to use the full features and functionality of the Microsoft Office suite.

In the worldwide job market, Microsoft Office Specialist is the primary tool companies use to validate the proficiency of their employees in the latest productivity tools and technology, helping them select job candidates based on globally recognized standards for verifying skills.

The results of an independent research study show that businesses with certified employees are more productive compared to non-certified employees and that certified employees bring immediate value to their jobs.

In academia, as in the business world, institutions upgrading to Office may seek ways to protect and maximize their technology investment. By offering certification, they validate that decision—because powerful Office applications such as Word, Excel and PowerPoint can be effectively used to demonstrate increases in academic preparedness and workforce readiness.

Individuals seek certification to increase their own personal sense of accomplishment and to create advancement opportunities by establishing a leadership position in their school or department, thereby differentiating their skill sets in a competitive college admissions and job market.

The MOS certifications target information workers and cover the most www. By becoming certified, you demonstrate to employers that you have achieved a predictable level of skill in the use of a particular Office application.

Employers often require certification either as a condition of employment or as a condition of advancement within the company or other organization. The certification examinations are sponsored by Microsoft but administered through exam delivery partners like Certiport. Preparing to Take an Exam Unless you are a very experienced user, you will need to use a test preparation course to prepare to complete the test correctly and within the time allowed.

The Microsoft Official Academic Course series is designed to prepare you with a strong knowledge of all exam topics, and with some additional review and practice on your own. You should feel confident in your ability to pass the appropriate exam.

After you decide which exam to take, review the list of objectives for the exam. You can also easily identify tasks that are included in the objective list by locating the Lesson Skill Matrix at the start of each lesson and the Certification Ready sidebars in the margin of the lessons in this book.

Then call the testing center directly to schedule your test. The amount of advance notice you should provide will vary for different testing centers, and it typically depends on the number of computers available at the testing center, the number of other testers who have already been scheduled for the day on which you want to take the test, and the number of times per week that the testing center offers MOS testing.

In general, you should call to schedule your test at least two weeks prior to the date on which you want to take the test. When you arrive at the testing center, you might be asked for proof of identity. If you do not have either of these items of documentation, call your testing center and ask what alternative forms of identification will be accepted. If you are retaking a test, bring your MOS identification number, which will have been given to you when you previously took the test. If you have not prepaid or if your organization has not already arranged to make payment for you, you will need to pay the test-taking fee when you arrive.

Exam candidates taking exams for MOS or are asked to perform a series of tasks to clearly demonstrate their skills. For example, a Word exam might ask a user to balance newspaper column lengths or keep text together in columns. The new MOS exam format presents a short project the candidate must complete, using the specifications provided. This creates a real-world testing experience for candidates. All MOS exams must be completed in 90 minutes or less.

By using the practice files, you will not waste time creating the samples used in the lessons, and you can concentrate on learning how to use Microsoft Office With the files and the step-by-step instructions in the lessons, you will learn by doing, which is an easy and effective way to acquire and remember new skills. However, your instructor might ask you to copy the practice files on your own at the start of class.

Also, if you want to work through any of the exercises in this book on your own at home or at your place of business after class, you may want to copy the practice files.

In Internet Explorer, go to the student companion site: www. Search for your book title in the upper right hand corner 4. Select Student Companion Site from the pop-up box. A new screen will appear. On the Student Data Files page, you can select to download files for just one lesson or for all lessons. Click on the file of your choice. Remember the drive name that you saved it to.

An experienced technology and academic professional, he has served as an instructor, dean, and technology consultant for several schools. He has a broad range of experience in various areas of technology, including database management, network administration, web design, and programming.

Besides his interest in technology, he is an avid runner, having run in several marathons including New York and Boston. Last year, the new private high school opened with an enrollment of 12 students and with Jane and Shaun as the only full-time instructors.

All academic and business records were maintained manually by the founders. This year, however, you were hired as an executive assistant to help them manage an increasing amount of information. Enrollment is climbing, new full-time faculty members are being hired, and the school is receiving scholarship funds from local patrons.

In this lesson, you will learn basic database concepts and how to define data needs and types. In the next section, you will be asked to open a new blank desktop database in Access. When you do so, a screen appears that is similar to the one shown in Figure Understanding the screen elements helps orient you to important tools and information. The elements and features of your screen may vary if default settings have been changed or if other preferences have been set.

Use this figure as a reference throughout this lesson as well as the rest of this book. For example, as a database, a phone book organizes a large amount of data—names, addresses, and phone numbers—so you can access it by name in alphabetic order. Even a grocery list is a simple type of database.

A computerized database management system DBMS , such as Microsoft Office Access, enables you to easily collect large volumes of data organized into categories of related information. This type of database allows you to store, organize, and manage your data, no matter how complex it is, and then retrieve and present it in various formats and reports.

Organizing data by using a DBMS gives you the power to manipulate, view and report the data in ways that other applications like spreadsheets and word processing documents cannot. As with any program, however, the first tasks are the most basic. This section shows you how to start Access and open an existing database. Starting Access Access runs on either the Windows 7 or Windows 8 operating system, and the steps to start Access differ depending on the version of Windows you have installed on your system.

The Access startup screen allows you to create a new custom web app database, a blank desktop database, a database from a template, or open a recent database if you have already created one. You can also access Office. New to the Office System is the ability to sign into an Office application using your Microsoft or Organizational account. An Organizational account is an account that your workplace or school would use to connect you to a Microsoft service. Once you sign in, your sign-in information will appear in the upper-right corner of each of the Office applications.

This account information will include your name, e-mail address and user icon. You also have the ability to switch to a different user account using the Switch Account command beside your user icon. Microsoft enables you to sign into Office to make it easier for you to access and share your documents from virtually anywhere.

You can open and save your documents using Microsoft SkyDrive, a free cloud-based file sharing service that can be accessed from any Internet-connected computer. Signing into Office also allows access to your personalized application settings and themes, and will even remind you where you left off in your document. In this exercise, you learn to start Access from both a Windows 8 and Windows 7 system.

Your screen should look similar to Figure If necessary, scroll to the Access tile, as shown in Figure Figure Access tile 3. Click the Access tile. Figure The Access startup screen Create a new custom web app database Create a new blank desktop database Search Office.

You can then click on the appropriate application name to open it. Click Microsoft Office. Opening an Existing Database When you open an existing database, you access not only your previously entered and saved data, but the elements you created to organize that data. The Open Other Files command on the Access startup screen displays the Open screen, which allows you to pick a recently opened file by using the Recent command or by choosing a location to browse for a file.

You can locate files by using the Add a Place command to set up network locations like SkyDrive to browse files on the Internet. You can use the Computer command to find files stored locally in a folder on your computer or on a CD, DVD or other removable media, or on a network drive. Whether you browse for files using services such as SkyDrive or Office , or browse for files using the Computer command, you must use the Browse button to access the Open dialog box. When you find the file you want, double-click the filename to open it or click it once to select it and then click the Open button.

Another Way 1. Press Ctrl1O to display the Open screen. Returns you to the Access startup screen Allows you to create a new blank database or a database from a template Shows recently opened files Allows you to browse for files stored on the Internet in SkyDrive Allows you to browse for local files or those on removable media, or on a network Allows you to connect a Microsoft service such as Office SharePoint or SkyDrive Figure The Open screen 2. Navigate to the data files for this lesson and select Student Information.

Figure The Open dialog box Open button Database Essentials Take Note 7 Your figures might look slightly different depending upon which folder you have stored your files.

Figure The existing database open in Access Troubleshooting As part of the Microsoft Access security model, when you open a database outside of a trusted location or the database contains active content content that can be misused by an unscrupulous person to cause harm to your computer , a Message Bar appears, warning you that certain content has been disabled. If you know you can trust the database, click Enable Content.

Take Note Since you know you can trust the databases downloaded from the book companion website, click Enable Content on the Message Bar for all databases in this book. Clicking the Open button opens the database for shared access in a multi-user environment so that you and other users can read and write to the database. Others can still read and write. Others will receive a mes- sage that the file is already in use. Others can only view and not edit the database. You can open only one database at a time in a single instance of Access.

In other words, you cannot start Access, open one database, and then open another database-not without first closing the first database. You will immediately begin using the Navigation Pane and exploring the Ribbon. Also in this lesson, you will practice using other onscreen tools and features, such as the Backstage view and Access Help. It also lists all the objects in your database, including: tables the most basic database object that stores data in categories , queries allow you to search and retrieve the data you have stored , forms control data entry and data views and provide visual cues that make data easier to work with and reports present your information in ways that are most useful to you.

You learn more about managing database objects such as forms, queries, and reports in later lessons of this book. For now, just familiarize yourself with the Navigation Pane.

Using the Navigation Pane Before you can create a database, you need to understand its most basic elements. This section introduces you to some of the elements in a database that help you organize data and navigate using the Navigation Pane, object tabs, and different views.

In the Navigation Pane, double-click Students to display the table in the Access work area, as shown in Figure Figure A table open in the Access work area Double-click object in Navigation Pane to display it in the work area Take Note The Navigation Pane replaces an older tool, referred to as the Database window, which appeared in versions prior to Access Click the down arrow next to All Access Objects at the top of the Navigation Pane to display the menu, as shown in Figure Click Tables and Related Views.

The default group in this category is All Tables, which appears in the menu at the top of the Navigation Pane. Notice the Students table and all other objects related to it are displayed under the Students header. Click the down arrow next to All Tables at the top of the Navigation Pane to display the menu again, and click Object Type to return to the original view.

Right-click in the white area of the Navigation Pane to display a shortcut menu. Click View By and then choose Details, as shown in Figure The database objects are displayed with details.

Click the right side of the Navigation Pane and drag to make it wider so all the information can be read, as shown in Figure On the shortcut menu, click Search Bar. A search bar is now displayed at the top of the Navigation Pane. You can toggle the search bar display by clicking the Search Bar option. Display the Navigation Pane shortcut menu, click View By, and then click List to display the database objects in a list again. Notice it is not entirely hidden, as shown in Figure The Navigation Pane divides your database objects into categories, and those categories contain groups.

The default category is Object Type, which groups database objects by their type-tables, forms, reports, and so on. You can change the category to Tables and Related Views, which groups the objects in a database by the tables to which they are related. You can also change the category to one of several other views as shown in Figure Using Object Tabs When you create a database in Access, all the objects in that database—including forms, tables, reports, queries—are displayed in a single window separated by tabs.

Tabs help keep open objects visible and accessible. To move among the open objects, click a tab. To close a tab, click its Close button. You can also right-click a tab to display the shortcut menu, which you can use to save, close, close all, or switch views.

In this exercise, you practice opening and displaying object tabs. In the Navigation Pane, double-click Student Details. A new object tab opens to display the form, as shown in Figure Database Essentials Figure A tab showing a form 15 Object tabs 2. In the Navigation Pane, double-click All Students. A new object tab opens to display the report, as shown in Figure Figure A tab showing a report Close button on the report tab 16 Lesson 1 3.

Click the Close button on the report tab to close it. Right-click the Student Details tab to display the shortcut menu shown in Figure Figure The tab shortcut menu Right-click tab to display shortcut menu 5. Click Close to close the form. The main views for a table are Datasheet View and Design View. Datasheet View can be used to perform most table design tasks, so you will probably use it most often. A datasheet is the visual representation of the data contained in a table or of the results returned by a query.

A query is simply a question you can ask a table or another query. To change the view, click the bottom half of the View button and then choose a view from the menu. Last Updated : Based on Official Syllabus Topics of Actual Microsoft Exam During the preparation, you can be confused about Microsoft exam question types, exam pattern, and allocated time to attempt questions of the Microsoft Office Specialist certification exam.

Understand the Actual Exam Syllabus, Format, and Question Types Get official information about the syllabus and format of the exam to set an effective study plan.

Self-Asses your preparation for the actual Microsoft Access Exam Manage your daily routine to ensure that you have the proper time to study for the Microsoft Access exam every day. Microsoft Questions. Microsoft Exam Details. Microsoft Exam Syllabus. Submit Cancel. Currently there are no comments in this discussion, be the first to comment!

Yes No.