A database that you create in Microsoft Access is considered a file just like any other files you are familiar with. This means you can delete it using the same usual process. From My Computer or Windows Explorer, right-click the file's icon and choose Delete, then confirm or cancel your intentions.
To rename or move a database file, you have to do it manually. Unfortunately, Microsoft Access unusually doesn't provide a Save As feature to save a database in a different name. The Save As menu only renames an object
- Open Windows Explorer (Start -> Programs -> Windows Explorer ).
- In the folder you created for your own database projects, right-click Books and choose Delete. Click No.
- Highlight My Documents or the folder where the My Personal Resources database was saved. Right-click My Personal Resources and click Cut.
- Right-click the folder C:\Microsoft Access Exercises. and choose Paste.
- Right-click My Personal Resources. Click Rename to change the database's name and type:
Press Enter.
Exercises:
- Using the Database Wizard, create a database based on the Ledger sample. Name the database Personal Finances and make sure you save it in your default folder. Accept all fields defaults. For the screen display style, choose International. For the Reports style, choose Formal. Make sure you specify the database title as Personal Finances. Access the database properties. In the Comments box of the Summary tab, tell people who access your database, "Please don't change any of the fields or data in this database. Since this database is for my personal use, it is important that I keep track of the whole process of designing it.
- Create a blank database named your Project Name.
- Click the Office Assistant and type: How to create a database?
- Click Create a database.
- Click Create a database by using a Database Wizard.
- After reading, click the Back button.
- Click Create a database without using a Database Wizard.
- Continue exploring the Help files provided by Microsoft Access. When you finish, close the help window and the MS Access application.
No comments:
Post a Comment