How to Create a Database in Access First, launch Access and choose File, New. Since you’ll be building this database from scratch, choose Blank database. Access offers templates to quick-start a ...

Click the arrow next to "All Access Objects" to open a drop-down menu. Click the type of Access object that you want to convert; for example, select "Tables" to make a Web page from table data.

Click Database Tools and click Compact and Repair Database in the Tool group. A Database to Compact From dialog box will open. In the dialog box, choose an Access File and click the Compact button.

In Microsoft Access, you can rename or delete a database table or other objects such as forms, reports, and queries. We show you how to do it.

MS Access is a milder version of the popular client/server database system SQL Server that is ideal for small businesses. However, if necessary, Access databases can be easily converted to SQL Server.