If you own a version of Microsoft Office that includes Access (Office Professional 2010 is the most current version), but you’ve never used it, you’re overlooking a powerful tool for organizing and ...

A data dictionary is like a bill of materials for a database; it lists all database components, including reports, tables, field names and field types. Such information helps audit databases for ...

Microsoft Access software lets you create a small database you can use on your website. You must first create a new database, then create the tables that store the website information. Access is ...

Using Access to build a front end for SQL Server Your email has been sent What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your ...

There are various ways to interface with a database, including Access and HTML, but one approach takes advantage of legacy Microsoft ASP (with ADO/ADOX) to build a front end. This method, which I will ...

Even your least technical Access users can improve the performance of their databases. Susan Harkins shares some basic tips those users can put to work right away. Performance matters, even in a ...

I’ve been helping an administrative assistant (who also happens to be a close relative—see what comes of having a reputation for using technology?) who needs a database on her job to track employee ...