Table- a list of information organized into columns and rows. You can see the groups of objects and objects themselves.ģ The database objects include: tables, queries, forms, reports, records, fields, macros and modules. ![]() When you open a database or create a new one, the names of your database objects appear in the Navigation Pane. A database is a collection of information. You can hide the Ribbon by clicking the small arrow to the left of the? (Microsoft Access Help) or by double clicking on any tab. When you hover over a command, you will see a screen with a short description of that command. Each tab has commands logically organized into groups with the names of the groups shown on the bottom. Ribbon Across the top of the screen is the Ribbon, with the red File tab and four others: Home, Create, External Data, and Database Tools. Select a command Click the Add button and command will appear on the right Click Ok and command will be added to Quick Access toolbar You can rearrange the commands by selecting one and clicking the up/down arrows on the right. Click the small arrow on quick toolbar Choose More Commands, you can see other commands you can add to it. (Quick Access toolbar and Ribbon will be grayed out if no database files are open.) Quick Access toolbar - gives access to frequently used commands, by default it contains the Save button, the Undo and Redo buttons. Click on the HOME Tab to see what is inside an Access file. It will be stored in your personal Documents folder unless you designate otherwise. In the File Name box, type a file name for the database you are about to create. The right column displays information about the available template highlighted. An Access template is a file that, when opened, creates a complete ready to use database application that can be customized to suit your needs. Change the number of files that appear in the list of recently used files Backstage View, click Options Click Client settings Under Display, in the Show this number of Recent Documents list, click the number of files you want to display.Ģ The center column of Backstage View has Available Templates. This feature is turned on by default, but you can turn it off, turn it back on, or adjust the number of documents it displays. Documents used recently can easily be viewed by clicking Recent. You can get to Backstage view at any time by clicking the File tab. Commands in Backstage view generally apply to entire databases, not to objects inside of a database. ![]() Publish your database to a SharePoint server so other people can use it over the web (choose Save & Publish) Configure all sorts of Access options (choose Options). Print some of the information in your database (choose Print). Compact, repair, and encrypt your database file (choose Info). (A database must be open to access many of these commands.) Save a copy of your database (choose Save Database as). The left column of Backstage view contains commands that can be used to adjust, maintain, or share databases. ![]() You are presented with 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. You will learn how to build and maintain a database file, add tables, create forms and analyze data using filters, sort, and queries. You can use Access to manage anything from a home inventory to a giant warehouse of products. 1 Microsoft Access 2010 handout Access 2010 is a relational database program you can use to create and manage large quantities of data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |