77-424 microsoft access 2013 pdf free. 77-424 Dumps

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
This creates a real-world testing experience for candidates. Using the Ribbon The Ribbon is located across the top of the screen and contains tabs and groups of commands. Figure A relationship between tables 2. Instead of creating a new field to serve as a primary key and then entering the data for each record which can be a very time consuming process—you can instead combine two or more fields in your table to create a multifield primary key, or composite key. Select the First Name field.
 
 

Free Microsoft Exam Questions – Online Classes

 

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. From the point of view of technology, interapplication questions are Live questions’ more advanced version. If you answer a question wrongly, TEST4U will display a solution video for you to learn how to answer the question correctly. TEST4U allows you to monitor your progress yourself providing statistics for every question.

If you feel like talking about how TEST4U works, download our presentation file to accompany your speech! Get it here in:. TEST4U allows monitoring your performance yourself by providing statistics for all of your answers.

Statistics are available not only for every student but for every class as well. Thereby you can have a picture of the overall class performance. Your Microsoft Active directory administrator is required to take the following actions for this implementation:. Your server administrator needs to:.

Available languages: Greek , English, German. Unlimited Tests? For 12 months? 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. When you change views, the commands available on the Ribbon change context to match the tasks you will be performing in that view. You learn more about the Ribbon in the next section.

Change Views USE the database you used in the previous exercise. The Students table should be displayed in the Access work area. Database Essentials 17 Figure The View menu for a table 2. Click Design View. The table is displayed in Design View, as shown in Figure Figure The table shown in Design View Contextual design commands 3.

In this section, you explore the Ribbon, which displays groups of common commands arranged by tabs. Using the Ribbon The Ribbon is located across the top of the screen and contains tabs and groups of commands. It is divided into several tabs, which organize tasks according to similar commands you’d like to perform on a database. The Ribbon is contextual, which means it offers you commands related to the object that you are working on or the task that you are performing. Some groups have a dialog box launcher, which is a small arrow in the lower-right corner of the group that you click to launch a dialog box or task pane that displays additional options or information.

Some commands on the Ribbon have small arrows pointing down. These arrows indicate that a menu is available that lists more options from which you can choose.

In the next exercise you practice using the Ribbon. Click the HOME tab to make it active. As shown in Figure , the Ribbon is divided into groups of commands. Notice the dialog box launcher in the lower-right corner of the Clipboard group. Figure The Ribbon and dialog box launcher Dialog box launcher Groups of commands 2.

Notice that the groups of commands change. Click External Data and then Database Tools to see the commands available on those tabs.

Click the HOME tab. Click the ID column header in the table to select the ID column. Click the dialog box launcher in the lower-right corner of the Text Formatting group. The Datasheet Formatting dialog box appears, as shown in Figure Figure The Datasheet Formatting dialog box 7.

Click Cancel to close the dialog box. Double-click the HOME tab. Notice the groups are hidden to give you more screen space to work with your database. Double-click HOME again to display the groups. Selecting touch mode creates more space between the commands on the Ribbon which helps optimize menu access on touch-enabled devices. Mouse mode is the traditional mode optimized for mouse use. Located on the Quick Access Toolbar is the Customize Quick Access Toolbar button that presents you with a menu that allows you to quickly add commonly used commands to the Quick Access Toolbar, as shown in Figure You can use this menu to choose an option to show the Quick Access Toolbar above or below the Ribbon; you can also use this menu to click the More Commands button to open the Customize screen in the Access Options dialog box, as shown in Figure In this exercise, you use the Customize Quick Access Toolbar menu to place the toolbar below the Ribbon.

A menu appears. Click Show Below the Ribbon. The toolbar is moved. Click the Customize Quick Access Toolbar button again. Click Show Above the Ribbon. Every command on the Ribbon has a KeyTip. You learn to display KeyTips in the next exercise. Press ALT. Letters and numbers appear on the Ribbon to let you know which key to use to access commands or tabs. See Figure Press P to display the Application Parts menu. Take Note Shortcut keys are keys or combinations of keys pressed together to perform a command.

Shortcut keys provide a quick way to execute commands without having to move your hands off the keyboard and reach for a mouse. The Backstage view displays when you click the FILE tab and contains access to many of the commands that were on the File menu in versions prior to Microsoft Access The Backstage view enables you to access various screens that let you perform various tasks including creating a new database, creating a database from a template, opening an existing database, modifying user account settings and application options, and performing database maintenance tasks as seen in Figure Default screen.

Provides info, such as file location of open database, and provides access to maintenance tools and database properties Click to return to the workspace of the currently opened database Click to access New screen to create new databases from templates and new custom web app and desktop databases Click to access Open screen to select locations to browse for databases to open Click to access Account screen to change user account, add services, and change application settings Figure Backstage view Database Essentials 23 USING THE BACKSTAGE VIEW The Bottom Line The FILE tab on the Ribbon accesses the Backstage view—a menu of options and commands that allows you to access various screens to perform common tasks with your database files—such as opening, saving, printing, closing, and changing user account settings and options.

It also contains additional commands for managing your database. Using the Backstage View The FILE tab opens the Backstage view Figure , a menu of basic options and commands for opening, saving, and printing files, as well as more advanced options. You can click several options and commands to view related screens containing various options and commands used to create and manage your database. The Back button returns you to the Access database workspace. Use this option to view the current database file path and view and edit database properties.

Compact and repair the database and encrypt the database with a password to restrict access. You can save the database to a document management server for sharing or you can package the database and apply a digital signature. You can also back up the database. Change application background and theme. Add a service and activate Access with a product key.

You practice using the Backstage view in the next exercise. Click the FILE tab. Backstage view opens, displaying a menu of options down the left side of the window and information about the currently opened database, as shown in Figure Click the New option to view the options and commands available.

Click the Save As option to view more options and commands. Click the Back button to exit the menu and return to the Access workspace.

In fact, you can choose to use the help topics on your computer that were installed with Office or, if you are connected to the Internet, you can choose to use the help that is available online. In this exercise, you use the Help button to access the Help information installed on your computer with Access Using the Help Button and Change Help Collection Menu The Change Help Collection menu in the lower-right corner of the Access Help heading lets you choose between the help topics that are available online and the help topics installed in your computer offline.

Access also has Enhanced ScreenTips, which provide you with more information about the command. Database Essentials 25 USE the database you used in the previous exercise. Click the Microsoft Access Help button, as shown in Figure The Access Help dialog box appears, as shown in Figure Notice the Search box and Search button.

If the Change Help Collection is set to Access Help from your computer, the screen will look different. Click the Change Help Collection button. A menu appears, as shown in Figure Click Access Help from your computer. Basic Help appears, as shown in Figure In the Search help text box, key font and then click the Search button.

A list of possible locations on the Ribbon where fonts can be manipulated appears. Help on this topic appears. Another Way The Access Help button is positioned in some dialog boxes for quick access to context-related help.

Click it wherever you see it to launch Access Help. You can also launch Access Help by pressing the F1 function key on your keyboard. The Access Help dialog box is now pinned to the 6. Click the Keep Help on Top button front of the window so it is always on top and easily referred and not hidden even if another screen element is clicked.

Click the Back button 8. Click the Home button. The search results for font appear again. The home page of Access Help appears. Click Access Help from Office. Click the Close button to close Access Help. Leave Access open for the next exercise. When planning a database, the first step is to consider the purpose of your database. You need to design the database so that it accommodates all your data-processing and reporting needs.

You should gather and organize all the information that you want to include, starting with any existing forms or lists, and think about the reports and mailings you might want to create using the data. Once you have decided how the information will be used, the next step is to categorize the information by dividing it into subjects such as Products or Orders, which become the tables in your database.

Each table should only contain information that relates to that subject. If you find yourself adding extra information, create a new table. In a database table, data is stored in rows and columns—similar in appearance to a spreadsheet. Each row in a table is called a record. Each column in a table is called a field.

Once you have decided to create a Student List table, you need to determine what information you want to store in the table—such as Age, Birthdate, or Tuition. Organize each piece of information into the smallest useful part—for example, use First Name and Last Name instead of just Name if you want to sort, search, calculate, or report using either a first name or a last name or both.

These pieces of information will eventually become your fields columns , and each record row will then contain complete information about each student. For each table, you will choose a primary key. A primary key is a column that uniquely identifies each row, such as Student ID Number. Review Database Fields Reviewing preexisting database fields can give you an idea of the type of information that you can store in a database.

In this exercise, you open a database that is further along in the process of being developed and view the fields in a form to see what a more advanced database looks like. Figure The Student Details dialog box 2. Click the Guardian Information tab and then the Emergency Information tab.

Each field on each tab is an example of the type of information that could be contained in a database table. Click Close to close the Student Details dialog box. Cross Ref You learn more about defining and modifying a primary key in Lesson 3. Defining and Modifying Data Types for Fields When designing the database, you set a data type for each field column that you create to match the information it will store.

When defining table fields, it is important to define them as specifically as possible. For example, if you are using a number, you should determine whether you need to use the Currency data type, the Calculated data type, or the Number data type. Or, if you need to store large amounts of text, you may need to use the Long Text data type instead of the Short Text data type. Sometimes you may also need to modify data types for preexisting fields.

In this exercise, you practice reviewing and modifying data types. Database Essentials 29 When you create a new field in a table and then enter data in it, Access automatically tries to detect the appropriate data type for the new column.

The Short Text data type replaces the Text data type used in previous versions of Access; the Long Text data type replaces the Memo data type. The Short Text data type is used to store up to characters of data in a field and is a good data type for a field that stores small amounts of text, such as names, cities, and states.

To store data greater than characters, you can use the Long Text data type. The Long Text data type can display up to 64, characters on the screen, but can store about one gigabyte of text.

This data type can be used for a field that contains large amounts of text, like customer comments. Close the Student List form. In the Navigation Pane, in the Students group, double-click the Students table to open it. Click the Date of Birth field header. In the Format box, click the down arrow to display the menu of formatting options for that type, as shown in Figure Click the Last Name header. Notice that the Data Type is Short Text and that no formatting options are available for that data type.

Scroll to the right and click the Address header. In the Data Type box, click the down arrow and then click Short Text to change the data type. Scroll to the far right and click the Click to Add column header.

Notice the name of the column header, Field1, is highlighted. Rename the field by keying Additional Contact Info on File?. Click outside the menu to close it. How do you change field data types?

Access provides 11 data types, each with its own purpose. Table describes the types of data that each field can store. Take Note The Number data type should be used only if the numbers will be used in mathematical calculations. For numbers such as phone numbers, use the Short Text data type. Take Note Some of the available data types in Access can only be chosen in table Design View and not from the Data Type drop down menu on the Ribbon. You will learn more about table Design View in Lesson 9.

The most common data type for fields. Can store up to characters of text, and numbers or a combination of both. Stores large amounts of text—up to 1 gigabyte GB —but only the first 64, characters of text, and numbers or a combination of both will be visible on the screen. Number Age: 19 Stores numeric data that can be used in mathematical calculations.

Grade: Tables often contain an AutoNumber field used as the primary key. Access uses 1 for all Yes values and 0 for all No values. Attachment Any supported type of file You can attach images, spreadsheet files, documents, charts, and other types of supported files up to 2 GB per record to the records in your database, much like you attach files to email messages.

Calculated FullName: John Derenzo Stores an expression based on two or more fields within the same table. In this exercise, you view a visual representation of the relationship between two tables. In a simple database, you might only have only one table.

Most databases, however, will have more than just one table. The tables you include in a database will be based on the data available. For example, a database of students might have a table for contact information, a table for grades, and a table for tuition and fees. In database applications like Access, you can create a relational database. A relational database stores information in separate tables and these tables are connected or linked by a defined relationship that ties the data together.

Figure A relationship between tables 2. Cross Ref You learn more about table relationships in Lesson 3. An important principle to consider when planning a database is to try to record each piece of information only once.

Duplicate information, or redundant data, wastes space and increases the likelihood of errors. Relationships among database tables help ensure consistency and reduce repetitive data entry. As you create each table, keep in mind how the data in the tables are related to each other.

Enter test data and then add fields to tables or create new tables as necessary to refine the database. The last step is to apply data normalization rules to see if your tables are structured correctly and make adjustments as needed. Normalization is the process of applying rules to your database design to ensure that you have divided your information items into the appropriate tables.

Database design principles include standards and guidelines that can be used to determine if your database is structured correctly. These are referred to as normal forms. There are five normal Database Essentials 33 forms, but typically only the first three are applied, because that is usually all that is required.

Create new tables for data that applies to more than one record in a table and add a related field to the table. Data can be brought into an Access database in a number of ways, including linking and importing. When defining tables, you have to decide whether data should be linked to or imported from external sources. When you import data, Access creates a copy of the data or objects in the destination database without altering the source.

 

77-424 microsoft access 2013 pdf free. Exam 77-424 Mos 2013 Study Guide For Microsoft Access

 
In this exercise, you create a new field and format it with the Attachment data type, then remove the attachment from your database records.

 
 

Microsoft Access [PDF] [ve9tlo0]

 
 
Figure A relationship between tables 2. It also contains additional commands for managing your database.