guglbuys.blogg.se

1. #How to use microsoft office access 2007 pdf pdf#
2. #How to use microsoft office access 2007 pdf Pc#
3. #How to use microsoft office access 2007 pdf professional#
4. #How to use microsoft office access 2007 pdf windows#

#How to use microsoft office access 2007 pdf pdf#

An Access report saved as a PDF file can be opened by anyone (unlike Access snapshots, which are only viewable by recipients who have Access, or the Access Snapshot Viewer, installed). To exit Access, pull down the File menu (or Office menu) and select the Exit menu item.How to save a report to PDF file in Access 2007.įor many years now, Access users have wanted the option of saving a report to the PDF format. Then navigate to the drive, highlight the existing database file on the hard disk or USB drive and click the OK button again to open the database.

To open an existing database, choose Open an Existing Database, highlight More Files… and click on the OK button.Click on the OK button to create the new database. Be sure to use a descriptive name for the new database. To create a new database, choose Blank Database and specify a new file name for the database.Use the Start button on the task bar to open: Programs -> MS Office -> Microsoft Access.Note that the interfaces for Access 2007, 20 are all similar although the version that you use might appear slightly different from the pictures included in this tutorial. Design tab – This will appear when designing a new table, form, report, etc.Database Tools tab – Controls for managing databases (security, switchboard, etc.).External Data tab – Controls for loading data from other data sources into MS Access.Create tab – Controls for creating tables, forms, reports, etc.Home tab – Controls for changing fonts, performing queries, copy/paste/cut data, etc.

The following tabs will appear at the top of the screen: In addition, the default main screen after creating a new database automatically switches to the Design view to create a new table. Most of the tabs along the top of the screen have been rearranged. The screen layout for MS Access 2007 is significantly different from past versions. Once the new database is created, the following main Access screen will appear: Also, the name of the database should reflect the database’s contents. It is advisable to keep the name of the database (bankdb in the above example) relatively short and do not use spaces or other punctuation in the name of the database. accdb is the file name extension given for Microsoft DataBase 2007, 20 files.

In the above file name, bankdb is the name chosen for this particular database and. Fill in File Name as bankdb.accdb and click on the Create button to create the database as in the figure below. In Access 2007, click on the round Office button in the upper left corner and choose New from the drop down menu. Warning – If you have previously created a database, and then create it again using the same name, you will overwrite any work you have done.įor the purposes of this tutorial, if you are going through these steps for the first time, choose the option to create a new, blank database as shown in the above figure. After that point, use the Open existing database option to re-open the database created previously. In general, the first time one begins a project, a new, blank database should be created. Once Access is running, an initial screen will be displayed:įrom this initial screen, the user can create a new database (either blank or with some tables created with the database wizard), or open up an existing database.

#How to use microsoft office access 2007 pdf Pc#

Note that this arrangement of menus may vary depending on how MS Office was installed on the PC you are using.

#How to use microsoft office access 2007 pdf professional#

The MS Office Professional menu is shown below. To start Access, click on the Start button, then the Programs menu, then move to the Microsoft Office menu and finally click on the Microsoft Access menu item.

#How to use microsoft office access 2007 pdf windows#

As with most Windows programs, Access can be executed by navigating the Start menu in the lower left-hand corner of the Windows Desktop.