ONLINE UNIVERSITY DATABASE CREATION

Working with MS Access

To create a new Database, open the MS Access and select ‘Blank Access Database’ and click at OK. This is shown below:



Then another window will be opened as shown below. In this window we can select the Drive where we want to save this database file.




After selecting the Drive, assign a name to the Database file, which we are going to create and click at the button. Then another window will be opened as shown below:





In the above figure, we can see that three ways to create a database. Among this, select the second one (as shown in the picture) and double click on it. Then another window will be selected as shown below:




Here we can select the subject for the ‘Sample Tables’ by choosing ‘Business or Personal’. Here I chose ‘Book’ as the subject for the Sample Tables. If we choose a


Subject for the Sample Tables, its possible attributes will be appeared on the ‘Sample Fields’. From this field we can choose the fields that we would like to have. Here I selected ‘BookID, Title and Copyright Year’. This can be done by clicking the button while keeping a sample field is selected. After this, click next and another window will be opened as shown below:





Here also click ‘Next’ and the next window is shown below:



Here click at ‘Finish. Then another window will be opened as shown below

In this window, we can enter the values for the attributes such as ‘Book ID, ‘Title and Copyright Year’. After entering all the values to the fields, press ‘Ctrl + W’ for saving the file

Introduction

Synopsis

Preface

1. SYSTEM ANALYSIS

1.1  Analysis Report

1.2  Requirement Specification

    

2. PROJECT PLAN

2.1  Project plan

2.2  Specifications

2.3  PERT and CPM

2.4  Minutes of Group Meetings

3. SYSTEM DESIGN

3.1  Data Flow Diagram

3.2  Table and View Structures

3.3  Screen Layouts and Validations

3.4  Testing Methods

3.5   User Manual

3.6  Programming Language Used

   

4. Implementations and Future Enhancements