database#3

• Microsoft Access 2010


  A database management program that lets anyone create a functional database as quickly as possible
• Datasheet


  Displays the information stored in a table in columns and rows. You can use a datasheet to create a table, enter data, retrieve data, and perform other tasks
• Field


  More than just a column: it is a way of organizing information by the type of data
• Record


  More than just a row, it is a unit of information. Every cell in a given row is part of that row's record
• Sharing Access 2010 Database


  • The Share part is especially valuable feature in MS Access 2010. It involves getting the access database on a program to be read through an online browser or to get people to see things on a web browser. The program can even be used to check on the compatibility that is used for getting the browser to work properly on a computer
• Quick Start Option in Microsoft Access


  • One unique feature of Access 2010 that was not available in prior editions of Access is the Quick Start feature. This can be used to add commonly used fields into a database table. This will be used to make it easier for an Access database to be created with different functions
• SharePoint Features with 2010 MS Access


  • An Access 2010 file can be moved to Microsoft SharePoint Server 2010. This can be used to get an Access 2010 file out to a server so it can be seen and edited by a variety of different people who have access to the same program over the Corporate Intranet. This online collaboration helps with better communication among team members across different geographical locations
• Microsoft Office Button


  In the upper-left corner of the Access window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks
• Programming with MS Access 2010

  • Another amazing feature about Access 2010 comes from how extremely easy it is to get a few lines of code added into a program. A user can work to handle databases without writing any piece of code. This works through a variety of 2010. ser to on different functions including the Expression Builder. This tool is used to calculate formulas with ease and without any errors involved in them. Underlying programming in Microsoft Access is done with Visual Basic for Applications
• Quick Access toolbar


  It is located above the Ribbon. It provides you with access to commands you frequently use. By default, Save, Undo, and redo appear on the Quick Access toolbar. You use Save to save an object, Undo to roll back an action you have taken, and Redo to reapply an action you have rolled back
• Title bar


  Located at the top in the center of the Access window. It displays the name of the database on which you are currently working
• Ribbon


  Located near the top of the Access window, below the Quick Access toolbar. This contains multiple tabs, each with several groups of commands. Some tabs, like Form Layout Tools or Table Tools, may appear only when you are working with certain objects like forms or tables. These tabs are called contextual tabs, and are highlighted in a contrasting color to distinguish them from normal tabs
• Backstage view


  Gives you various options for opening, saving, printing, and viewing more information about your database. It is similar to the Office Button Menu from Access 2007 or the File Menu from earlier versions of Access
• Status Bar


  Placed immediately above the Windows taskbar. It contains special information that is appropriate for the task on which you are working
• Navigation Pane


  The main control center of each access database. It shows you what is database and make the information accessible to you. You can open, rename, and delete objects using the navigation pane. Also you can choose to close the navigation pane, if you need more of the access window to complete the specific task
• Navigation form


  Opens automatically when the database is opened. Navigation forms are designed as a user-friendly replacement for the Navigation Pane. They contain tabs that allow you to view and work with common forms, queries, and reports
• View


  A way of looking at an object. For example, in Access, data is stored in tables
• Application part


  An Access template that you can add to an existing database, to extend its functionality. An application part can be as simple as a single table, or it can include several database objects, including tables, forms, reports, and even relationships
• Contacts part


  More complex and contain tables, queries, forms, reports, macros, and modules
• Data type


  An Access template that you can apply to an existing table, to extend its functionality
• Blank database


  A database with nothing in it. You must create all the tables, forms, reports, queries, and so on