DATABASE
CONTENT
- Creating a Database
- Basic Operations on a Database
Creating a Database
A new database can be created in two ways:
- By using the DBMS wizard
- By creating a blank database using the DBMS tools.
Using the DBMS wizard
Load MS Access from the start button. The new file task pane will be displayed as shown below:
1. Click on the Start
2. Select All Programs.
3. Select Microsoft Office and then Microsoft Office Access.
4. Check for New Blank Database and then click on ‘Blank database’.
5. Type a name for your database into the ‘File Name’, box.
6. Click Create and you are in Access environment
When working in Access, you make use of tables. Tables are the most important object in the database.
You are viewing an excerpt of this lesson. Subscribing to the subject will give you access to the following:
- NEW: Download the entire term's content in MS Word document format (1-year plan only)
- The complete lesson note and evaluation questions for this topic
- The complete lessons for the subject and class (First Term, Second Term & Third Term)
- Media-rich, interactive and gamified content
- End-of-lesson objective questions with detailed explanations to force mastery of content
- Simulated termly preparatory examination questions
- Discussion boards on all lessons and subjects
- Guaranteed learning