![]() ![]() A template is a ready-to-use database that contains all of the tables, queries, forms, and reports needed for performing a specific task. Note: You can get to Backstage view at any time by clicking the File tab.Īccess provides you with a wide variety of templates that you can use to speed up your database creation process. Commands in Backstage view generally apply to entire databases, not to objects inside of a database. When you start Access 2010, you see the Microsoft Office Backstage view, where you can get information about the current database, create a new database, open an existing database, and view featured content from .īackstage view also contains many other commands that you can use to adjust, maintain, or share your databases. In fact, Access comes with templates that you can use right away to track a variety of information, making things easy even for a beginner. You can create a database to help you keep track of just about any kind of information, such as inventory, professional contacts, or business processes. That way, for example, if a vendor's phone number changed, the information could be changed once in the vendor table, instead of in every event that involved the vendor.Īccess is a tool that you can use to quickly and easily develop relational database applications that help you manage information. The table with event information might have a field to relate it to the customer table, and a field to relate it to the vendor table. For example, an event planning relational database might contain a table with customer information, a table with vendor information, and a table with event information. Sometimes you need a relational database to track such information - a storehouse of data that has been separated into smaller collections of data (called tables) to eliminate redundancy, and then related together based on common bits of information (called fields). You can use calendaring software, but tracking financial information in a calendar isn't a good fit. If you use a word processor or spreadsheet program to do this, you can easily run into trouble with duplicate and inconsistent data. For example, suppose you are an event planner, and you want to keep track of all the details that you need to manage to make your events successful. Many people start using Access when the program that they are using to keep track of something gradually becomes less fit for the task. ![]() You can keep your data on your computer, or you can publish to the Web - so others can use your database with a web browser. Use a front-end/back-end application in several versions of AccessĪccess 2010 is a database application design and deployment tool that you can use to keep track of important information. Step 3: Connect the new front-end to the original database Step 2: Split the copy database, and use the original file as the back-end database Step 1: Make a copy of the existing database, and save it in a new format Use an Access database file in several versions of Access Use an earlier-version database in several versions of Access Use the Table Analyzer Wizard to organize your data ![]() Import an Excel worksheet as a table in a new database Import data from a spreadsheet or other program Import or link to data from another source Paste data from another source into an Access table ![]() Here are some basic database tasks that you can do to help you learn how to use Microsoft Access 2010. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |