You can create a database using existing personnel data files in minutes if you store your personnel data in an external software application, such as a spreadsheet. Microsoft Access will read your spreadsheet and load a Microsoft Access database that gives you a relational database management system for reporting and updating.
- Skill level:
Other People Are Reading
Things you need
- Personnel data file
- Microsoft Access
Click "Start," "All Programs," then "Microsoft Access." The "Microsoft Access" dialogue box will open with database options.
Click the radio button for "Blank Access Database" and click "OK." The "File New Database" dialogue box will open.
Choose a name for your personnel database and type this in the "File Name" section of the "File New Database" dialogue box. If you like, you can use the default database name that Microsoft Access chooses for you. Click "Create" and the personnel database will appear.
Click "File," "Get External Data," then "Import." This will bring you to the "Import" dialogue box where you can access your external personnel data file. Find your external personnel file, click on it and click "Import."
Now you will see the "Import Spreadsheet Wizard" and a display of your external data file. Click "Next" and click the box next to "First Row Contains Column Headings" if your spreadsheet contains a first row with column headings.
Click "Next" and "In a New Table" should be checked. Click "Next" to see the Fields that will be in your database. Click "Next" again and make sure "Let Access Add Primary Key" is checked. Click "Next," enter a name for the Access database personnel file and then click "Finish."
You will see your new personnel database loaded as a table into your Microsoft Access database window. Now you can manage this table as you would any other database table in Microsoft Access.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for