Without using a Database Wizard
You can create a blank database and then add the tables, forms, reports, and other objects later. Although this method offers you flexibility, it also requires you to define each database element separately. Either way, you can modify and extend your data
- Click New
on the toolbar. - Click New File > New > Blank Database.
- In the File New Database dialog box, specify a name and location for the database, and then clickCreate.
4. The Database window appears, and you can create the objects that you want in your database.
The next step for Michael is to plan a structure for his database. He begins by making a list of the reports that he wants.
Reports
- First report: This report will help Michael to determine if the skill levels required for new employees need to be increased at the time of recruitment or if the existing personnel require additional training. The fields in this report include:
- Job Position
- Skills, (yes or no fields)
- Employee name
- Summarised data
2. Second Report: This report is an emergency list that will serve as a reference for the personnel. The fields in this report include:
- Employee’s last name
- Employee address
- Employee’s emergency contact information
Michael is also planning to build a form, so that the administrative personnel can easily enter employee details into the database.
