Using Databases in Office Base
External video
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
Accept YouTube Content
In Office Base, you can access data that is stored in a wide variety of database file formats. Office Base natively supports some flat file database formats, such as the dBASE format. You can also use Office Base to connect to external relational databases, such as databases from MySQL or Oracle.
The following database types are read-only types in Office Base. From within Office Base it is not possible to change the database structure or to edit, insert, and delete database records for these database types:
- Spreadsheet files
- Text files
- Address book data
Using a Database in Office
- To create a new database file, choose File - New - Database.
The Database Wizard helps you to create a database file and to register a new database within Office.
The database file contains queries, reports, and forms for the database as well as a link to the database where the records are stored. Formatting information is also stored in the database file.
- To open a database file, choose File - Open. In the File type list box, select to view only "Database documents". Select a database document and click Open.
Related Topics
- Viewing a Database
- Registering and Deleting a Database
- Creating a New Database
- Working with Tables
- Working with Queries
- Working with Forms
- Creating Reports
- Importing and Exporting Data in Base
- Database Overview
- Menus
- Database Toolbars
- Database Shortcut Keys
- Wiki page about Base ### Help about the Help The Help references the default settings of the program on a system that is set to defaults. Descriptions of colours, mouse actions, or other configurable items can be different for your program and system.
- The Office Help
- The Help Index
- Bookmarking Help pages
- Contents - The Main Help Topics
- Getting Support