Tutorial microsoft office access 2007 free. Access 2007 for Starters: The Missing Manual by Matthew MacDonald
Looking for:
Tutorial microsoft office access 2007 free. MS Access Tutorial |
Microsoft Access Tutorial—Free & Online
Access, like virtually every Windows program, lets you cut and paste bits of information from one spot to another. However, Access has a little-known ability that lets you copy an entire record. To pull it off, follow these steps:. This selects the record. Presto—an exact duplicate.
Access updates the ID column for your pasted record, giving it a new number. It automatically saves any changes you make. When you create a new database Section 1. When you add a table or another object to the database, Access saves the database again. And when you enter new data or edit existing data, Access saves the database almost instantaneously.
Instead, Access is more concerned with getting information in and out of the database as quickly as it can. If you want to trim your database back to size, you can use a feature called compacting. The only problem with the database compacting feature is that you need to remember to use it. If you want to keep your databases as small as possible at all times, you can switch on a setting that tells Access to compact the current database every time you close it.
Access opens the Access Options window where you can make a number of configuration changes. The automatic save feature can pose a problem if you make a change mistakenly. You can perform these tasks with Windows Explorer, but Access gives you an even easier option. You can read a quick no-nonsense Task Scheduler tutorial at www. If you want to save your database with a different name, in a different place, or using an older Access file format, you can use the trusty Save As command.
In other words, when you create a table or edit some data, Access updates the new file. If you want to go back to the old file, you either need to open it in Access, or use Save As again. You can use any of these approaches:. Double-click a database file. You can browse to it using My Computer, Windows Explorer, or just plop in on your desktop. Remember, Access databases have the file extension. Launch Access, and then look for your database in the Open Recent Database section on the right of the Getting Started page.
Access pops up a message bar with a scary-sounding security warning Figure At that point, you may want to reconfigure Access so it recognizes your files and learns to be a bit more trusting. Just click the X at the right side of the message bar to banish it. If you want to see more than one database at a time, you need to fire up more than one copy of Access at the same time.
Computer geeks refer to this action as starting more than one instance of a program. If you double-click another database file while Access is already open, then a second Access window appears in the taskbar for that database. I see an extra file with the extension. What gives? Along with Bobblehead. Access creates a. Access The Missing Manual covers more on how Access works with multiple users. Access handles old database files differently, depending on just how old they are.
However, if you change the design of the database, the new parts you add may not be accessible in Access If you open an older Access file like one created for Access 97, 95, or 2. Access always assumes you want to store databases in the My Documents folder. You can configure Access to use this folder with just a few steps:. The Access Options window appears. Instead, the table opens in an ordinary window that can float wherever it wants inside the main Access window.
This seems fine at first, until you open several tables at once. This somewhat unfriendly behavior is designed to be more like previous versions of Access. All you need to do is set a single configuration option for your database:.
In the list on the left, choose Current Database. Under the Application Options heading, look for the Document Windows Options setting, where you can choose Overlapping Windows the Access standard or Tabbed Windows the wave of the future.
Close and open your database so the new setting takes effect. For a retro touch, you can use the same setting to make a brand new Access database use overlapping windows instead of tabs. Creating a new database is the easiest task yet. Access takes you back to the Getting Started page, where you can create a blank database by clicking the familiar Blank Database button, as described earlier Section 1. For example, if you have more than one table, you need a way to move back and forth between the two.
The navigation pane shows the objects Section 1. The navigation pane has several different viewing modes, so you can home in on exactly what interests you. When you first create a database, the navigation pane shows only the tables in your database.
To really try out the navigation pane, you need a database with more than one table. Follow all the steps in Section 1. Not sure what table to create? Try creating a Collectors table that tracks all the friends you know who share the same bobbleheaded obsession. If you want to open a table, then, in the navigation pane, just double-click it. If you have more than one datasheet open at once, then Access organizes them into tabs see Figure In this situation, Access adds tiny scroll buttons to the left and right of the tab strip.
You can use these buttons to move through all the tabs, but it takes longer. So far, you know how to open a table using the navigation pane. You can actually perform three more simple tasks with any database object that shows up in the navigation pane:. Rename it. Right-click the object, and then choose Rename. Then, type in the new name, and then press Enter. Most people are happy to have the ribbon sit at the top of the Access window, with all its buttons on hand. However, serious data crunchers demand maximum space for their data.
To do so, just double-click any tab title. Just click a tab. If you click Home, the Home tab pops up over your worksheet. As soon as you click the button you want in the Home tab or click somewhere else in the Access window , the ribbon collapses itself again. The same trick works if you trigger a command in the ribbon using the keyboard, as described in Section If you use the ribbon only occasionally, or if you prefer to use keyboard shortcuts, it makes sense to collapse the ribbon.
Even when collapsed, the ribbon commands are available; it just takes an extra click to open the tab. Create a copy. Right-click the object, and then choose Copy. Right-click anywhere in the navigation pane, and then choose Paste. Delete it. Right-click the object, and then choose Delete. Access gives you a few more options for transferring database objects and tucking them out of sight. You probably already know that you can place a Windows shortcut on your desktop that points to your database file.
Now, any time you want to jump back into your database, you can double-click your shortcut. Just follow these steps:. This way, you can see the desktop behind Access, which is essential for this trick. Find the table you want to use in the navigation pane. Drag this table out of Access and over the desktop. Release the mouse button. Double-click this shortcut to load the Bobblehead database and open a datasheet right away for the Dolls table.
Skip to main content. Start your free trial. Chapter 1. Creating your First Database. Understanding Access Databases. Tip Designing a database is the process of adding and configuring database objects. Getting Started. Figure The Getting Started page is a bit of a cross between a Windows program and a Web page.
Use the links on the left to browse through different categories of templates ready-to-go databases that you can download and fill with your own information. Or check out the links on the bottom, which show you the latest Access news and tips. Creating a New Database. Tip You can get the Bobblehead database, and all the databases in this book, on the Web. The database Bobblehead. You can edit the file name by clicking 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. Understanding Tables. It also gives you the option to create your database in the format used by previous versions of Access.
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. Creating a Simple Table. In a table, each record occupies a separate row. Each field is represented by a separate column. 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 rows. The only problem with the example so far is that as you enter a new record, Access creates spectacularly useless field names. The problem with using these meaningless names is that they might lead you to enter a piece of information in the wrong place.
You could all too easily put the purchase price in the date column. To prevent these slip-ups, you need to set better field names. To choose better field names, double-click the column title. Next, type in the real field name, and then press Enter.
Section 2. Editing a Table. Edit mode. Tip You can also switch in and out of Edit mode by double-clicking a cell. Top: Normal mode. Bottom: Edit mode. Shortcut keys. Table Keys for Moving Around the Datasheet. Key Result Tab or Enter Moves the cursor one field to the right, or down when you reach the edge of the table.
Home Moves the cursor to the first field in the current row. End Moves the cursor to the last field in the current row.
Page Up Moves the cursor up one screenful. Keys for Editing Records. An Access user has been on an eBay buying binge and needs to add several dolls at once. Cut, copy, and paste. Click the margin to the left of the record you want to copy.
Right-click the selection, and then choose Copy. This copies the content to the clipboard. Scroll to the bottom of the table until you see the new-row marker the asterisk. Right-click the margin just to the left of the new-row marker, and then choose Paste. Open the database that you want to automatically compact. Click OK to save your changes.
Making Backups. That way, if you have several backup files, you can pick out the one you want. Saving a Database with a Different Name or Format. Make sure you click the right-pointing arrow next to the Save As menu command to see this submenu of choices. Just clicking Save As performs the default option, which saves a copy of the currently selected database object, not your entire database. Opening a Database. Access gives you a choice when you open a database file that was created in Access 97, 95, or 2.
If you choose to convert the database click Yes , Access copies the existing database into a new database file, in Access format. You can then edit this copy normally.
If you choose to open the database click No , Access opens the original file without making a copy. In the list on the left, choose Popular. In an old-style Access database, different windows can overlap each other. Click OK. Creating Another Database. The Navigation Pane. Browsing Tables with the Navigation Pane. Unhappy with the space consumed by the navigation pane? Click the button again to expand it back into view. Tip Not sure what table to create?
Using the navigation pane, you can open as many tables at once as you want. Access gives each datasheet a separate tabbed window. To move from one window to another, you just click the corresponding tab. Managing Database Objects. Do you want to use every square inch of screen space for your data? You can collapse the ribbon as shown here by double-clicking any tab. Click a tab to pop it open temporarily, or double- click a tab to bring the ribbon back for good. Get it now.
It is a file which stores the entire database. The database file is saved to your hard drive or other storage devices. Datatypes are the properties of each field. Every field has one datatype like text, number, date, etc. Macros are mini computer programming constructs. They allow you to set up commands and processes in your forms, like, searching, moving to another record, or running a formula.
Microsoft Access and Excel are very similar yet very different. Here, are some important difference points between both of them-. Note: We assume you have the latest Microsoft Access installed which comes bundled with Microsoft Office package. You will find the list of installed programs. Before we create a Database, lets quickly understand the holistic picture of what Database is, with particular reference to MS Access.
Result : The below window will appear. All the Database templates are displayed below. Step 2 We can select any template by clicking on it. Click on Contact Template for further reverence.
Step 6 Optionally, you can click on any of the objects from left navigation pane and open that object for further references and work. For, E. The first step in this Microsoft Access tutorial to store data in the database is creating a Table where data will reside. Post creation of the table, we can keep inserting the rows in the table. Step 1 First Click Create tab. Then from Tables group, click Table. Step 2 Table Dialog box appears.
And Click on the View you need to display. Steps 2 Select the Datasheet view option in the ribbon and add some data by entering the values in It. Updated Data will be Autosaved. Step 3 Select the row by clicking on the leftmost column and Right Click on the row. Step 4 Popup Window will appear to confirm the deletion of the record.
Displays the view, which allows you to enter fields, data types, and descriptions into your database table.
[PDF] Microsoft Access free tutorial for Beginners - Question Info
There's also live online events, interactive content, certification prep materials, and more. Saving and Opening Access Databases. Even though Microsoft has spent millions making Access easier to use, most acess still see it as mmicrosoft most complicated Office program on the block. Access seems more daunting than any other Office program because of the way that databases work. Quite simply, databases need strict rules. 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. All of this setup takes effort, and a good understanding of how databases work. 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 objectswhich are simply 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, gree the number of high-protein whey milkshakes you down each day, as three separate tables. Queries let tutoria, quickly perform an action on a table. However, you can also use queries to apply tutorial microsoft office access 2007 free. Forms are attractive windows that you create, arrange, ogfice colorize. Forms provide an easy way to view /38372.txt change the information in a table.
Reports help you print some or all of the information in a table. 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 /1733.txt about anything—from updating 10, records to firing off an email.
Access gurus refer to acccess these database ingredients as objects because you offlce them all in essentially the same way. If you want to use delta force xtreme 2 full version free for pc particular object, then you add it offiice your database, give it a name, and then fine-tune it. Designing a database is the process of adding and frree database objects.
For those keeping score, an Access database can hold up to 32, separate objects. But first, you need to learn a bit more about databases and the Access tutorial microsoft office access 2007 free.
The Getting Started page looks a little dizzying at first glance, but it really serves just three purposes:. For example, you can read helpful articles about Access, find timesaving tips, or download updates. All links open in a separate browser window. It lets you open a database you used recently.
Look for the Open Recent Data-base section on the right, which gives you a list. In fact, in the business world, different people often work separately on these two tasks.
For example, a summer student whiz kid at a beer store may magix samplitude pro x3 suite language patch free a offfice for tracking orders task 1. The sales department can then use the database to enter tutorial microsoft office access 2007 free orders task 2while other employees look up orders and fill them also task 2.
Warehouse orfice can make sure stock levels are OK again, task 2and the resident accountant can keep an eye on total sales task 2. If task 1 creating the database is done well, task 2 using the database can be extremely easy. In fact, if the database is well designed, people who have little understanding of Access can still use it to enter, update, and look tutorial microsoft office access 2007 free information.
It lets you create a new database. You can start off with an empty database use the Blank Database buttonor you can try to find a ready-made template that fits the microslft.
You may think that it would be nice to customize the Getting Started page. A business could add links to a company Web site or a commonly used database template. Templates are prebuilt databases.
Templates aim to save читать статью the work of creating your database, and let you jump straight to the fine-tuning and data-entry stage. Bobblehead dolls usually resemble a famous celebrity, politician, athlete, or fictional character.
You can get the Bobblehead database, and all the databases in this book, on the Web. Check out Section tutorial microsoft office access 2007 free On the Getting Started page, click the Blank Database button. A side panel appears on tutorial microsoft office access 2007 free right see Figure Access stores all the information for a database in a single file with the extension.
Instead, pick something more suit-able. In this example, Bobblehead. Depending on your computer settings, Windows may hide tutorial microsoft office access 2007 free extensions. Instead of seeing the Access database file MyScandalousWedding. In this case, you can still tell the file type by looking at the icon.
If you ссылка на подробности something else like a tiny paint palettetutprial need to make a logical guess about what type of file it is. Like all Office programs, Access assumes you want to store every file you create in your personal My Documents folder.
Click the Create button at the bottom-right of the Access window. Access creates your database file and then pops up a datasheet where you can get to work creating your first table.
Once you create or open a database, the Access window changes quite a bit. An impressive-looking toolbar the ribbon appears at the top /14345.txt your screen, and a navigation pane shows up on the left.
The Introduction covers the basics of how imcrosoft ribbon works. Jump to Section Tables are information containers. But if you find yourself wanting to store several lists of 20007 information, then you need more than one table.
In tutorial microsoft office access 2007 free database BigBudgetWedding. Figure shows a sample table. In the Dolls table, for example, tutkrial record represents a single bobblehead doll. In a Family imcrosoft, each record would represent a single relative.
You get the idea. Each field stores a distinct piece of information. Tables have a rigid structure. But in order to get you started, Access creates your first database object—a tutirial named Table1. The problem is, this table begins life completely blank, with no defined fields and no data. If you перейти на источник the steps to create a new database Section 1. All you need to do is customize this table microeoft that it meets your needs.
If you try to open Bobblehead. Earlier versions of Access use the. Although Access is happy offic both. And just to make life more interesting, the. The standard. But if you need to share databases with other versions ffee Access, skip the new kid on the block, and rely instead on the tested-and-true. To create an old-style. You can choose the Access file format, or the even older Access format.
Many database gurus suggest that before you fire up Access, you should decide exactly what information you want to store by brainstorming. Next, jot down all your must-have pieces of information on a acvess of paper. Some details are obvious. Other details, like the year it was microosoft, the company that created it, and a short description of its appearance or condition may require more thought. The bobblehead doll example demonstrates an important theme of database design: First you plan the database, and then you accwss it using Access.
Design view lets you precisely define all aspects of a table before you start using it. Datasheet view is where you enter data into a table. Datasheet view also lets tutorial microsoft office access 2007 free build a table on the fly as you insert new information. The following steps show you how tutorial microsoft office access 2007 free turn a blank new table like Table1 into the Dolls table using the Datasheet view:. To define your table, you need to add your first tutoorial.
In this case, that means mentally picking a bobblehead doll to add to the list. Access tables are unsorted freee, which means they have no underlying order.
Comments
Post a Comment