microsoft access 2013 guide
LINK 1 ENTER SITE >>> Download PDF
LINK 2 ENTER SITE >>> Download PDF
File Name:microsoft access 2013 guide.pdf
Size: 3358 KB
Type: PDF, ePub, eBook
Category: Book
Uploaded: 15 May 2019, 22:17 PM
Rating: 4.6/5 from 708 votes.
Status: AVAILABLE
Last checked: 7 Minutes ago!
In order to read or download microsoft access 2013 guide ebook, you need to create a FREE account.
eBook includes PDF, ePub and Kindle version
✔ Register a free 1 month Trial Account.
✔ Download as many books as you like (Personal use)
✔ Cancel the membership at any time if not satisfied.
✔ Join Over 80000 Happy Readers
microsoft access 2013 guideCreate a database, tables, add a form, query data, and more. For other versions, see below. It assumes a basic understanding of databases and how they work. There's not much difference in functionality between Access 2016 and 2013, so you could do both tutorials with either 2013 or 2016. See how far Access has come since the early days. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours. With Step by Step, you set the pace—building and practicing the skills you need, just when you them. Includes downloadable practice files and a companion eBook. Build a database from scratch or ready templates Create easy-to-use data-entry forms Write queries to extract and manipulate data Design reports to summarize data in effective ways Import data from other databases and documents Right-click the file, click Extract All, and then follow the instructions. Any errors that have been confirmed since this book was published can be downloaded below. But it’s not just any old search. So no need to rebuild the same queries over and over again. Simply open it from the database and it’s ready to go. No need to enter data into those fields (remember, one’s an AutoNumber and the other has a Default Value set). Only enter data into the two middle fields of each table. Enter data into the Customers table and the Products table first. Then once all the primary keys are populated, you can enter data into the Orders table. You need to do this because we set up the database to enforce referential integrity. This means you won’t be able to enter a value into a foreign key field that doesn’t correspond to a value in the primary key field.http://artecgroupservices.com/imagenes/eurodesk-sx2442-manual.xml
- Tags:
- ms access 2013 guide pdf, microsoft access 2013 manual pdf, microsoft access 2013 manual free download, microsoft access 2013 user guide, microsoft access 2013 the complete guide pdf, ms access 2013 lab manual, microsoft access 2013 guide, microsoft access 2013 guide download, microsoft access 2013 guide free, microsoft access 2013 guide book, microsoft access 2013 guide online, microsoft access 2013 guide for beginners, microsoft access 2013 guide printable, microsoft access 2013 guide answers, microsoft access 2013 guide manual.
You could also use the Query Wizard button next to it to launch the Query Wizard, however, Design view gives you more control over the query. Select all, click Add, then click Close: You can also include other queries to use within a query. This allows you to specify the exact criteria you’d like to use in the query. You can choose which tables are shown in the results, which fields to use, add filtering criteria, and more. Clicking the View button next to it will also run the query. Also, it is using a third table ( Orders ) but not displaying any fields from that table. We could just as easily have included fields from the Orders table, but we didn’t need them in this case. Just right click on the Query tab and click Save. Call it Customer Orders: We’ll make it a form that enables users to enter new customers. So when a user enters data into the form, that data will be inserted into the Customers table. If you select a table or query, Access will automatically create a form based on the selected object. So to create a form based on the Customers table, all you need to do is select that table before creating the form. Clicking this button will create a form based on the selected table or query. Layout view allows you to set up your form while it is populated with real data. You can even enter data while in this view: Clicking “Form View” (highlighted) will display the form as the user will see it. If prompted to save the form, call it Customer Form and click OK. This is how the user will see the form. You’ll see a grid across the background, which helps align elements such as labels, and input controls. You will also notice that no data is displayed in the form. This allows you to make changes without data getting in the way. You can use this to make specific adjustments to the controls on your form. Try doing this to the CustomerId and DateCreated fields.http://happysteelindustry.com/userfiles/everstar-air-conditioner-mpm1-10cr-bb6-manual.xml You can also modify the labels (eg, add a space to FirstName to make it First Name, etc) Don’t be afraid to switch between views to see how it looks. A macro is a set of actions that can be run automatically. For example, can have a macro run whenever the user clicks a button, or you can have it run automatically when they open the database. That will save you from having to find the form and double click on it every single time you open the database. Select OpenForm from the combo box: Use these settings: This allows you to add any parameters you require for the action. This time select GoToRecord. This will make the form open a new record every time the macro runs. This example is setting the macro to open a new record whenever it is run. Be sure to name it AutoExec. This is a special name that causes the macro to run every time the database is opened. By using this name, the macro will be run every time the user opens the database. Test it out. Close the database, then open it again. You should see the Customers Form open at a new record, ready for a new customer to be entered. You might not want any running every time the database opens. So, the macro won’t run until the user clicks the button. Overwhelmingly, our customers are choosing the cloud to empower their people—from frontline workers on the shop floor, to on-the-go sales teams, to remote employees connecting from home.Maybe it’s your mask. But also, your mobile phone, right. The 13-digit and 10-digit formats both work. Please try again.Please try again.Please try again. MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.http://dev.pb-adcon.de/node/24003 The method is very effect for teaching concepts and skills. I have taught Microsoft Office Certification Exam preparation course for Microsoft Office 2003, 2007, 2010 and 2013 programs. The books that I wrote for these course met the Microsoft Vendor of Approved Courseware for the Microsoft Office 2010 and 2007(MCAS). There are over 60 Computer Mama courses available online. During the summer, Alex and I participate in the High School Career Challenge. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. webpages.Full content visible, double tap to read brief content. Videos Help others learn more about this product by uploading a video. Upload video To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzes reviews to verify trustworthiness. This course explains key concepts and terms, the first steps in database design, and how to build tables. This course covers the types of relationships and how to build each one. Access gives you templates that run on your computer or in the cloud. Course covers the types of queries, creating Select queries, criteria, joins, and intermediate tables It's a gentle introduction to Access. We’ll go over the two kinds of databases you can create: browser-based Access apps and desktop databases. This course explains the most common causes and solutions, and provides links to information about other ways to deal with the problem. This course covers adding criteria to queries, using AND and OR logic, logical operators such as IN and BETWEEN, and how to use wildcards. You need a basic understanding of queries to complete this course. Parameters are a powerful way to filter your query results. Update queries can be a fast way to change a lot of existing data in one or more tables. This course shows the basics, plus how to use calculated fields and filter for part of a date value, as well as how to use the DateDiff and DateAdd functions to subtract and add date values. You need to be familiar with Access queries to complete this course. The various sections presented in this document will help you to build a solid knowledge foundation of the software. It includes an introduction to the Microsoft Access 2013 interface and covers the various aspects of database creation and management in Access 2013. You do not have to register for expensive classes and travel from one part of town to another to take classes. All you need to do is download the course and open the PDF file. This specific program is classified in the Database category where you can find some other similar courses.Introduction to Microsoft Access 2013.But also many other tutorials are accessibleYou should come see our Database documents. You will find your happiness without trouble. The latest newsThe best course and tutorial, and how to learn and use Introduction to Microsoft Access 2013. This course is designed for the absolute beginner; no prior database design or Microsoft Access experience is necessary in order to get the most out of this video tutorial. Starting with a tour of the interface, this computer based training video will show you how to design and create a table, build queries, and comprehensively demonstrates the creation, and functions, of forms and reports. As you move through the video tutorial, the course covers other topics such as; how to create advanced forms, customizing your reports, and building action queries. Finally, he will take you through the process of creating your own custom web app with Access 2013. By the completion of this training course, you will be capable of creating databases as well as reports and forms in Microsoft Access 2013, and you will have in-depth knowledge of the tools and functions available to you in this software. Working files are included, allowing you to follow along with the author throughout the lessons. Who this course is for: Beginners and Intermediate Users Show more Show less All courses are created by trained educators and experts in video based education. The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment. Show more Show less. You should be able to manage files, including saving, updating, and backing up files. This program can only be taken on a PC. It is not compatible with a Mac. You need a high-speed Internet connection and an e-mail account. You should also have Microsoft Office 2013 already installed: Access, Excel, Outlook, PowerPoint and Word. Description Microsoft Access 2013 Beginning MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Expert Certification. This program is also suitable for you if you are looking to learn about this software and expand your job possibilities.The method is very effect for teaching concepts and skills. It is a program for students with Asperger's Syndrome (autism) that focuses on job skills and training. We developed a Flash animation course that teaches the students how to create banner ads. Even though Microsoft has spent millions of dollars making Access easier to use, most people still see it as the most complicated Office program on the block. They’re probably right. Access seems more daunting than any other Office program because of the way that databases work. Quite simply, databases need strict rules. Other programs aren’t as obsessive. For example, you can fire up Word, and start typing a letter straight away. Or you can start Excel, and launch right into a financial report. But Access isn’t nearly as freewheeling. Before you can enter a stitch of information into an Access database, you need to create that database’s structure. And even after you’ve defined that structure, you’ll probably want to spend more time creating other useful tools, like handy search routines and friendly forms that you can use to simplify data lookup and data entry. All of this setup takes effort and a good understanding of how databases work. In this chapter, you’ll conquer any Access resistance you have, and learn to create a simple but functional database. Along the way, you’ll get acquainted with the slick Access user interface, and you’ll learn exactly what you can store in a database. You’ll then be ready to tackle the fine art of database design, which is covered in detail throughout this book. FREQUENTLY ASKED QUESTION: Using Someone Else’s Database Can I use an Access database I didn’t design. Although every database follows the same two-step process: first somebody creates it and then people fill it with information, the same person doesn’t need to perform both jobs. In fact, in the business world, different people often work separately on these two tasks. In fact, if the database is well designed, people who have little understanding of Access can still use it to enter, update, and look up information. Amazingly, they don’t even need to know they’re running Access at all. You’ll learn more about sharing Access with groups of people in Part 6. Understanding Access Databases As you already know, a database is a collection of information. In Access, every database is stored in a single file. That file contains database objects, which are the components of a database. Database objects are the main players in an Access database. Altogether, you have six different types of database objects: Tables store information. Tables are the heart of any database, and you can create as many tables as you need to store different types of information. A fitness database could track your daily running log, your inventory of exercise equipment, and the number of high-protein whey milkshakes you down each day, as three separate tables. Queries let you quickly perform an action on a table. Usually, this action involves retrieving a choice bit of information (like the 10 top-selling food items at Ed’s Roadside Diner or all the purchases you made in a single day). However, you can also use queries to apply changes. Forms are attractive windows that you create, arrange, and colorize. Forms provide an easy way to view or change the information in a table. Reports help you print some or all of the information in a table. You can choose where the information appears on the printed page, how it’s grouped and sorted, and how it’s formatted. Macros are mini-programs that automate custom tasks. Macros are a simple way to get custom results without becoming a programmer. Modules are files that contain Visual Basic code. You can use this code to do just about anything—from updating 10,000 records to firing off an email. Access gurus refer to all these database ingredients as objects because you manage them all in essentially the same way. If you want to use a particular object, you add it to your database, give it a name, and then fine-tune it. Later on, you can view your objects, rename them, or delete ones you don’t want anymore. Note Designing a database is the process of adding and configuring database objects. For those keeping score, an Access database can hold up to 32,768 separate objects. In this chapter, you’ll consider only the most fundamental type of database object: tables. But first, you need to create a blank database you can work with. Starting a Database When you start Access, you begin at the welcome page. From there, you’re just a few clicks away from generating a database of your very own. In this chapter, you’ll slap together a fairly straightforward database. This example is designed to store a list of prized bobblehead dolls. (For those not in the know, a bobblehead doll is a toy figure with an oversized head on a spring, hence the signature “bobbling” motion. Here’s how to create a blank new database: Start Access. Access starts you out with what is, for Microsoft, a remarkably streamlined window ( Figure 1-1 ). Here you can create a new database or open an existing one. Figure 1-1. When you start Access, you see this two-part welcome page. On the left is a list of recently opened databases (if you have any). On the right is a list of templates that you can use to create a new database. You’ll get the same list of templates as when you first launch Access. Click the “Blank desktop database” template. When you choose to create a blank database, that’s exactly what you get—a new, empty database file with no tables or other database objects. Starting from scratch is the best way to learn about Access. It’s also the favorite choice of database experts, who prefer to create everything themselves so it’s exactly the way they like it. Other templates let you create databases that are preconfigured for specific scenarios and certain types of data. The box on Templates: One Size Fits Some has more information. The cool-sounding “Custom web app” template is a special case. It lets you create a web-enabled database that runs on SharePoint. You’ll explore this new feature (and its limitations), in Chapter 20. No matter which template you click, Access pops open a new window that lets you choose a name and location for your new database ( Figure 1-2 ). UP TO SPEED: Templates: One Size Fits Some The example in this section shows you how to create a blank database. However, if you scroll down (on the right side of the Figure 1-1 ), you’ll find a long list of prebuilt databases, which are known as templates. Templates aim to save you the work of creating a new database and let you jump straight to the fine-tuning and data-entry stage. As you might expect, there’s a price to be paid for this convenience. Even if you find a template that stores the type of information you want to track, you might find that the predefined structure isn’t quite right. For example, if you choose to use the Home Inventory template to track all the stuff in your basement, you might find that it’s missing some information you want to use (like the projected resale value of your stuff on eBay) and includes other details you don’t care about (like the date you acquired each item). To make this template work, you’ll need to change the design of your table, which involves the same Access know-how as creating one. In this book, you’ll learn how to build your own databases from the ground up and customize every square inch of them. Once you’re an Access master, you can spend many fun hours playing with the prebuilt templates and adapting them to suit your needs. To give it a whirl, click one of a dozen or so templates that are shown in the main Access window. Or, even better, hunt for more by using the Search box at the top of the Access window, which scans through the thousands of templates available on Microsoft’s Office website. Type a file name for the database you’re about to create. Access stores all the information for a database in a single file with the extension.accdb (which stands for “Access database”). Don’t stick with the name Access picks automatically (like “Database1.accdb”). Instead, pick something more descriptive. In this example, Bobblehead.accdb does the trick. It’s generally safest to stay away from other special characters, some of which aren’t allowed. Figure 1-2. This database will be named Bobblehead.accdb. As you can see by the file path below the File Name box, it will be saved in the folder C:\Users\matthew\Documents. You can edit the file name by typing in the File Name box, and you can browse to a different folder by clicking the folder icon. Note Depending on your computer settings, Windows may hide file extensions. Instead of seeing the Access database file MyScandalousWedding.accdb in file-browsing tools like Windows Explorer, you may just see the name MyScandalousWedding (without the.accdb part on the end). In this case, you can still tell the file type by looking at the icon. If you see a small Access icon next to the file name, that’s your signal that you’re looking at an Access database. Choose the folder where you want to store your database. Like all Office programs, Access assumes you want to store every file you create in your personal Documents folder. If this isn’t what you want, click the folder icon to show the File New Database window, browse to the folder you want ( Figure 1-3 ), and then click OK. Figure 1-3. The File New Database window lets you choose where you’ll store a new Access database file. It also gives you the option to create your database in the format used by older versions of Access (.mdb), instead of the more modern format used by Access 2007, Access 2010, and Access 2013 (.accdb). To change the format, simply choose the corresponding Access version from the “Save as type” list, as shown here. Click the big Create button (under the File Name box). Access creates your database file and then shows a datasheet where you can get to work creating your first table. POWER USERS’ CLINIC: Telling Access Where to Store Your Databases Access always assumes you want to store databases in your Documents folder. And though you can choose a different location every time you save or open a database, if there’s another folder you need to visit frequently, then it makes sense to make that your standard database storage location. You can configure Access to use this folder with just a few steps: Make sure you’ve opened a database or created a new one. You can’t make this change from the window you see when you first start Access. The Access Options window appears. In the list on the left, choose General. In the page on the right, look for the “Creating databases” heading. Underneath, you’ll find a “Default database folder” text box. Type the path to the folder you want to use (like C:\MyDatabases ), or click Browse to navigate to it. When you’re finished, click OK to save your changes. Once you create or open a database, the Access window changes quite a bit. An impressive-looking toolbar (the ribbon ) appears at the top of your screen, and a Navigation Pane shows up on the left. You’re now in the control center where you’ll perform all your database tasks ( Figure 1-4 ). Figure 1-4. The navigation pane on the left lets you see different items (or objects) in your database. You can use the navigation pane to jump from a list of products to a list of customers and back again. The ribbon along the top groups together every Access command. This ribbon is the mission control that lets you perform various tasks with your database. The document window in the middle takes up the rest of the window. This window is where you’ll do your work, such as designing tables and entering data. If you haven’t used the ribbon before (either in Access or in another Office program), the Introduction covers the basics of how the ribbon works. Otherwise, carry on to the next section, where you’ll learn how to add a table to your brand-new, empty database. Building Your First Table Tables are information containers. Every database needs at least one table—without it, you can’t store any data. In a simple database, like the Bobblehead database, a single table (which we’ll call Dolls) is enough. But if you find yourself wanting to store several lists of related information, you need more than one table. In the database BigBudgetWedding.accdb, you may want to keep track of the guests that you invited to your wedding, the gifts that you requested, and the loot that you actually received. In Chapter 5, you’ll see plenty of examples of databases that use multiple tables. Figure 1-5 shows a sample table. Figure 1-5. In a table, each record occupies a separate row. Each field is represented by a separate column. In this table, it’s clear that you’ve added five bobblehead dolls. You’re storing information for each doll in five fields (ID, Character, Manufacturer, PurchasePrice, and DateAcquired). Before you start designing this table, you need to know some very basic rules: A table is a group of records. A record is a collection of information about a single thing. In the Dolls table, for example, each record represents a single bobblehead doll. In a Family table, each record would represent a single relative. In a Products table, each record would represent an item that’s for sale. You get the idea. When you create a new database, Access starts you out with a new table named Table1, although you can choose a more distinctive name when you decide to save it. Each record is subdivided into fields. Each field stores a distinct piece of information. For example, in the Dolls table, one field stores the person on whom the doll is based, another field stores the price, another field stores the date you bought it, and so on. Tables have a rigid structure. In other words, you can’t bend the rules. If you create four fields, every record must have four fields (although it’s acceptable to leave some fields blank if they don’t apply). Newly created tables get an ID field for free. The ID field stores a unique number for each record. (Think of it as a reference number that will let you find a specific record later on.) The best part about the ID field is that you can ignore it when you’re entering a new record. Access chooses a new ID number for you and inserts it in the record automatically. You’ll learn much more about ID fields on AutoNumber. UP TO SPEED: Database Planning for Beginners Many database gurus suggest that before you fire up Access, you should decide exactly what information you want to store by brainstorming. Here’s how it works. Some details are obvious. For example, for the bobblehead doll collection, you’ll probably want to keep track of the doll’s name, price, and date you bought it. Other details, like the year it was produced, the company that created it, and a short description of its appearance or condition may require more thought. Once you’ve completed this process and identified all the important bits of data you need, you’re ready to create the corresponding table in Access. The bobblehead doll example demonstrates an important theme of database design: First you plan the database, and then you create it using Access. In Chapter 5, you’ll learn a lot more about planning more complex databases. Creating a Simple Table When you first create a database, it’s almost empty. But to get you started, Access creates your first database object—a table named Table1. The problem is, this table begins life completely blank, with no defined fields (and no data). If you followed the steps in the previous section to create a new database, you’re already at the Datasheet view ( Figure 1-5 ), which is where you enter data into a table. All you need to do is customize this table so that it meets your needs. You can customize a table in two ways: Design view lets you precisely define all aspects of a table before you start using it. Almost all database pros prefer Design view, and you’ll start using it in Chapter 2. Datasheet view is where you enter data into a table. Datasheet view also lets you build a table on the fly as you insert new information. You’ll use this approach in this chapter. The following steps show you how to turn a blank new table (like Table1) into the Dolls table by using the Datasheet view: To define your table, simply add your first record. In this case, that means choosing a bobblehead doll to add to the list. For this example, you’ll use a nifty Homer Simpson replica. Note It doesn’t matter which doll you enter first. Access tables are unsorted, which means they have no underlying order. However, you can sort them any way you want when you need to retrieve information later on. In the datasheet’s rightmost column, under the “Click to Add” heading, type the first piece of information for the record (see Figure 1-6 ). Based on the simple analysis you performed earlier, you know that you need to enter four fields of information for every doll. Although you could start with any field, it makes sense to begin with the name, which is clearly an identifying detail. Figure 1-6. To fill in your first record, start by entering something in the first field of information (like the doll name “Homer Simpson”). Then, hit Tab to jump to the second column, and then enter the second piece of information. Ignore the ID column for now—Access adds that to every table to identify your records. Press Tab to move to the next field, and return to step 2. Repeat steps 2 and 3 until you’ve added every field you need, being careful to put each separate piece of information into a different column ( Figure 1-7 ). You may notice one quirk—a harmless one—when you add your first record. As you add new fields, Access may change the record’s ID value of the record (changing it from 1 to 2 to 3, for example). Because the new record hasn’t been inserted yet, every time you change the table’s design by adding a new field, Access starts the process over and picks a new ID number, just to be safe. However, there’s really no reason to worry about the ID number. As long as it’s unique—and Access guarantees that it is—the exact value is unimportant. Figure 1-7.